All required information is included. There is no further information that I can provide. All questions are individually taken and present, along with excel spreadsheet link. One request, when answering the multiple questions can you format the answers like shown in the questions? With clear and precise answers to each question. Thank you.

https://linksharing.samsungcloud.com/sjYbmWA2fx41

Screen Shot 2023-04-21 at 9.36.01 AM O Search Problem Set 14 i Saved Help Save & Exit Submit Check my work m 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. points picture Click here for the Excel Data File:Problem Set 14 i Saved Help Save & Exit Submit Check my work 3 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. 25 points picture Click here for the Excel Data File:a-1. Develop a correlation matrix. (Round your answers to 3 decimal places.) eBook Price Size (Square feet) Bedrooms Baths Days on Market Price 1 Size (Square feet) Bedrooms 1 Baths 1 Days on MarketeBook a-2. Which independent variables have strong or weak correlations with the dependent variable? There is a correlation between "Price" and the independent variables "Bedrooms", "Size", and "Baths"eBook a-3. Do you see any problems with multicollinearity? Yes O NoeBook 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.) -:I:- b-2. What is the value of R2. (Round your answer to 3 decimal places.) 25 points R2 eBook25 mints c. Evaluate the addition of the variables to the regression equation d-1. Develop a histogram of the residuals from the final regression equation. Which histogram is correct? 25 Histogram of the residuals 1 Histogram of the residuals 2 Histogram of the residuals 3 points Histogram Histogram Histogram eBook 30 30 30 25 25 25 20 20 15 Frequency 15 15 10 10 Frequency OUS Frequency UT Frequency OUT -73100 -42900 -12700 17500 47700 77900 108100 138300 -73100 -34600 3900 42400 80900 119400 157900 196400 -73100 -34900 3300 41500 79700 117900 156100 194300 Bins bin Bing O Histogram of the residuals 1 O Histogram of the residuals 2 O Histogram of the residuals 33 25 Yes points 0 NO d-2. Is it reasonable to conclude that the normality assumption has been met? 25 e-1. Plot the residuals against the fitted values from the final regression equation. Which plot is correct? points Residuals vs Fits 1 Residuals vs Fits 2 Residuals vs Fits 3 Residuals Vs. Predicted Residuals Vs. Predicted Residuals Vs. Predicted eBook 150000 150000 150000 . 100000 100000 100000 50000 5000 50000 O 100000 200 3008 409060 500000 600000 700000 800000 100000 200000 30000 409080 500000 600000 700000 800000 100000 200900 300080 409090 500000 600000 700000 800000 900000 . -50000 -50000 -50000 -100000 -100000 -100000 -150000 150000 150000 O Residuals vs Fits 1 O Residuals vs Fits 2 O Residuals vs Fits 3