Question
Use excel and excel formulas to solve this please San Gabriel police believe there is a relationship between the number of accidents in selected cities
Use excel and excel formulas to solve this please
San Gabriel police believe there is a relationship between the number of accidents in selected cities and days of the week. To test this claim, they randomly select a few cities from last week. The results are shown in the table below. At a level of significance of 5%, can we conclude using Chi Square Test thatthe number of accidents in selected cities are related to the days of the week?
a) State Ho, Ha
b) Critical value,
c) T-Stat and
d) Interpret your results.
Alhambra
Arcadia
Monrovia
Pasadena
San Gabriel
Temple City
El Monte
Alta Dena
13
21
12
16
15
14
35
33
15
13
14
17
14
15
34
31
14
18
15
18
18
12
37
32
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started