You will need the “Analysis Toolpak” for Excel. This provides the multiple regre

Question

You will need the “Analysis Toolpak” for Excel. This provides the multiple regression capability.

See page 488-489 in the text to see how a multiple regression is performed in Excel.

Here is the data for the Excel multiple regression homework:

Assignment              Miles        Deliveries                    Time

1                             100         4                              9.3

2                              50           3                              4.8

3                              100         4                              8.9

4                              100         2                              6.5

5                              50           2                              4.2

6                              80           2                              6.2

7                              75           3                              7.4

8                              65           4                              6

9                              90           3                              7.6

10                           90           2                              6.1

Time is the dependent variable.

Miles and Deliveries are the independent variables.

The analysis should include the answers to the following questions:

1. What is the regression line? Interpret the line and the coefficients.

2. Are the independent variables significant? Explain

3. Is the regression overall significant? Explain

4. How much variation is explained? Explain this value.

5. What is the standard deviation of the regression equation? Explain.

PLEASE ANSWER ALL 5 QUESTIONS AND PLEASE HELP ME WITH THE EXCEL FILE AS IT COUNTS FOR HALF THE PROJECT! IT WILL BE VERY MUCH APPRECIATED!

Explanation / Answer

Here is the attached excel file

https://drive.google.com/file/d/0B5GF0YjRTNDRS1YtNndhRmRJLUk/view?usp=sharing

1 The regression line is Time= -0.8687 + 0.061135 Miles + 0.923425 Deliveries 2 Since the p-values for both the bo-efficient is less than 0.05, thus 5% level of condfidence we can conclude that the co-effecients are significant. 3 From the AVOVA table we have the p-value corresponding to regression is less than 0.05, thus at % level of confidence we can conclude that the regression is significant. 4 Since the R Square is 0.903789, thus we can conclude that about 90% of the variability is explained. 5 The standard error of the regression line is 0.573142

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.