Question
Solve this using excel and excel formulas please San Gabriel and Los Angeles counties are examining businesses closing down due to the effect of COVID
Solve this using excel and excel formulas please
San Gabriel and Los Angeles counties are examining businesses closing down due to the effect of COVID 19. The counties selected seven cities and analyzed 7 days between May 30 and June 6, 2021. At 5% level of significance can the counties conclude that there is a difference in the mean number of businesses among the eight cities selected.
- State Ho, Ha
- Find the critical value
- Find the F-value and make a decision
- Interpret your results
Days
Alhambra
Arcadia
Monrovia
Pasadena
San Gabriel
Temple City
El Monte
Alta Dena
Sunday
13
21
12
16
15
14
35
33
Monday
15
13
14
17
14
15
34
31
Tuesday
14
18
15
18
18
12
37
32
Wednesday
15
19
13
15
17
11
41
42
Thursday
14
18
12
20
15
14
40
52
Friday
15
19
15
18
16
9
38
44
Saturday
17
20
18
19
12
11
45
41
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