* 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 1% level of significance, can you conclude that the new software has made a difference in 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 b) p-value: c) Conclusion:

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

*** 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 1% level of significance, can you conclude that the new software has made a difference in 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

b) p-value:

c) Conclusion:

Features Features Normal distribution is characterized by two parameters, mean (µ) and standard deviation (σ). When graphed, the mean represents the center of the bell curve and the graph is perfectly symmetric about the center. The mean, median, and mode are all equal for a normal distribution. The standard deviation measures the data's spread from the center. The higher the standard deviation, the more the data is spread out and the flatter the bell curve looks. Variance is another commonly used measure of the spread of the distribution and is equal to the square of the standard deviation.

Expert Solution