| Images | Horsepower | 
|---|---|
![]()  | 
    275 | 
![]()  | 
    300 | 
  ![]()  | 
    350 | 
![]()  | 
    365 | 
![]()  | 
    400 | 
  ![]()  | 
    525 | 
  ![]()  | 
    650 | 
  ![]()  | 
    760 | 
  ![]()  | 
    1050 | 
![]()  | 
    1775 | 
Use the horsepower data to perform the following calculations:
| Bins (x) | Frequency (f) | P(x) | 
|---|---|---|
| _______ | _______ | _______ | 
| _______ | _______ | _______ | 
| _______ | _______ | _______ | 
| _______ | _______ | _______ | Sum: | _______________ | _______________ | 
| Confidence interval statistics | |||
|---|---|---|---|
| Degrees of freedom | df | = n-1 | =COUNT(data)-1 | 
| Find a zc value from a confidence level c | zc | =ABS(NORMSINV((1-c)/2)) | |
| Find a tc value from a confidence level c | tc | =TINV(1-c,df) | |
| Calculate an error tolerance E of a mean for any n using sx. | E | =tc*sx/SQRT(n) | |
| Calculate a confidence interval for a population mean µ from a sample mean x and an error tolerance E | x-E≤ µ ≤x+E | ||