Quiz s23.3 s23.10 s41.11: Use the Yamasa soy sauce data for this quiz
Yamasa Soy Sauce Data Fall 2002
Ace Commercial5001.60
Bamboo Inn5001.85
En's 7 Star5002.10
Ace Commercial10003.95
En's 7 Star10004.95
Ace Commercial18004.95
Wall Mart18005.40
En's 7 Star18006.25
  1. _______ What is the sample size n?
  2. _______ What is the mean price?
  3. _______ What is the sample standard deviation of the price?
  4. _______ What is the sample coefficient of variation for the price?
  5. _______ Calculate the slope of the best fit (also known at least squares) line for the data.
  6. _______ Calculate the y-intercept of the best fit line.
  7. ______________ Is the correlation positive, negative, or neutral?
  8. _______ What is the predicted price of a 1500 ml bottle of Yamasa soy sauce?
  9. _______ What is the predicted volume of a $3.00 bottle of Yamasa soy sauce?
  10. _______ Calculate the linear correlation coefficient r for the data.
  11. ______________ Is the correlation none, low, moderate, high, or perfect?
  12. _______ Calculate the coefficient of determination.
  13. _______ What percent of the variation in volume explains the variation in price?
Basic Statistics
Statistic or Parameter Symbol Equations Excel
Square root     =SQRT(number)
Sample size n   =COUNT(data)
Sample mean x Sx/n =AVERAGE(data)
Sample standard deviation sx or s sampstdev.gif (1072 bytes) =STDEV(data)
Sample Coefficient of Variation CV 100(sx/x) =100*STDEV(data)/AVERAGE(data)
Linear Regression Statistics
Statistic or Parameter Symbol Equations Excel
Slope b   =SLOPE(y data, x data)
Intercept a   =INTERCEPT(y data, x data)
Correlation r   =CORREL(y data, x data)
Coefficient of Determination r2   =(CORREL(y data, x data))^2

Statistics Courses COM-FSM