Question

QUESTION 8 To test whether the enactment of seatbelt legislation had any association with injuries to vehicle users, a random sample of 7676 individuals taken over a two-year period (one year prior legislation and one year post legislation) was used. The results are detailed below. Post Legislation 1320 Prior Legislation 5430 552 224 No Injury Minimal Injury Major Injury Fatal Injury Total 70 Total 6750 622 256 48 7676 32 10 1432 6244 What is the p-value (rounded to 4 decimal places)? QUESTION 9 To test whether the enactment of seatbelt legislation had any association with injuries to vehicle users, a random sample of 7676 individuals taken Click Save and Submit to save and submit. Click Save All Answers to save all answers Save All Answers
****A Bit confused on this one- the original answer i put for the p value was 0.0000 but was incorrect- any input would help!*****

Answer 1

The p-value is 0.0000 (try putting it as this format 0.0000)

However, if it is not picking up, then you can try putting in more accurate value as 0.000000391

p=0.0000003912730495

Test Statistics
The Chi-Squared statistic is computed as follows:
$\chi^2 = \sum_{i=1}^n \frac{(O_{ij}-E_{ij})^2}{E_{ij}}=32.5992$

(4)P-value
The corresponding p-value for the test is p=Pr(χ2​>32.5992)=0

к M Chi-Square Independence test Observed Values RESULTS Total Post L 1320 l Prior L 5430 552 224 38 6750 622 Rows 4 Cols 2 d.o. f 3 No Injury Minimal Injury Major Injury Fatal Injury Formula used =(Rows-1)*(columns-1) 32 10 256 48 L 10 Total 1432 6244 6244 | 7676 P - Method Answer Formula used 0.000000391|=CHISQ.TEST(OFFSET(B5,0,0,COUNT(B5 =IF(J12<B12,"Yes","No") Level of significance - a 0.05 p-value Significant? Yes Expected Values Post L Prior L 0 0 Total 1,259.2496 6750 622 15 16 No Injury 17 Minimal Injury 18 Major Injury 19 Fatal Injury 200 21 Total 116.0375 47.7582 8.9547 5,490.7504 505.9625 208.2418 39.0453 256 48 Traditional Method Answer Formula used 0.05 =B12 32.5992 =G31 3 = 6 0.0000003913 =CHISQ.DIST.RT(118,219) 7.8147 =CHISQ.INV.RT(B12,J19) d.o.f p-value X2-crit 1432 6244 7676 0 Post L 2.9308 18.2652 5.1995 0.1220 26 No Injury 27 Minimal Injury 28 Major Injury 29 Fatal Injury 30 0 31 Sum (Observed - Expected) ^2/ Expected Prior L 0.6722 4.1890 1.1925 0.0280 Sum 3.6030 22.4542 6.3920 0.1500 26.5176 6.0816 32.5992

Let me know in the comments if anything is not clear. I will reply ASAP! Please do upvote if satisfied!