Question

Σ AutoSum Number Times New Roma 12A A Copy Format Painter | B 1 HI Meroe&Co ter . | $ . % , (-0.00 Conditional Format as Cell | Insert Delete Format Clear Ξ Ξ !-- Formatting Table Styles Styles - . g . A. Edi Alignment Number Clipboard xvfCHISQ.TEST(G7:18,G14:115) Likely Repurchase Yes Yes No Yes Yes Yes Count of owner Likely Repurchase No Yes Grand Total Automobile Chevrolet Impala Ford Fusio|Honda Accord Grand Total 56.00 69.00 125 80.00 120.00 200 52.00 123.00 175 188.00 312.00 500 Yes Yes 10 Yes Automobile Yes No Yes No No 12 13 Likely Repurchase Yes No Chevy Impala Ford focus Honda accord 78.00124 80 109.20 65.80 14 15 16 17 18 47.00 75 .20 p-value 0.00 No Yes 19 Data Sheett Sheetz ill Sheet: elest destination and press ENTER Ot choore Pastè 034 P

Why do I keep getting a zero for the p-value?

Answer 1

Solution:

The observed table is given below:

ChevroletImpala Ford Fusion Honda Accord Total No Yes Total 56 69 125 80 120 200 52 123 175 188 312 500 Expected Count ChevroletImpala Ford Fusion Honda Accord Total 125×188 500 125 x312 500 200x188 500 200×312 175 × 188 =47 =75.2 -65.8 No 500 188 175x312 -78 124.8 = 109.2 Yes 500 500 312 Total 125 200 175 500 The p-value is calculated using the below excelformula: - CHISQTEST (Observed - values, Expected - value 0.019.3

The excel screenshot is given below:

Test - Mic Home Insert Page Layout Formulas Data Review View Developer ぬCut Calibri Wrap Text Numb Copy Paste EE Merge &Center Format Painter Clipboard Font Alignment B12 CHITEST(B2:D3,B8:D9) Chevrolet Impala Ford Fusion Honda Accord Total 2 No 3 Yes 4 Total 52 123 175 188 312 500 69 120 125 200 6 Expected Count Chevrolet Impala Ford Fusion Honda Accord Total 8 No 9 Yes 10 Total 47 78 125 75.2 124.8 200 65.8 109.2 175 188 312 500 12 P-value 13 14 15 16 0.0193