Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

AutoSave Stats Excel nick Jacka Insert Draw Page Layout Formulas Data Review Vie

ID: 3045814 • Letter: A

Question

AutoSave Stats Excel nick Jacka Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do Share Cut Calibri 11A A Ee wrap Text General Copy Conditio FormattingTable Styles' Fonmat as Cell Insert Delete Fo Merge & Center Format Painter Clipboard Filter Select Editing Alignment Cells A3 In past years when I taught BUS 305 in the classroom, we would often gather data from students on their height in inches and their dress shoe size. A subset of that data was used to create the regression model here, where shoe size serves as the independent x) variable and height as the dependent (y) variable SUMMARY OUTPUT Rearession Stotistics Multiple R R Square Adjusted R Square Standard Error Observations 0.8942 0.7996 0.7961 1.9020 60 10 Use the regression results to answer the questions in Blackboard. 12 ANOVA MS 16 Regression Residual Total 0.0000 837.2513 837.2513 231,4259 209.8320 3.6178 58 59 1047.0833 Coefficients Standard Error tStatP-value Intercept Shoe Size 49.4108 1.9014 1.2840 38.4821 0.0000 0.1250 15.2127 0.0000 4 .. Pioblem 1 Problem 2 E- + 100% 2:00 PM Type here to search 2/17/2018

Explanation / Answer

6)

Wearer's Expected Height = 49.41 + 1.9014*Shoe Size

So, each unit increase in Shoe Size will increase the height by 1.9014 units

7)

Correlation Coefficient, R Square= 0.7996

8)

Shoe Size= 9.5

Height = 49.41 + 1.9014*9.5 = 67.47