Purchase Solution

Simple and Multiple Regression

Not what you're looking for?

Ask Custom Question

[See attached files.]

This assignment introduces you to applications of simple and multiple regression. You will apply these models for predicting and forecasting and, determining the strength of the relationship between a variable y and a number of variables X1, ..., Xp.

Skill- Building Exercises:

? 1. For the Home Market Value data, use formulas (6.2) and (6.3) on a spreadsheet to calculate the least-squares regression coefficients.

? 2. For the Colleges and Universities data, plot scatter charts for each variable individually against the graduation rate and add linear trendlines, finding both the equation and R2 values.

? 3. Use the regression tools to find simple linear regression models for each independent variable for the Colleges and Universities data.

? 4. Use the INTERCEPT and SLOPE functions in Excel to develop regression models for each of the independent variables in the Colleges and Universities example.

Number and identify each part of the answer concerning the college and university: ie, 2, 3 or 4

Problems and Applications:

12. The Excel file Concert Sales provides data on sales dollars and the number of radio and TV and newspaper ads promoting the concerts for a group of cities. Develop simple linear regression models for predicting sales as a function of the number of each type of ad. Compare these results to a multiple linear regression model using both independent variables. Examine the residuals of the best model for regression assumptions and possible outliers.

Attachments
Purchase this Solution
Solution Preview

See attached files.

The output is in the Excel file and below:

a) House Age

b1 = 1570.434183

b2 = 45217.76115

The regression equation is: y = 1570.4x + 45218

b) Square Feet

b1 = 35.03637258

b2 = 32673.2199

The regression equation is: y = 35.036x + 32673

? 2. For the Colleges and Universities data, plot scatter charts for each variable individually against the graduation rate and add linear trendlines, finding both the equation and R2 values.

This has been done in the Excel file. The equation of the trendline and the R^2 value for each scatterplot is displayed in the chart.

? 3. Use the regression tools to find simple linear regression models for each independent variable for the Colleges and Universities data.

The output is in the Excel file and below:

(a) Median SAT

Regression Statistics
Multiple R 0.564146827
R Square 0.318261642
Adjusted R Square 0.303756571
Standard Error 6.215134216
Observations 49

ANOVA
df SS MS F Significance F
Regression 1 847.5502382 847.5502382 21.94140465 2.42598E-05
Residual 47 1815.510986 38.62789332
Total 48 2663.061224

Coefficients Standard Error t Stat P-value
Intercept -1.438019781 18.10033983 -0.079447115 0.937014306
Median SAT 0.067043608 0.014312818 4.68416531 2.42598E-05

The regression equation is: y = 0.067x - 1.438

(b) Acceptance Rate

Regression Statistics
Multiple R 0.55037751
R Square 0.302915404
Adjusted R Square 0.288083817
Standard Error 6.284697658
Observations 49

ANOVA
...

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.

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.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • Simple Linear Regression and Multiple Regression.

    Simple Linear Regression and Multiple Regression.

  • Develop a multiple linear regression model & compare

    414052 Develop a multiple linear regression model and explain how does this compare with simple regression. Develop a multiple linear regression model.

  • Multiple regression analysis

    363413 Simple regression or multiple regression Market researcher Ally Nathan is studying the relationships among price, type (classical or steel string), and consumer demand for acoustic guitars.

  • Simple Regressions and Multiple Regressions

    581659 Simple Regressions and Multiple Regressions What is simple linear regression? How is regression used to create equations and to make predictions? Should variables be strongly correlated in order to use one to predict the other?

  • Least-Squares Property and Regression Analysis

    This week we looked at regression analysis. What is the difference between a simple regression analysis and multiple regression? Please give examples. 1.

  • simple linear regression models

    Please look at all tabs in excel sheet for different linear regression models and the overall multiple regression model. Thanks This posting contains solution to following regression analysis problem.

  • Multiple Regression Analysis and Least Squares Regression

    When you do simple linear regression, you might find a t-value associated with that slope, and test to see if the slope is significantly different than 0. With multiple regression, you have a "slope" for each independent variable.

  • Making a Simple Regression Into a Multiple Regression

    212295 Simple analysis - You may add any second variable You may add any second variable.Please find attached a simple regression analysis, and make it a multiple regression analysis example(i.e., with two independent variables).

  • Benefit of Developing and Examining Models

    Please provide a simple linear regression model and define each variable used. c.) Describe multiple regression analysis and discuss potential uses for this model. a.)

View More Related Solutions