Explore BrainMass

Regression analysis in EXCEL

Following is a portion of the Excel output for a regression analysis relating maintenance expense (dollars per month) to usage (hours per week) for a particular brand of computer terminal.

(see table in attachment)

a. Write the estimated regression equation.
b. Use a t test to determine whether monthly maintenance expense is related to usage at the .05 level of significance
c. Did the estimated regression equation provide a good fit? Explain.


Solution Summary

The output from a regression analysis in EXCEL is provided. The solution interprets the output, showing how to find the estimated regression equation and test the significance of the model.