Question One
A market research company examines the relationship between wine consumption and whether a person likes to watch professional tennis on television. One hundred randomly selected people are asked whether they drink wine and whether they watch tennis. The following results are obtained:
Watch tennis |
Do not watch tennis |
Totals |
|
Drink wine |
16 |
24 |
40 |
Do not drink wine |
4 |
56 |
60 |
Totals |
20 |
80 |
100 |
1) What is the appropriate test for this problem?
2) Set up the null and alternative hypotheses.
3) Write the formula of the test statistic.
4) Calculate the test statistic based on the formula.
5) Use Excel to calculate the p-value. Should we reject the null hypothesis at 5% significance level?
6) Given the results of the test, does it make sense to advertise wine during a televised tennis match (assuming that the ratings for the tennis match are high enough)? Explain.
Question One A market research company examines the relationship between wine consumption and whether a person...
This problem needs to be solved on Microsoft Excel! METHODS AND APPLICATIONS 13.17 A marketing research firm wishes to study the relationship between wine consumption and whether a person likes to watch professional tennis on television. One hundred randomly selected people are asked whether they drink wine and whether they watch tennis. The following results are obtained: DS WineCons Do Not Watch Tennis Watch Tennis Totals Drink Wine 16 24 40 Do Not Drink Wine 4 56 60 Totals 20...
A marketing research firm wishes to study the relationship between wine consumption and whether a person likes to watch professional tennis on television. One hundred randomly selected people are asked whether they drink wine and whether they watch tennis. The following results are obtained: Do Not Watch Tennis Watch TennisTotals Drink Wine Do Not Drink Wine Totals 28 52 80 37 63 100 20 (a) For each row and column total, calculate the coresponding row or column percentage Row 1...
wwL 2.48 points oting rosoarch fim wishes to study the relationship betwoon wine consumption and whether a person likes to watch professional tennis on television. One hundred randomly selected people are askod whether they drink wine and whether they watch tennis. The following results an chraned Watch Totals Drink Wine 56 k Wine Tulalh (a) For each row and column total, calculate the coresponding row or column percentage. Row Columm 1 Column 2 (b) Far each cel, cakculate the CoNtespanding...
] A marketing research firm wants to investigate the relationship between chip consumption and whether a person likes to watch professional football on television. One hundred randomly selected people are asked whether they eat chips and whether they watch football on television. The following results are obtained: Watches football Does not watch football Totals Eats chips 20 45 65 Does not eat chips 5 30 35 Totals 25 75 100 1) State the null and alternative hypotheses [1 mark]: ________________________________________________________________________________________...