plz write excel formulas of possible

G 18 D E 3 Question 2 H 4 Does the length of ads on YouTube increase the brand ad effectiveness? A study compared 30 seconds 5 and 2 minutes viewing audiences after watching a brand ad. Data were collected on whether the viewer 6 indicated that the ad made them want to visit the brand website. The results were in the following Fill in 7 the blanks in the table. 8 VIEWING MADE ME WANT TO VISIT 9 AUDIENCE THE BRAND WEBSITE 10 Yes No Total 11 30 seconds 316 60 12 2 minutes 278 98 13 14 15 a. Set up the null and alternative hypotheses to try to determine whether ad impact is stronger 16 following 30 seconds viewing than following 2 minutes viewing Set 30 seconds viewing 17 audience as population 1 Ho 19 H. 20 21 22 b. State which test is used for testing your hypothesis in part a 23 24 25 26 c. What is the test statistic of the hypothesis test in part a? Keep at least 2 decimal places Show work A 27 loss of marks will result for not showing work even if your answer is correct 28 Test Statistic 29 30 d. What is the critical value of test assuming 0 level of significance? Show work. A loss of marks will 31 result for not showing work even if your answer is correct 32 Critical Value 33 34 e. What are the decision and the conclusion of the test? Explain how you made the decision Instruction Question 1 Question 2 Total Ready KB e 20 L. What is the test statistic of the hypothesis test in part a? Keep at least 2 decimal places. Show work. A 27 loss of marks will result for not showing work even if your answer is correct 28 Test Statistic 29 30 d. What is the critical value of test assuming 0.01 level of significance? Show work. A loss of marks will 31 result for not showing work even if your answer is correct 32 Critical Value 33 34 e. What are the decision and the conclusion of the test? Explain how you made the decision 35 Decision 36 37 38 Conclusion: 39 40 41 42 f. If you were to use a p-value approach, would the p-value be greater than or less than the 0.01 level of 43 significance? Explain without doing calculation 45 46 -47 48 49 14 Instruction Question 1 Question 2 Total Ready KO NE