The data set shows Sales Price, Area, Number of Rooms, Number of Bedroom, Age and River View
of 63 single family homes.Sales Price is in thousands and River View indicates whether a home has the
view of river or not. A home with the river view is code as 1 and with no view is given by 0.
Using a sample of 30 homes conduct three multiple regression analyses: (1) multiple
linear regression with the quantitative variables, (2) multiple linear regression both quantitative
qualitative variables, and (3) multiple regression with interaction.
Answer the following:
1.Specify the regression models.
2.Explain your regression models. There are three of them: multiple linear regression with all quantitative variables,multiple linear regression with all the quantitative variables and dummy variable, and multiple linear regression with the quantitative variables and interaction effect.
3.Explain the basic assumptions in regression model.
4.Identify the independent and dependent variables.
5.Explain the nature of the variables.
6.Find the descriptive statistic of all the variables.
7.Generate appropriate charts each variable (pie, bar charts, histogram, box plots, stem-and-leaf, and QQ plot).
8.Interpret the major findings (in tasks# 6 and #7).
9.Conduct the correlation analysis with the software.
10.Explain the findings of correlation analysis.
11.Generate scatter plots with the quantitative variables.
12.Explain the outputs of scatter plots.
13.Conduct the following multiple regression analyses with the software (SPSS):
a.Linear regression analysis with the quantitative variables
i.Explain the findings of your regression analysis
ii.Conduct one forecast for a set of independent variables and find the residual
iii.Conduct hypothesis testing for the slope of an independent variable
iv.Conduct interval estimate for the slope of an independent variable
b.Linear regression analysis with all the six variables which includes the dummy variable
i.Explain the findings of your regression analysis with the dummy variable
c.Linear regression analysis all the quantitative variables and an interaction of two independent variables.
i.Explain the findings of your regression analysis with the interaction effect.
DATA
Residence XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX30
Sales Price (in $ XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX
Square feet XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX2400
Rooms XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX 9
Bedrooms XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX
Age XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX16
View XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX