Explore BrainMass

Explore BrainMass

    Multiple Regression Model and Prediction of Graduation

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

    Use the data in the spreadsheet "HW #3" to answer the following.

    1. Develop a multiple regression model for predicting Graduation % as a function of the other variables.
    2. Use the model to predict the Graduation % with a Median SAT of 1500, Acceptance Rate of 50%, Expenditures/Student of $50000 and Top 10% HS of 80.

    © BrainMass Inc. brainmass.com June 4, 2020, 3:23 am ad1c9bdddf


    Solution Preview

    See the attached file. Thanks

    Run the regression using the Data > Data Analysis > Regression in Excel
    The Y variable is Graduation % and X variable are rest of ...

    Solution Summary

    Provides steps necessary to develop a multiple regression model that can be used to make predictions.