Apply wk 5 (1)

.pdf
This is a preview
Want to read all 8 pages? Go Premium today.
View Full Document
Already Premium? Sign in here
Lakiesha Domingue Dat/565: Apply: Regression Modeling Professor: Samantha Bietsch August 17, 2020
Construct a scatter plot in Excel with FloorArea as the independent variable and AssessmentValue as the dependent variable. Insert the bivariate linear regression equation and r^2 in your graph. Do you observe a linear relationship between the 2 variables? Y=0.307x + 162.663 R^2= 0.938 There is a linear relationship between the two variables. As the floor area increase in size, the assessed value increases as well. Use Excel's Analysis ToolPak to conduct a regression analysis of FloorArea and AssessmentValue . Is FloorArea a significant predictor of AssessmentValue ? Regression Statistics R^2 0.93771762 0775008 Standard Error 115.599303 937698 Count of X variables 1
Observation s 32 Adjusted R^2 0.93564154 1467508 Analysis of Variance (ANOVA) df SS MS F Significance F Regression 1 6035851.90 287359 6035851.90 287359 451.677167 335347 1.22547865 248041E-19 Residual 30 400895.972 126411 13363.1990 708804 Total 31 6436747.87 5 Confidence level 0.95 Coefficients Standard Error t-Statistic P-value Lower 95% Upper 95% Intercept 162.662767 277161 54.4785653 123119 2.98581224 275375 0.00558561 1613491 51.4026938 810182 273.922840 673303 X1 0.30673208 4014744 0.01443261 8658272 21.2526978 836887 1.22547865 248041E-19 0.27725674 4456655 0.33620742 3572832 The FloorArea is a significant predictor of assessment value because the p-value is less than .05. Construct a scatter plot in Excel with Age as the independent variable and AssessmentValue as the dependent variable. Insert the bivariate linear regression equation and r^2 in your graph. Do you observe a linear relationship between the 2 variables?
Why is this page out of focus?
Because this is a Premium document. Subscribe to unlock this document and more.
Page1of 8
Uploaded by KidTitaniumAardvark on coursehero.com