In: Statistics and Probability
Person |
Did I offer them the s'mores drink |
Whether they said yes or no |
Age of person |
Person 1 |
Yes (Heads) |
No |
26 |
Person 2 |
No (Tails) |
N/A |
N/A |
Person 3 |
Yes (Heads) |
No |
42 |
Person 4 |
No (Tails) |
N/A |
N/A |
Person 5 |
No (Tails) |
N/A |
N/A |
Person 6 |
Yes (Heads) |
Yes |
13 |
Person 7 |
Yes (Heads) |
Yes |
13 |
Person 8 |
Yes (Heads) |
No |
72 |
Person 9 |
Yes (Heads) |
Yes |
39 |
Person 10 |
Yes (Heads) |
No |
26 |
Person 11 |
No (Tails) |
N/A |
N/A |
Person 12 |
No (Tails) |
N/A |
N/A |
Person 13 |
Yes (Heads) |
Yes |
52 |
Person 14 |
Yes (Heads) |
Yes |
19 |
Person 15 |
Yes (Heads) |
No |
21 |
Person 16 |
Yes (Heads) |
No |
36 |
Person 17 |
Tails (No) |
N/A |
N/A |
Person 18 |
Tails (No) |
N/A |
N/A |
Person 19 |
Tails (No) |
N/A |
N/A |
Person 20 |
Heads (Yes) |
Yes |
8 |
Person 21 |
Heads (Yes) |
Yes |
36 |
Person 22 |
Heads (Yes) |
Yes |
28 |
Person 23 |
Heads (Yes) |
No |
51 |
Person 24 |
Heads (Yes) |
No |
31 |
Person 25 |
Tails (No) |
N/A |
N/A |
Person 26 |
Heads (Yes) |
Yes |
15 |
Person 27 |
Heads (Yes) |
Yes |
15 |
Person 28 |
Heads (Yes) |
Yes |
15 |
Person 29 |
Heads (Yes) |
Yes |
18 |
Person 30 |
Heads (Yes) |
Yes |
28 |
Person 31 |
Tails (No) |
N/A |
N/A |
Person 32 |
Heads (Yes) |
Yes |
56 |
Person 33 |
Tails (No) |
N/A |
N/A |
Person 34 |
Tails (No) |
N/A |
N/A |
Person 35 |
Tails (No) |
N/A |
N/A |
Person 36 |
Tails (No) |
N/A |
N/A |
Person 37 |
Tails (No) |
N/A |
N/A |
Person 38 |
Heads(Yes) |
Yes |
17 |
Person 39 |
Hedas(Yes) |
Yes |
21 |
Person 40 |
Heads (Yes) |
No |
44 |
Person 41 |
Heads (Yes) |
No |
25 |
Person 42 |
Heads (Yes) |
No |
59 |
Person 43 |
Tails (No) |
N/A |
N/A |
Person 44 |
Heads (Yes) |
No |
42 |
Person 45 |
Tails (No) |
N/A |
N/A |
Person 46 |
Heads (Yes) |
Yes |
38 |
Person 47 |
Heads (Yes) |
Yes |
18 |
Person 48 |
Heads (Yes) |
Yes |
18 |
Person 49 |
Tails (No) |
N/A |
N/A |
Person 50 |
Heads (Yes) |
Yes |
25 |
1) Find the p-value
The given frequency and the expected frequency of different age groups were found.
Fourmula for expected frequency of each cell = (Row total*Column Total)/Total Sum
Formula for p-value in Excel is =CHITEST(observed_values,Expected_values)
P-VALUE is 0.09825
Find tables in the screenshot uploaded below: