Purchase Solution

Enrollment Data for Business Week's Top Graduates

Not what you're looking for?

Ask Custom Question

Consider the enrollment data for Business Week's top 50 U.S. graduate business programs in the file P2_3.XLS which is set out below.

PROBLEM: Using excel and excel statistical functions, solve the following:

(a) Use the data in the file P2_3.XLS - set out below - to estimate a multiple regression model to assess whether there is a systematic relationship between the total number of full-time students and the following explanatory variables:

(i) The proportion of female students;

(ii) The proportion of minority students; and

(iii) The proportion of international students

enrolled at these distinguished business schools.

(b) Interpret the ANOVA table for this model. In particular, does this set of explanatory variables provide at least some power in explaining the variation in total full-time enrollment at the top graduate business programs?

(c) Report a p - value for this hypothesis test.

Purchase this Solution

Solution Summary

The enrollment data for business week's top graduates of business programs is given.

Purchase this Solution


Free BrainMass Quizzes
Measures of Central Tendency

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

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.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

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.