Reference no: EM131251463
Multiple Regression Analysis -
1. Write an overview of correlation and regression analysis (3-4 pages) with references
2. Construct a multiple regression model using data in "Census data by neighborhood")
The data set contains a large number of variables for 333 neighborhoods, from the 2011 census. Select 8 census variables as independents and treat "average house value" as the dependent, to construct a regression equation. (See the "Census variable definition" document)
Suggested steps:
1) Select 8 variables as independents; explain in what way you believe they influence house value in a neighborhood
2) Perform a correlation analysis to check collinearity of the 8 chosen variables. If some of them a highly correlated, provide your explanations.
3) Use Stepwise Multiple Regression method to construct a regression model (i.e., generate a regression equation)
4) Interpret the model
5) Assess/verify the model
6) Use the model to predict the average house value for the neighborhood assigned to you in the following table.
|
Neighborhood
|
Student
|
|
Oakville - 2
|
|
|
Mississauga - 7
|
|
|
Lawrence Park South
|
|
|
Rosedale-Moore Park
|
|
|
Kingsway South
|
|
|
Forest Hill South
|
|
|
Markham - 20
|
|
|
Mississauga - 8
|
|
|
Mississauga - 20
|
|
|
Vaughan - 6
|
|
|
St.Andrew-Windfields
|
|
|
Lawrence Park North
|
|
|
Mississauga - 5
|
|
|
Vaughan - 3
|
|
|
Bedford Park-Nortown
|
|
|
Casa Loma
|
|
|
Princess-Rosethorn
|
|
|
Leaside-Bennington
|
|
|
Oakville - 11
|
|
|
Richmond Hill - 6
|
|
Attachment:- Assignment.rar
|
Financial planner recommends
: A financial planner recommends that you have accumulated $2.0 million by the time that you retire in 25 years. If you can earn an annual rate of return of 5%, how much must you invest for each of the next 25 years in order to achieve this goal?
|
|
Fixed-rate mortgage to buy a new home
: In the question, "You need a 30-year, fixed-rate mortgage to buy a new home for $240,000. Your mortgage bank will lend you the money at a 6.35 percent APR for this 360-month loan. However, you can afford monthly payments of only $1,150, so you off..
|
|
Exponential smoothing with seasonal adjustment
: Given the data below from the second week, there appears to be a cycle during the week peaking on Wednesday. Recalculate the forecast for Monday of the following week using a seasonal adjustment with γ = 0.3.
|
|
What is the maximal production of the process
: Write a VBA macro to calculate the material balance over the reactor - Use tear-analysis to find the feasible material balance for the process. What is the overall conversion?
|
|
Write an overview of correlation and regression analysis
: Write an overview of correlation and regression analysis (3-4 pages) with references. Construct a multiple regression model using data in "Census data by neighborhood")
|
|
Miller hardware paid an annual dividend
: Miller Hardware paid an annual dividend of $1.10 per share recently. Today, the company announced that future dividends will be increasing by 3.5 percent annually. If you require a 12 percent rate of return, how much are you willing to pay to purc..
|
|
Update forecast for next wednesday using simple exponential
: The smoothed value calculated the week before was 67. - Update the forecast for next Wednesday using simple exponential smoothing and an a of 0.1.
|
|
How a naturally sampled pam signal can be demodulated
: Show that the product detector can also be used to recover w(t) from an instantaneously sampled PAM signal, provided that the appropriate filter H(f) is used. Find the required H(f) characteristic.
|
|
Calculate the value of the lot using traditional approach
: Calculate the value of the lot using the traditional approach. Calculate the value of the lot using the real option approach. Should you buy the lot?
|