Explore BrainMass

Explore BrainMass

    Regression analysis in EXCEL

    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 June 3, 2020, 5:21 pm ad1c9bdddf
    https://brainmass.com/statistics/regression-analysis/regression-analysis-in-excel-22852

    Attachments

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

    ADVERTISEMENT