Thank you. Worksheet #10An analyst for a shopping district would like to determine the rent that should be charged for retailspaces depending on how close they are to parking. The analyst takes a random sample of retail spacesin similar shopping districts and measures the monthly rent ($) and distance from parking (in yards) foreach retail space. This is the same regression you worked with in Worksheet #9.Here is the complete Excel output for this regression:SUMMARY OUTPUTRegression StotisticsMultiple RR Square0.70760.5007Adjusted RSquareStandard Error0.4918978.8761Observations58ANOVASignificanerdfSSMSRegression153809748.9753809748.9756.15725.28E-10Residual5653659115.74958198.4954Total57107468864.7Coefficientst StatP valueUpper 95%Standard ErrorLower 95%Intercept15003.10249.346460.171.4E-5214503.5915502.6Distance-11.421.5239-7,495.28E-10-14.478.37NOTE: Excel uses scientific notation for very small numbers. So the p-value = 5.28E-10 = 5.28 x 10 10 -0.000000000528. In the hypothesis test, you may truncate that to 0.000. Very tiny p-values with morethan four zeroes after the decimal are often expressed as 0.000 or .000 when they are reported andinterpreted. 4) Calculate the Coefficient af Determination: R - Confirm that this is the same value Excelreported in the Regression Statistics table the top table in the output). Interpret R in words.5) Calculate the Standard Error of the Estimate, s- VMSE. Conlirm that this is the same value Excelreported in the Regression Statistics table the top table in the output above). Interpret s in words.6) Calculate the Correlation Coefficient, Ry - VR2, Confirm that this is the same value Excel reportedin the Regression Statistics table (the top table in the output above). Interpret R, in words, using therule of thumb from lecture.

Name: Thank you. Worksheet #10An analyst for a shopping district would like
Uploaded: 2024-03-20T07:07:37.000Z
Channel: Bartleby
Description: Thank you. Worksheet #10An analyst for a shopping district would like to determine the rent that should be charged for retailspaces depending on how close they are to parking. The analyst takes a random sample of retail spacesin similar shopping dist