Question
I can't get answers 1 to 6 right Please answer all the questions. Please show how to Run the following regression model using Excel: Conversion
I can't get answers 1 to 6 right
Please answer all the questions.
Please show how to Run the following regression model using Excel: Conversion Costs == a+ b (MH)
Quest Company wants to predict conversion costs using regression. The following data was collected for 12 periods: conversion costs, machine hours, direct labor hours, and whether the period was a summer month (1) or a non-summer month (0).
Period | Conversion Costs | MH | DLH | Season |
1 | 370,736 | 1,560 | 2,940 | 1 |
2 | 399,721 | 1,305 | 3,360 | 1 |
3 | 419,209 | 2,363 | 3,720 | 1 |
4 | 421,529 | 2,438 | 4,080 | 1 |
5 | 431,736 | 1,240 | 3,780 | 1 |
6 | 388,875 | 2,250 | 3,780 | 0 |
7 | 255,625 | 960 | 2,760 | 0 |
8 | 358,000 | 1,680 | 3,660 | 0 |
9 | 338,125 | 1,134 | 3,240 | 0 |
10 | 378,750 | 2,250 | 4,020 | 0 |
11 | 326,750 | 1,080 | 3,048 | 0 |
12 | 331,180 | 1,680 | 3,120 | 0 |
1.Produce a correlation matrix that shows the correlations between all dependent and independent variables.
2.Run the following regression model using Excel: Conversion Costs == a+ b (MH)
3.What is the regression model based on the regression?
4.Discuss the significance of the intercept and slope variables. Are they significant, and at what level?
5.What is your R2? What does it mean?
6.What are the 95 confidence intervals around the slope variables for your X variable in the model?