Question: Answers are wrong please do this as fast as possible Employees constructing components in the company's warehouse find their work repetitive and have asked management

Answers are wrong please do this as fast as

Answers are wrong please do this as fast asAnswers are wrong please do this as fast as possible

Employees constructing components in the company's warehouse find their work repetitive and have asked management to play music in the warehouse to relieve their boredom. The manager is interested to know whether the change in working conditions will improve employee efficiency. Download and open the Warehouse.xlsx file in Excel. This file contains the number of components constructed by each of a random sample of 35 employees in the week before music was introduced and again in the week after music was introduced into the workplace. Use Excel to carry out a suitable test to address the following research question: Is there a difference between average efficiency levels for warehouse employees before and after music is introduced in the workplace? (A) Histogram of before (B) Histogram of after (C) Histogram of differences (before-after) 00 00 35 40 45 35 40 45 50 55 -30 -10 10 10 15 20 25 30 20 25 30 Number of completed components before Number of completed components after Difference in number completed Use your Excel output, and any appropriate plots provided to answer the following questions. For each question, either choose the most correct option, or type in the answer to the number of decimal places specified. 1. (1 mark) The most appropriate test for these data is A paired t-test 2. (1 mark) Referring to the histograms provided to check the assumption(s) for this test we would use Differences between numbers of components constructed before and after music was introduced (Graph C) = For the remaining questions you may assume that any relevant assumptions have been met. 3. (2 marks) The absolute value of the test statistic is equal to (type your answer with 3 dp) -6.383 4. (1 mark) The degrees of freedom is equal to (type your answer as an integer) 29 5. (1 mark) The p-value is larger than 0.05 false 6. (2 marks) The test indicates that employees: constructed more components, on average, after music was introduced. before after 30 32 54 31 26 35 17 28 21 23 38 32 21 14 22 35 33 37 38 26 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 45 36 37 34 44 47 33 35 41 36 41 43 31 36 40 44 22 54 40 23 45 37 44 33 40 31 25 17 32 29 27 27 27 23 35 38 37 28 Wowww to do 30 33 31 35

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!