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:
