Answer the questions on the top left
AutoSave OFF 2 . Chapters 12-13 Hwk Summer 2021(1) (3) Home Insert Draw Page Layout Formulas Data Review View XLSTAT Tell me Share 0 Comments NIT Calibri (Body) v 11 A = = V ab Wrap Text General IIX F Do X LO * AYO WE Paste BIU a Av $ % ) Insert .00 000 Delete Merge & Center Format v Conditional Format Cell Formatting as Table Styles v Sort & Filter Find & Select Analyze Data B22 4 x fx A B C D E E F G H 1 K K L M N O R S T U V w X 1 13.1 2 Part A. 3 Insert your scatter plot below 4 Equation of the line 5 5 Part B. 6 Meaning of bo 7 Meaning of b1 8 Parts C-G 9 Mean Taxes 10 r-square 11 Rsquare meaning 12 Be sure to include your graphs 13 Evaluate Your Regression assumptions-LIN. 14 Is there evidence of a linear relationship? Conclusions Address 2915 Wilton Avenue 9621 Sutherland 10315 Royal Road 2419 Briggs Chaney Road 1706 Hutchison Lane 13409 Rippling Brook Drive 8917 Whitney Street 12906 Hawks head Terrace 2308 Pepy Lane 112 Southwood Avenue 1514 Gridley Lane 1167 Kersey Road 15810 Bradford Road Assessed Value Taxes 426.7 5013 368.3 3696 310.8 3694 375.5 5199 446.4 4462 507.4 5185 341 8 3412 343.4 3930 433.4 4397 328.5 3269 2918 2870 398.1 4015 390.8 4725 You want to develop a model to predicat taxes of houses based on their assessed value. A sample of 30 houses are given on the left. The taxes (in $) and the assessed value in thousands are given. Be sure to correctly identify the independent and dependent variables. A) construct a scatter plot and assuming a linear relationship, use the least-squares method to compute the regression coefficients bo and bi. b1. B) Interpret the meaning of bo and bi relative to this problem. C) Use the prediction line from part a to predict the mean taxes for a house whose assessed value is $400,000 Dj Determine the coefficient of determination rsquared and interpret its meaning in this problem. E). Perform a residual analysis on your results and evaluate all of the regression assumptions (L.I.N.E.) F) What conclusions can you reach concerning the relationship between taxes and assessed value Note: The data analysis tool will create all of the charts for you and provide most of your needed info for this chapters' questions. 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 521 Ridgeway Drive 1957 Seminary Road 9520 Colesville Road 500 Rockford Drive 10906 Fiesta Road 2200 Nees Lane 1314 Greshamn Road 110209 Grant Avenue 22 Eastmoor Drive 1118 Chickasaw Drive 11529 Daffodil Drive 13512 Sherwood Forest Drive 10014 Lorain Avenue 1412 Flora Terrace 728 Richmond Avenue 12401 Vinton Terrace 111 Heil Road 480.0 4892 479.5 4887 389 3 3921 371.6 3731 312.7 3100 342.1 3635 305.5 3536 275.9 3426 456.6 4641 2318 4011 449.6 4560 507.9 5944 3070 3039 349.9 3499 411 9 3377 276.0 2707 3374 4308 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 SO 51 52 Ch12 Ans. Ch13 Ans. 12.1 12.2 12.3 12.4 13.1 13.2 13.3 CHISqExample ChiSquare2x4 ChiSq2x5 Marascuilo2x4 Marascuilo2x5 + Ready + 82% AutoSave OFF 2 . Chapters 12-13 Hwk Summer 2021(1) (3) Home Insert Draw Page Layout Formulas Data Review View XLSTAT Tell me Share 0 Comments NIT Calibri (Body) v 11 A = = V ab Wrap Text General IIX F Do X LO * AYO WE Paste BIU a Av $ % ) Insert .00 000 Delete Merge & Center Format v Conditional Format Cell Formatting as Table Styles v Sort & Filter Find & Select Analyze Data B22 4 x fx A B C D E E F G H 1 K K L M N O R S T U V w X 1 13.1 2 Part A. 3 Insert your scatter plot below 4 Equation of the line 5 5 Part B. 6 Meaning of bo 7 Meaning of b1 8 Parts C-G 9 Mean Taxes 10 r-square 11 Rsquare meaning 12 Be sure to include your graphs 13 Evaluate Your Regression assumptions-LIN. 14 Is there evidence of a linear relationship? Conclusions Address 2915 Wilton Avenue 9621 Sutherland 10315 Royal Road 2419 Briggs Chaney Road 1706 Hutchison Lane 13409 Rippling Brook Drive 8917 Whitney Street 12906 Hawks head Terrace 2308 Pepy Lane 112 Southwood Avenue 1514 Gridley Lane 1167 Kersey Road 15810 Bradford Road Assessed Value Taxes 426.7 5013 368.3 3696 310.8 3694 375.5 5199 446.4 4462 507.4 5185 341 8 3412 343.4 3930 433.4 4397 328.5 3269 2918 2870 398.1 4015 390.8 4725 You want to develop a model to predicat taxes of houses based on their assessed value. A sample of 30 houses are given on the left. The taxes (in $) and the assessed value in thousands are given. Be sure to correctly identify the independent and dependent variables. A) construct a scatter plot and assuming a linear relationship, use the least-squares method to compute the regression coefficients bo and bi. b1. B) Interpret the meaning of bo and bi relative to this problem. C) Use the prediction line from part a to predict the mean taxes for a house whose assessed value is $400,000 Dj Determine the coefficient of determination rsquared and interpret its meaning in this problem. E). Perform a residual analysis on your results and evaluate all of the regression assumptions (L.I.N.E.) F) What conclusions can you reach concerning the relationship between taxes and assessed value Note: The data analysis tool will create all of the charts for you and provide most of your needed info for this chapters' questions. 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 521 Ridgeway Drive 1957 Seminary Road 9520 Colesville Road 500 Rockford Drive 10906 Fiesta Road 2200 Nees Lane 1314 Greshamn Road 110209 Grant Avenue 22 Eastmoor Drive 1118 Chickasaw Drive 11529 Daffodil Drive 13512 Sherwood Forest Drive 10014 Lorain Avenue 1412 Flora Terrace 728 Richmond Avenue 12401 Vinton Terrace 111 Heil Road 480.0 4892 479.5 4887 389 3 3921 371.6 3731 312.7 3100 342.1 3635 305.5 3536 275.9 3426 456.6 4641 2318 4011 449.6 4560 507.9 5944 3070 3039 349.9 3499 411 9 3377 276.0 2707 3374 4308 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 SO 51 52 Ch12 Ans. Ch13 Ans. 12.1 12.2 12.3 12.4 13.1 13.2 13.3 CHISqExample ChiSquare2x4 ChiSq2x5 Marascuilo2x4 Marascuilo2x5 + Ready + 82%
