## [answered] A sample of 22 workers shows the number of overtime hours i

Need this homework question answered in Excel. I need to include the formulas/functions on this and need to make sure its 100% correct, grade relies on it. Also, am curious if the answer's rely on the numbers staying the same in the set. They are randomized and each time i click on something they change so not sure if that will matter with my answer or not. Thank you!!!

A sample of 22 workers shows the number of overtime hours in June and in July.

Worker June [hr]

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22 2 points 1 point July [hr]

32

13

11

42

39

10

41

23

13

41

20

8

35

24

32

20

30

39

10

22

32

30 39

26

34

8

29

26

11

11

31

32

33

24

14

39

18

39

25

13

28

17

8

39 Use the appropriate Excel Add-in to conduct an hypothesis test and generate the output inside this green

(ignore the fact that these numbers keep changing, just generate the output) Get the p-value (from the output) to test whether the mean overtime hours in June is different than the

&lt;----enter p-value inside this cell erate the output inside this green box -------&gt; urs in June is different than the number in July.

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Sep 18, 2020

Solution~0001003587.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

STATUS

QUALITY

Approved

Sep 18, 2020

EXPERT

Tutor