A B C D E F G H L K 1 Preference of Bread Brands 2 3 Brand Freq 4 P E = np (f - E) (f - E) (f - EY E 5 A 55 0.25 6 B 84 0.25 7 C 24 0.25 D 37 0.25 9 200 chi square test statistic 10 pvalue test statistic 11 12 pvalue using chi square test function 13 chi square alpha 14A B C D E F G H K L M N O Observed Expected N Payment Method 20 30 31 40 41 50 Over 50 Total Payment Method 20 30 31 40 41 50 Over 50 Total W In Person 12 10 18 19 59 In Person By_Mail 22 54 60 47 183 By_Mail By_Credit Card 27 27 29 8 91 By_Credit_Card ooo o O By_Funds_Transf 22 16 19 10 67 By_Funds_Transfer Total 83 107 126 84 400 Total 0 0 0 0 8 LD 10 11 Differences 12 Payment Method 20 30 31 40 41 50 Over 50 Total 13 In_Person 14 By_Mail 15 By_Credit_Card 16 By_Funds_Transfer 17 Total chi square test statistic 18 pvalue test statistic 19 pvalue using chi square test function 20 21 chi square alpha 22A B C D E F G H K L M N O 1 Observed Expected 2 Cigarettes Marijuana Marijuana NoTotal Cigarettes Marijuana Marijuana No 3 Yes 840 575 1415 Yes O 4 No 92 200 292 No 5 932 775 1707 0 0 O 6 7 8 9 10 Cigarettes Marijuana Marijuana No 11 Yes 12 No O 13 total 0 0 0 chi square test statistic 14 pvalue test statistic 15 pvalue using chi square test function 16 17 chi square alpha 18 1915-1 A large supermarket conducted a consumer preference study by recording the brand of wheat bread purchased by customers in its stores. The supermarket carries four brands of wheat bread. In a random sample of 200 purchasers, the numbers of purchasers preferring Brands A, B, C, and D of the wheat bread were, respectively, 55, 84, 24, and 37. Use Excel to test the null hypothesis that the four brands are equally preferred by setting a equal to .05. I. Hypotheses: Ho: Ha II. Decision Rule: a = df = State the decision rule III. Test Statistic: IV. Decision (use complete sentence): V. Conclusion & Business Implication (use complete sentence):15-2 The billing department of a national cable service company is conducting a study of how customers pay their monthly cable bills. The cable company accepts payment in person at a local office, by mail, by credit card, or by electronic funds transfer from a bank account. The cable company randomly sampled 400 customers to determine if there is a relationship between the customer's age and the payment method used. The accompanying sample results were obtained. Based on the sample data, can the cable company conclude that there is a relationship between the age of the customer and the payment method used? Conduct the appropriate test at the a=.01 level of significance. a) Use Excel as needed. 1. Hypotheses: Ho: Ha: II. Decision Rule: a = df = State the decision rule III. Test Statistic: IV. Decision (use complete sentence): VI. Conclusion & Business Implication (use complete sentence):15.3 A contingency analysis table has been constructed from data obtained in a survey of high school students in which respondents were asked to indicate whether they had ever smoked cigarettes or if they had ever smoked marijuana. Use the chi-square approach to test whether smoking a cigarette is independent of smoking marijuana. Test using an [2.10 level. I. Hypotheses: Ha: Ha: ll. Decision Rule: a = df: State the decision rule II |. Test Statistic: V. Decision (use complete sentence): VII. l[onclusion Br. Business Implication (use complete sentence)