Business > CASE STUDY > DATA_Week_5.docx DATA 565 Data Analysis and Business Analytics DATA 565 Data Analysis (All)
DATA_Week_5.docx DATA 565 Data Analysis and Business Analytics DATA 565 Data Analysis
Document Content and Description Below
DATA_Week_5.docx DATA 565 Data Analysis and Business Analytics DATA 565 Data Analysis and Business Analytics 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? Yes. Very strong relationship.   Use Excels Analysis ToolPak to conduct a regression analysis of FloorArea and AssessmentValue. Is FloorArea a significant predictor of AssessmentValue? Yes, because the P value is less than .05. The linear regression shows that the P value is equal to 1.23x10-19. Regression Statistics Multiple R 0.968358209 R Square 0.937717621 Adjusted R Square 0.935641541 Standard Error 115.5993039 Observations 32 ANOVA  df . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . .. .. . . . . . . . . . . . . . . . . . .. . . . . [Show More]
Last updated: 2 years ago
Preview 1 out of 6 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Reviews( 0 )
$10.00
Can't find what you want? Try our AI powered Search
Document information
Connected school, study & course
About the document
Uploaded On
Jul 31, 2022
Number of pages
6
Written in
Additional information
This document has been written for:
Uploaded
Jul 31, 2022
Downloads
0
Views
46
