Answered

Looking for answers? Westonci.ca is your go-to Q&A platform, offering quick, trustworthy responses from a community of experts. Get quick and reliable answers to your questions from a dedicated community of professionals on our platform. Experience the ease of finding precise answers to your questions from a knowledgeable community of experts.

The North Valley Real Estate data reports information on homes on the market. Use the selling price of the home as the dependent variable and determine the regression equation using the size of the house, number of bedrooms, days on the market, and number of bathrooms as independent variables.


picture Click here for the Excel Data File


a-1. Develop a correlation matrix. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.)



a-2. Which independent variables have strong or weak correlations with the dependent variable?



a-3. Do you see any problems with multicollinearity?

multiple choice 1
Yes
No


b-1. Use a statistical software package to determine the multiple regression equation. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.)



b-2. What is the value of R2. (Negative amounts should be indicated by a minus sign. Round your answer to 1 decimal places.)



c. Evaluate the addition of the variables to the regression equation



d-1. Develop a histogram of the residuals from the final regression equation

Histogram of the residuals 1 Histogram of the residuals 2 Histogram of the residuals 3
3 histograms, Histogram of the residuals 1, Histogram of the residuals 2, Histogram of the residuals 3. Histogram of the residuals 1: The vertical axis plots Frequency ranging from 0 to 35 in increments of 5. The horizontal axis plots Bins ranging from -73100 to 166300 in increments of 34200. The values are as follow: (-73100, 7.5), (-38900, 15), (-4700, 22), (29500, 30), (63700, 20), (97900, 5), (132100, 4), (166300, 2.5). All values approximated. 3 histograms, Histogram of the residuals 1, Histogram of the residuals 2, Histogram of the residuals 3. Histogram of the residuals 2: The vertical axis plots Frequency ranging from 0 to 30 in increments of 5. The horizontal axis plots Bins ranging from -73100 to 194300 in increments of 40500. The values are as follow: (-73100, 12), (-32600, 17.5), (7900, 27), (484400, 25), (88900, 17.5), (129400, 1), (169900, 2.5), (210400, 4). All values approximated. 3 histograms, Histogram of the residuals 1, Histogram of the residuals 2, Histogram of the residuals 3. Histogram of the residuals 1: The vertical axis plots Frequency ranging from 0 to 30 in increments of 5. The horizontal axis plots Bins ranging from -73100 to 194300 in increments of 38200. The values are as follow: (-73100, 10), (-34900, 20), (3300, 25), (41500, 22.5), (79700, 18), (117900, 2), (156100, 4), (194300, 5). All values approximated.
multiple choice 2
Histogram of the residuals 1
Histogram of the residuals 2
Histogram of the residuals 3


d-2. Is it reasonable to conclude that the normality assumption has been met?

multiple choice 3
Yes
No


e-1. Plot the residuals against the fitted values from the final regression equation. Which plot is correct?

Residuals vs Fits 1 Residuals vs Fits 2 Residuals vs Fits 3
3 histograms, Histogram of the residuals 1, Histogram of the residuals 2, Histogram of the residuals 3. Histogram of the residuals 1: The vertical axis plots Frequency ranging from 0 to 35 in increments of 5. The horizontal axis plots Residuals ranging from -112.50 to 97.50 in increments of 35. The values are as follow: (-112.50, 2.5), (-77.50, 8), (-42.50, 24), (-7.50, 24), (27.50, 30), (62.50, 14), (97.50, 4). All values approximated. 3 histograms, Histogram of the residuals 1, Histogram of the residuals 2, Histogram of the residuals 3. Histogram of the residuals 2: The vertical axis plots Frequency ranging from 0 to 35 in increments of 5. The horizontal axis plots Residuals ranging from -112.50 to 97.50 in increments of 35. The values are as follow: (-112.50, 2.5), (-77.50, 6), (-42.50, 21), (-7.50, 23), (27.50, 27), (62.50, 12.5), (97.50, 4). All values approximated. 3 histograms, Histogram of the residuals 1, Histogram of the residuals 2, Histogram of the residuals 3. Histogram of the residuals 3: The vertical axis plots Frequency ranging from 0 to 35 in increments of 5. The horizontal axis plots Residuals ranging from -112.50 to 97.50 in increments of 35. The values are as follow: (-112.50, 2.5), (-77.50, 8), (-42.50, 19), (-7.50, 15.5), (27.50, 30), (62.50, 12.5), (97.50, 2.5). All values approximated.

multiple choice 4
Residuals vs Fits 1
Residuals vs Fits 2
Residuals vs Fits 3

rev: 10_14_2020_QC_CS-235367, 12_08_2021_QC_CS-287675

Sagot :

Your visit means a lot to us. Don't hesitate to return for more reliable answers to any questions you may have. Thank you for your visit. We're committed to providing you with the best information available. Return anytime for more. Westonci.ca is your trusted source for answers. Visit us again to find more information on diverse topics.