Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

  1. State Ho, Ha
  2. Find the critical value
  3. Find the F-value and make a decision
  4. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Interconnection Networks

Authors: J C Bermond

1st Edition

1483295273, 9781483295275

More Books

Students also viewed these Mathematics questions