0.0/ 1.0 Points
Free Weights
Weight Machines
Endurance
Machines
Aerobics Equipment
Sum
0-10 Uses
12
17
25
13
67
11-30 Uses
20
18
9
9
56
31+ Uses
26
12
11
9
58
Sum
58
47
45
31
181
Free Weights
Weight Machines
Endurance
Machines
Aerobics Equipment
0-10 Uses
=58*(67/181)
=47*(67/181)
=45*(67/181)
=31*(67/181)
11-30 Uses
=58*(56/181)
=47*(56/181)
=45*(56/181)
=31*(56/181)
31+ Uses
=58*(58/181)
=47*(58/181)
=45*(58/181)
=31*(58/181)
Now that we calculated the Expected Count we can use Excel to find the p-value.
Use =CHISQ.TEST(highlight actual counts, highlight expected counts) = 0.0144
Question 12 of 20
Click to see additional instructions
The following sample was collected during registration at a large middle school.
At the 0.05 level of
significance, can it be concluded that level of math is dependent on grade level?
Honors Math
Regular Math
General Math
6
th
Grade
35
47
14
7
th
Grade
37
49
12
8
th
Grade
33
48
19
Enter the missing values in the expected matrix - round to 4 decimal places.
Honors Math
Regular Math
General Math
6
th
Grade
7
th
Grade
35
48
15
8
th
Grade
Answer Key:
34.2857, 47.0204, 14.6939, 35.7143, 48.9796, 15.3061

0.0/ 1.0 Points
Feedback:
We are running a Chi-Square Test for Independence. Copy and Paste the table into Excel. You are given the
Observed Counts in the table. We need to calculate the Expected Counts. Then sum up the rows and column.
You
need to find the probability of the row and then multiple it by the column total.
Honors Math
Regular Math
General Math
Sum
6th Grade
35
47
14
96
7th Grade
37
49
12
98
8th Grade
33
48
19
100
Sum
105
144
45
294
Honors Math
Regular Math
General Math
6th Grade
=105*
(96/294)
=144*(96/294) =45*(96/294)
7th Grade
=105*
(98/294)
=144*(98/294) =45*(98/294)
8th Grade
=105*
(100/294)
=144*(100/294)
=45*
(100/294)
Question 13 of 20
Click to see additional instructions
An electronics store has 4 branches in a large city.
They are curious if sales in any particular department are
different depending on location.
They take a random sample of 4 purchases throughout the 4 branches – the
results are recorded below.
Run an independence test for the data below at the 0.05 level of significance.
Appliances
TV
Computers
Cell Phones
Branch 1
56
28
63
24
Branch 2
44
22
55
27
Branch 3
53
17
49
33
Branch 4
51
31
66
29
Enter the test statistic - round to 4 decimal places.
Answer Key:
7.2612
Feedback:

0.0/ 1.0 Points
We are running a Chi-Square Test for Independence. Copy and Paste the table into Excel. You are given the
Observed Counts in the table. Next you need to sum the rows and columns. Once you have those you need to
calculate the Expected Counts.
You need to find the probability of the row and then multiple it by the column total.
Appliances
TV
Computers
Cell Phones
Sum
Branch 1
56
28
63
24
171
Branch 2
44
22
55
27
148
Branch 3
53
17
49
33
152
Branch 4
51
31
66
29
177
Sum
204
98
233
113
648
Appliances
TV
Computers
Cell Phones
Branch 1
=204*(171/648)
=98*(171/648)
=233*(171/648)
=113*(171/648)
Branch 2
=204*(148/648)
=98*(148/648)
=233*(148/648)
=113*(148/648)
Branch 3
=204*(152/648)
=98*(152/648)
=233*(152/648)
=113*(152/648)
Branch 4
=204*(177/648)
=98*(177/648)
=233*(177/648)
=113*(177/648)
Now that we calculated the Expected Counts we need to find the Test Statistic.