Purchase Solution

Regression Analysis Problem unemployment rate and residential mortgage rate

Not what you're looking for?

Ask Custom Question

Use linear regression to determine if there is a statistical correlation between the unemployment rate and the residential mortgage bank-charge off rate. Answer the following questions.

Table 1. Quarterly Unemployment
Rate1996 - 2006
Year Q1 Q2 Q3 Q4
1996 5.53 5.5 5.27 5.33
1997 5.23 5 4.86 4.67
1998 4.63 4.46 4.53 4.43
1999 4.3 4.26 4.23 4.06
2000 4.03 3.93 4 3.9
2001 4.23 4.4 4.83 5.5
2002 5.7 5.83 5.73 5.87
2003 5.87 6.13 6.13 5.83
2004 5.7 5.6 5.43 5.4
2005 5.27 5.07 4.9 4.97
2006 4.73 4.63 4.7 4.47
Source: Bureau Labor Statistics (2006)

Table 2. Residential Mortgage
Charge-Off Rates 1996-2006
Year Q1 Q2 Q3 Q4
1996 .12 .1 .09 .09
1997 .1 .1 .09 .09
1998 .09 .08 .07 .07
1999 .1 .11 .14 .14
2000 .13 .12 .11 .14
2001 .15 .17 .44 .19
2002 .17 .17 .14 .14
2003 .16 .16 .12 .33
2004 .14 .11 .09 .08
2005 .09 .08 .08 .06
2006 .1 .09 .11 unk
Source: Federal Reserve (2006)
A. Calculate the Correlation Coefficient
B. Calculate the Coefficient of Determination
D. Coefficient Test of Significance
E. Calculate the Least Squares Regression Line
F Calculate the Confidence and Prediction Intervals for the Dependent Variable
G. Create an ANOVA Table

Attachments
Purchase this Solution
Solution Summary

The solution uses regression analysis to draw a relationship between unemployment rate and mortgage rates.

Solution Preview

Please see attached file.

Regression output confidence ...

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

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.

View More Free Quizzes
Related BrainMass Solutions

  • Unemployment Rate Regression Analysis

    150315 Development of regression analysis to determine effects of sports facilities on the unemployment rate I am writing a paper on the unemployment rate with regression analysis. The unemployment rate is my dependent variable.

  • Mortgage comparison

    Security First Mortgage Funding's mortgage loan is actually an adjustable rate mortgage.

  • Time series analysis for Unemployment Rate

    236090 Time series model for unemployment rate Time Series Analysis THE FOLLOWING TIME SERIES DATA REPRESENTS THE MEAN YEARLY US UNEMPLOYMENT RATE BETWEEN JANUARY 1981 AND OCTOBER 2008 (OBTAINED FROM THE U.S.

  • Mortgage Rates Question

    The mortgage receipts are collected and passed through to the certificate owners.

  • Time series analysis: Linear trend

    D) Estimate unemployment rate for the next five years. Please see the attachment The solution provides step by step method for the analysis of time series data . Formula for the calculation and Interpretations of the results are also included.

  • Statistics: Multi Regression analysis

    Question 5: please use all attachments excel Motor Vehicle theft case and word 1987 Motor Vehicle Theft for comparison of 1987 data and 2008 data Compare the 2008 multi regression analysis ( done in this problem) to the 1987 Multi regression analysis

  • economic indicator forecast on the homebuilding Industry

    Interest rate (for example: mortgage rate, prime interest rate, fed funds rate, discount rate, three month treasury bill, 10 year treasury bond) I need to include an in-depth analysis on how my forecast (Interest) will impact the Homebuilding industry

  • Multiple Regression Analysis

    Select Mortgage Rate as the dependent variable and Treasury Bond yield and mortgage type as the independent variables. Conduct multiple regression using Excel. Paste the output report below.

  • The Purpose of Using Regression Analysis

    They have collected unemployment rates from different times (some from good economical states and some data from bad economical states, numbers are also from different month etc.), using regression analysis, they can forecast the unemployment rate given

View More Related Solutions