Explore BrainMass

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


    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.