Question Details

[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

 

<----enter p-value inside this cell erate the output inside this green box -------> urs in June is different than the number in July.

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 18, 2020

PRICE: $15

Solution~0001003587.zip (25.37 KB)

Buy this answer for only: $15

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)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 18, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now