• Round final answers to 2 decimal places,unless otherwise specified.
• Exponents can be displayed with the use of the "^" symbol (shift 6)...(Ex: "4 to the exponent 2" = 4^2)
• Expressalternate hypotheses withthe following symbols "/=" for two-tailed, ">=" for left-tailed, and "<=" for right-tailed
• Belowis an Excel data set linkfor questions 5, 6, 7 and 8...no work is submitted in Excel...ALL answers will be submitted the FOL quiz.

*** TO BE DONE WITH THE USE OF EXCEL***

***FOR MATCHED PAIR DO: BEFORE - AFTER***

***FOR INDEPENDENT SAMPLES DO:BEFORE AS SAMPLE 1 AND AFTER AS SAMPLE 2***

A company implemented a new sales management software program, hoping it will reduce the amount of time sales people spend on their computers.A sample of sales personnel computer usage before and after the new software implementation is provided below (also available for download here Computer.xlsx).At a 5% level of significance, can you conclude that the new software has reduced the amount of time sales people spend on their computers?YOU CAN ASSUME THE POPULATION TO BE NORMALLY DISTRIBUTED.

Time Spent on Computer

Employee ID Before New Software (hrs/wk) After New Software (hrs/wk)

49193 9 8

62328 9.5 9.5

97193 6 5.5

77414 3.5 3

61760 5 5

41200 4.5 5

12406 11 10.5

70657 6.5 6

86801 2.5 2

32474 10 9

49578 6.5 6

44233 11 10.5

24132 2 1.5

47118 6.5 7.5

82881 4 3.5

69800 4 4

69905 9 9

20158 4.5 4.5

29786 9 9

84930 3 3

39018 9 8.5

42041 5.5 5.5

77707 6.5 5.5

70559 6.5 6

36305 2.5 2.5

31625 6 6.5

57245 7 7

56235 9.5 9.5

34422 10 10

48536 7.5 7.5

62782 7 7

78272 5 5

40181 8 7

a) Properly state the mathematical hypotheses:

b) p-value:

c) Conclusion: (YOU MUST EXPLAIN YOUR ANSWER MATHEMATICALLY )

Answer

a)

b)

PLEASE SHOW YOUR WORK BY COMPLETING THIS TABLE

FUNCTION:

FIELD 1:

FIELD 2:

FIELD 3:

FIELD 4:

ANY ADDITIONAL CALCULATIONS CAN BE SHOWN HERE

FINAL ANSWER: ANSWER TO 4 DECIMALS

c)