Purchase Solution

Multiple regression analysis of loan data

Not what you're looking for?

Ask Custom Question

Please solve the attached file using Excel.

(See attached file for full problem description)
---
A mortgage department of a large bank is studying its recent loans. Of particular interest is how such factors as the value of the home (in thousands of dollars), education level of the head of the household, age of the head of the household, current monthly mortgage payment (in dollars), and gender of the head of the household (male = 1, female = 0) relate to the family income. Are these variables effective predictors of the income of the household? A random sample of 25 recent loans is obtained.
Income (thousands) Value (thousands) Years of Edu Age Mortgage Pmt Gender
$40.3 $190 14 53 $230 1
39.6 121 15 49 370 1
40.8 161 14 44 397 1
40.3 161 14 39 181 1
40.0 179 14 53 378 0
38.1 99 14 46 304 0
4.04 114 15 42 285 1
40.7 202 14 49 551 0
40.8 184 13 37 370 0
37.1 90 14 43 135 0
39.9 181 14 48 332 1
40.4 143 15 54 217 1
38.0 132 14 44 490 0
39.0 127 14 37 220 0
39.5 153 14 50 270 1
40.6 145 14 50 279 1
Income (thousands) Value (thousands) Years of Edu Age Mortgage Pmt Gender
40.3 174 15 52 329 1
40.1 177 15 47 274 0
41.7 188 15 49 433 1
40.1 153 15 53 333 1
40.6 150 16 58 148 0
40.4 173 13 42 390 1
40.9 163 14 46 142 1
40.1 150 15 50 343 0
38.5 139 14 45 373 0

A. Determine the regression equation.

The regression equation is: y = 1.567x + 93.669
B. What is the value of R2? Comment on the value?
R2 = 0.1552. The value of the coefficient of determination is very low, indicating that it is not a good regression.
C. Conduct a global hypothesis test to determine whether any of the independent variables are different from zero.

D. Conduct individual hypothesis tests to determine whether any of the independent variables can be dropped.

E. If variables are dropped, recomputed the regression equation and R (2).
---

Attachments
Purchase this Solution
Solution Summary

The solution gives the step by step procedure for the multiple regression analysis. Slope, intercept, correlation, residual, r square and coefficient of determination are given with interpretations. The students t test for the significance of regression coefficients are also done.

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.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Bank Loan Data Set Analysis - SPSS

    At a minimum the statistics should include calculations for correlations, descriptive statistics, and multiple regression. Bank Loan Data Set Analysis - SPSS Please provide recommendations to a company based on the data.

  • Multiple regression analysis of Starbuks and DJIA data

    The solution gives details of multiple regression analysis of Starbuks and DJIA data. The solution includes regression equation, slope, intercept, correlation, residual, r square, coefficient of determination and regression coefficients.

  • Multiple regression analysis with the attached data

    133196 Multiple regression analysis with the attached data 1. Can I perform a multiple regression analysis with the attached data that I've collected without changing that data or adding to it?

  • Data Analysis: Multiple Regression

    Data Analysis: Multiple Regression I have worked on various statistical assignment on different measuring components of research analysis such as: chi square, frequenty, scatter plot, variances, etc.

  • Multiple regression analysis of crime rate in Megastat

    126007 Multiple Regression Analysis My research is based on this topic below. The data is attached in the spreadsheet. This is a multiple regression analysis.

  • Importance of Using Regression Analysis

    These are things one has to consider when analyzing data. 5. What are the most important concepts you have learned from perform correlation, linear regression, and multiple regression analysis?

  • 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.

  • Multiple regression analysis

    437411 Multiple regression analysis. Welcome to the fifth SLP of the course. For this module I am again going to refer you to the data you have been collecting. Answer the following questions in reference to your data.

  • Design of Experiments

    In the case of Multiple Regression, it is dependent on a database. In case of Multiple Regression, often the manner in which the data has been generated is not known and the results depend on the source of the data.

View More Related Solutions