Purchase Solution

Linear & Multiple Regression Analysis

Not what you're looking for?

Ask Custom Question

The dean of the college of business at Tech has initiated a fund-raising campaign. One of the selling points he plans to use with potential donors is that increasing the colleges private endowment will improve its ranking among all business schools, as published each year by the magazine, The Global News and Business Report. He would like to demonstrate that there is a relationship between funding and rankings. He has collected the following data, showing the private endowments ($1,000,000) and annual budget (1,000,000s) from state and private sources for eight of Techs peer institutions plus Tech, and the ranking of each school.

Private Endowment (1,000,000s) Annual Budget (1,000,000s) Ranking
$2.5 $8.1 87
52.0 26.0 20
12.7 7.5 122
63.0 33.0 32
46.0 12.0 54
27.1 16.1 76
23.3 17.0 103
46.4 14.9 40
48.9 21.8 98

A) using excel, develop a linear regression model for the amount of the private endowment and the ranking and forecast a ranking for a private endowment of $70 million. Does there appear to e a strong relationship between the endowment and the ranking?

B)using excel, develop a multiple regression equation for all these data, including private endowment and annual budget, and forecast a ranking for a private endowment of $70 million and an annual budget of $40 million. How does this forecast compare with the other forecast in part (a)?

Purchase this Solution

Solution Summary

The solution provides step by step method for the calculation of regression analysis. Formula for the calculation and Interpretations of the results are also included.

Purchase this Solution


Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.