Purchase Solution

Linear Regression

Not what you're looking for?

Ask Custom Question

The director of graduate studies at a large college of business would like to be able to predict the grade point index (GPI) of students in an MBA program based on Graduate Management Aptitude Test (GMAT) score. A sample of 20 students who had completed 2 years in the program is selected; the results are as follows:

[see the attached file for the table]

a. Plot a scatter diagram [Using Excel] and, assuming a linear relationship, use the least-squares method to find the regression coefficients b0 & b1.

b. Interpret the meaning of the Y intercept b0 and the slope b1 in this problem.

c. Use the regression equation developed in (a) to predict the GPI for a student with a GMAT score of 600.

d. Determine the standard error of the estimate.

e. Determine the coefficient of determination r² and interpret its meaning in this problem.

f. Determine the coefficient of correlation r.

g. Perform a residual analysis on your results and determine the adequacy of the fit of the model.

h. At the 0.05 level of significance, is there evidence of a linear relationship between GMAT score and GPI?

i. Set up a 95% confidence interval estimate for the average GPI of students with a GMAT score of 600.

j. Set up a 95% prediction interval for a particular student with a GMAT score of 600.

k. Set up a 95% confidence interval estimate of the population slope.

l. Suppose the GPIs of the 19th and 20th students were incorrectly entered. The GPI for student 19 should be 3.76, and the GPI for student 20 should be 3.88. Repeat (a) - (k) and compare the results with your original results.

Attachments
Purchase this Solution
Solution Summary

The solution includes answers to all parts of the question, which together form a complete linear regression analysis. Step-by-step explanations are included.

Solution Preview

Q. 13

The director of graduate studies at a large college of business would like to be able to predict the grade point index (GPI) of students in an MBA program based on Graduate Management Aptitude Test (GMAT) score. A sample of 20 students who had completed 2 years in the program is selected; the results are as follows:

Observation GMAT Score GPI Observation GMAT Score GPI

1 688 3.72 11 567 3.07
2 647 3.44 12 542 2.86
3 652 3.21 13 551 2.91
4 608 3.29 14 573 2.79
5 680 3.91 15 536 3.00
6 617 3.28 16 639 3.55
7 557 3.02 17 619 3.47
8 599 3.13 18 694 3.60
9 616 3.45 19 718 3.88
10 594 3.33 20 759 3.76
(Hint: First determine which are the independent and dependent variables.)

a. Plot a scatter diagram [Using Excel] and, assuming a linear relationship, use the least-squares method to find the regression coefficients b0 & b1.

The question says that we would like to be able to predict the GPI based on the GMAT score. This means that the GPI is the dependent (y) variable, and the GMAT score is the independent variable (x).

I put these variables into an Excel spreadsheet, and made a scatterplot:

Then, I went to chart  add trendline  linear, making sure that I checked the box specifying that the equation show up on the screen. The regression equation for these data is:

y = 0.0049x + 0.3003

The coefficients are:

b0 = 0.3003 (y-intercept)
b1 = 0.0049 (slope)

b. Interpret the meaning of the Y intercept b0 and the slope b1 in this problem.

The ...

Purchase this Solution
Free BrainMass Quizzes
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.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Relationship of Linear Regression & Correlation

    622757 Relationship of Linear Regression & Correlation When is it appropriate to use linear regression? What is the relationship between linear regression and correlation?

  • Discuss the definition of linear regression

    595859 Discuss the definition of linear regression What is linear regression? Can you give an example? Answer: linear regression is a tool to check the relationship between two variables.

  • simple linear regression models

    169332 simple linear regression models Develop simple linear regression models for predicting Games Won as a function of each of the independent variables in the 2000 NFL Data.xls worksheet individually.

  • Simple Linear Regression and Multiple Regression.

    Simple Linear Regression and Multiple Regression.

  • Advantages of Linear Regression in Complex Situations

    330240 Advantages of Linear Regression in Complex Situations How does a linear regression allow us to better estimate trends, costs, and other factors in complex situations? Linear regression estimates the line of best fit for any given data.

  • Simple Regressions and Multiple Regressions

    How is regression used to generate prediction equations in SPSS? How are prediction equations used to make predictions? What is multiple linear regression? How are predictions made using multiple linear regression equations?

  • Regression analysis and simple linear regression

    The following results were obtained as part of a simple linear regression analysis. MSE = 25.485.

  • ABC Furniture Company Linear Regression

    626456 ABC Furniture Company Linear Regression See Attached Background: Linear Regression Forecasting and Decision Trees Why is Forecasting important? How can we use Linear Regression as a forecasting method?

  • Theory, analysis and interpretation of regression

    Since in regression we need to solve for the coefficients of the regression line, matrix method can be used to this end. In this way, linear algebra can help perform linear regression.

  • Linear long-term trend.

    125118 Linear long-term trend. If a long-term trend is linear, how can regression analysis be adjusted to make business decisions? Regression analysis fits the least squares line to available data.

View More Related Solutions