Store | Vol/ml | Price |
---|---|---|

Ace Commercial | 500 | 1.60 |

Bamboo Inn | 500 | 1.85 |

Josaiah | 500 | 1.90 |

Panuelo | 500 | 1.95 |

En's 7 Star | 500 | 2.10 |

Ace Commercial | 1000 | 3.95 |

4TY | 1000 | 4.25 |

Panuelo | 1000 | 4.75 |

En's 7 Star | 1000 | 4.95 |

Ace Commercial | 1800 | 4.95 |

Panuelo | 1800 | 5.15 |

Wall Mart | 1800 | 5.40 |

4TY | 1800 | 5.95 |

En's 7 Star | 1800 | 6.25 |

- _______ What is the sample size n?
- _______ What is the mean price?
- _______ What is the sample standard deviation of the price?
- _______ What is the sample coefficient of variation for the price?
- _______ Calculate the slope of the best fit (also known at least squares) line for the data.
- _______ Calculate the y-intercept of the best fit line.
- ______________ Is the correlation positive, negative, or neutral?
- _______ What is the predicted price of a 1500 ml bottle of Yamasa soy sauce?
- _______ What is the predicted volume of a $3.00 bottle of Yamasa soy sauce?
- _______ Calculate the linear correlation coefficient r for the data.
- ______________ Is the correlation none, low, moderate, high, or perfect?
- _______ Calculate the coefficient of determination.
- _______ 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 | r^{2} |
=(CORREL(y data, x data))^2 |

Statistics • Courses • COM-FSM