##### Quiz s23.3 s23.10 s41.11: Use the Yamasa soy sauce data for this quiz
Yamasa Soy Sauce Data Fall 2002
StoreVol/mlPrice
Ace Commercial5001.60
Bamboo Inn5001.85
Josaiah5001.90
Panuelo5001.95
En's 7 Star5002.10
Ace Commercial10003.95
4TY10004.25
Panuelo10004.75
En's 7 Star10004.95
Ace Commercial18004.95
Panuelo18005.15
Wall Mart18005.40
4TY18005.95
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 =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