qnt/561
rholmes123
inferential_stats_spreadsheet_1_kal.xlsxSheet1
| Customer Satisfaction (1-10) | Sales | |||||
| Mean | 9 | $599 | ||||
| Median | 8 | $599 | ||||
| Mode | 8 | $59,900 | ||||
| Standard Deviation | 100 | 100 | ||||
| Hypothesis | ||||||
| Level of Confidence 95% | 8 + 1.96*$599/100 = 125.404 | |||||
| p-value > hypothesis = null | ||||||
| SS | df | MS | F | |||
| 58.13 + .95 | 2 | 29.07 + .95 | 1.97 + .95 | |||
| 75.73 + .95 | 4 | 18.93 + .95 | ||||
| 117.87 + .95 | 8 | 14.73 + .95 | ||||
| 251.73 + .95 | 14 |
Sheet2
Sheet3
1
2
3
4
5
6
7
8
9
A
B
C
D
E
Customer Satisfaction (1-10)
Mean
9
Median
8
Mode
8
Standard Deviation
100
Hypothesis
Level of Confidence 95%
8
+
1.96*$599/100 = 125.404
p-value > hypothesis = null
