Explore BrainMass

# Regression analysis in EXCEL

Not what you're looking for? Search our solutions OR ask your own Custom question.

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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.

© BrainMass Inc. brainmass.com October 2, 2022, 5:41 pm ad1c9bdddf
https://brainmass.com/statistics/regression-analysis/regression-analysis-in-excel-22852

#### 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.

\$2.49