Question: Dollars Spent Part a Formula 12 Mean 41.75 =AVERAGE(A2:A17) 70 24 Part b 66 Standard Deviation 23.44 =STDEV.S(A2:A17) 33 37 Part c 33 Degrees of
Dollars Spent |
| Part a |
|
| Formula |
12 |
| Mean | 41.75 |
| =AVERAGE(A2:A17) |
70 |
|
|
|
|
|
24 |
| Part b |
|
|
|
66 |
| Standard Deviation | 23.44 |
| =STDEV.S(A2:A17) |
33 |
|
|
|
|
|
37 |
| Part c |
|
|
|
33 |
| Degrees of Freedom | 15 |
| =COUNT(A2:A17)-1 |
42 |
|
|
|
|
|
52 |
| Lower Limit Critical Chi-square |
|
| #N/A |
19 |
| Upper Limit Critical Chi-square |
|
| #N/A |
11 |
|
|
|
|
|
97 |
| The 95% confidence interval |
|
|
|
44 |
| C.I.Lower Limit |
|
| #N/A |
35 |
| C.I.Upper Limit |
|
| #N/A |
66 |
|
|
|
|
|
27 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
What will the formulas be for the bottom four?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
