Explore BrainMass

Explore BrainMass

    Creating multiple linear regressions

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

    Using the data in the Excel file "Home Market Value," develop a multiple linear regression model for estimating the market value as a function of both the age and size of the house. Find a 95% confidence interval for the mean market value for houses that are 30 years old and have 1,800 square feet and a 95% prediction interval for a house that is 30 years old with 1,800 square feet.

    © BrainMass Inc. brainmass.com June 4, 2020, 4:08 am ad1c9bdddf
    https://brainmass.com/statistics/descriptive-statistics/creating-multiple-linear-regressions-549076

    Attachments

    Solution Preview

    Please see the attachments.

    Creating multiple linear regressions
    Using the data in the Excel file Home Market Value, develop a multiple linear regression model for estimating the market value as a function of both the age and size of the house. Find a 95% confidence interval for the mean market value for houses that are 30 years old and have 1,800 square feet and a 95% prediction interval for a house that is 30 years old with 1,800 square feet.
    Answer
    The estimated regression equation is given by,
    Home Market Value = 47331.3815 - 825.1612 * House Age + 40.9111 * Square Feet
    Details
    Coefficients Standard ...

    Solution Summary

    The expert creates multiple linear regressions.

    $2.19

    ADVERTISEMENT