In an attempt to determine whether or not special training increases the speed with which assembly

profiletutor4helpyou
 (Not rated)
 (Not rated)
Chat

Problem 3. (20 points)

 

In an attempt to determine whether or not special training increases the speed with which assembly line workers can do an assembly job at AMTEL Inc., 25 workers are timed performing the task. Then, they are given a special training course designed to increases their assembly efficiency. At the end of the course, they are timed doing the same task. The differences between the first and the second time are recorded for each of the 25 assembly line workers. The mean improvement for the 25 workers was found to be 2.6 minutes and the sample standard deviation was 4 minutes.

 

Let variable  represents the improvement in time for each assembly line worker. Let  represents the average improvement in time for the population. Has the training improved the time required on the job? Please test the hypothesis use  as the level of significance. (Hint:  meaning that the training improves the time.  Please follow the 7 step procedure!)

 

Problem 4. (20 points)

 

Consider the following time series data representing quarterly sales of dishwashers at Big Boys Appliances over the past two years:

 

Time

Sales

2010 Quarter 1

25

2010 Quarter 2

85

2010 Quarter 3

64

2010 Quarter 4

30

2011 Quarter 1

70

2011 Quarter 2

125

2011 Quarter 3

105

2011 Quarter 4

90

 

The scatter plot of the data above shows seasonality with trend. Hence, a multiple regression model is run to forecast the demand. We denote sales (Y) as the depend variable, and denote time (t, with  represent the first quarter of 2010) and dummy variables (, , and ) as independent variables. Here, we choose quarter 1 as the baseline and adopt three seasonality dummy variables, such that  represents quarter 2,  represents quarter 3, and  represents quarter 4. Answer the following questions. Use

 

a)      (5 points) Use the above variable definition to code the data above.

 

Time

Sales(Y)

Time (t)

   

2010 Quarter 1

25

1

 

 

 

2010 Quarter 2

85

2

 

 

 

2010 Quarter 3

64

3

 

 

 

2010 Quarter 4

30

4

 

 

 

2011 Quarter 1

70

5

 

 

 

2011 Quarter 2

125

6

 

 

 

2011 Quarter 3

105

7

 

 

 

2011 Quarter 4

90

8

 

 

 

 

b)     (5 points) Copy the data into Excel and run the corresponding multiple regression. Write the estimated multiple regression equation use the variables defined above. (Hint: No need to conduct backwards elimination at this point.)

c)      (5 points) Explain the meaning of the slopes for seasonally dummy variable , , and . (Note: Use actual variable name and numbers to answer the questions. Put numbers in the right context.)

d)     (5 points) Test the overall fitness of the model. (State the hypotheses, and use Significant F to complete your test.)

e)      (Bonus5 points) Which variables in the current regression model are significant? And which are not significant? Justify your answer.

  • 12 years ago
In an attempt to determine whether or not special training increases the speed with which assembly
NOT RATED

Purchase the answer to view it

blurred-text
  • attachment
    answer.docx
  • attachment
    data.xlsx