AutoSave O Off) 1) v v = BUSA2100_Module 3 Lesson 3 Excel Exercise - ChiSquare - Read-Only - Ex. Search Santablk Christmas X File Home Insert Page Layout Formulas Data Review View Help Share Comments X LO Arial v 10 A ab Wrap Text General AY O Paste BIU ~ E = Merge & Center ~ $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Formatting " Table Styles Filter * Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis 12 X V A B C DE F G H J K L M N 0 P Q R S T U V XA Observed Frequencies Observed Frequencies Variable 1 Calculations Celebrity Gender Variable 2 Up Down Total fo-fe Impact on Viewer Male Female Total Yes 10 10 20 0.0000 0.0000 Identified Product 41 61 102 No 10 10 20 0.0000 0.000 Could not identify 109 89 198 Total 20 20 40 Total 150 150 300 Expected Frequencies Your Response ariable 1 IN= Variable 2 Up Down Total (fo-fe)^2/fe Hypothesis (state in sentence form) 13 Yes 10.0000 10.0000 20 0.0000 0.0000 HO 14 No 10.0000 10.0000 20 0.0000 0.0000 Total 20 20 40 H1 Data 18 Level of Significance 0.05 19 Number of Rows Test Results 20 Number of Columns 2 Critical Value 21 Degrees of Freedom Test Statistic 22 23 Results Level of Significance 24 Critical Value 3.8415 p-value 25 Chi-Square Test Statistic 0.0000 26 p-Value 1.0000 Decision 27 28 Expected frequency assumption Conclusion 29 is met. 30 31 Problem 1 Problem 2 Problem 3 COMPUTE_FORMULAS + Ready + + 73% 9:02 AM Type here to search O X P ?a 590F ~ x10/25/2021