DS212_Examples_of_Simple_regression_Analysis_in_Excel

DS212_Examples_of_Simple_regression_Analysis_in_Excel -...

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon
Your turn problem on slide#16: Self esteem score and height Height (inches) Self Esteem (0-5) 68 4.1 71 4.6 62 3.8 75 4.4 58 3.2 60 3.1 67 3.8 68 4.1 71 4.3 69 3.7 56 58 60 62 64 0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 Height Self Esteem Score (0-5)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
66 68 70 72 74 76 Column B t (inches)
Background image of page 2
SUMMARY OUTPUT Regression Statistics Multiple R 0.88 R Square 0.78 Adjusted R 0.75 Standard E 0.25 Observatio 10 ANOVA df SS MS F ignificance F Regression 1 1.69 1.69 27.9 0 Residual 8 0.48 0.06 Total 9 2.17 Coefficientstandard Erro t Stat P-value Lower 95%Upper 95%Lower 95.0% Upper 95.0% Intercept -1.51 1.03 -1.47 0.18 -3.88 0.86 -3.88 0.86 X Variable 0.08 0.02 5.28 0 0.05 0.12 0.05 0.12
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Restaurant 1 2 58 2 6 105 3 8 88 4 8 118 5 12 117 6 16 137 7 20 157 8 20 169 9 22 149 10 26 202 Example on slide #24: student population and quarterly sales (based example on slide #12) Student population (in thousands) Quarterly sales (in thousands US$) 0 5 0 50 100 150 200 250 Stud Quarterly sales (thousands)
Background image of page 4
on data in the Buckhead burger 10 15 20 25 30 Column C ent population (thousands)
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
SUMMARY OUTPUT Regression Statistics Multiple R 0.95 R Square 0.9 Adjusted R 0.89 Standard E 13.83 Observatio 10 ANOVA df SS MS F ignificance F Regression 1 14200 14200 74.25
Background image of page 6
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 8
Background image of page 9
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Residual 8 1530 191.25 Total 9 15730 Coefficientstandard Erro t Stat P-value Lower 95%Upper 95%Lower 95.0% Upper 95.0% Intercept 60 9.23 6.5 38.72 81.28 38.72 81.28 X Variable 5 0.58 8.62 3.66 6.34 3.66 6.34 Example on slide#27: Lobster dinners problem Price ($) (X) Order Qty (Y) 6 200 6.5 190 6.75 188 7 180 7.25 170 7.5 162 8 160 8.25 155 8.5 156 8.75 148 9 140 9.25 133 5.5 6 6.5 7 50 100 150 200 250 Pric Order Qty 7.5 8 8.5 9 9.5 Column B ice ($) SUMMARY OUTPUT Regression Statistics Multiple R 0.98 R Square 0.97 Adjusted R 0.97 Standard E 3.79 Observatio 12 ANOVA df SS MS F ignificance F Regression 1 4638.31 4638.31 323.55 Residual 10 143.36 14.34 Total 11 4781.67 Coefficientstandard Erro t Stat P-value Lower 95%Upper 95%Lower 95.0% Upper 95.0% Intercept 315.98 8.46 37.37 297.14 334.82 297.14 334.82 X Variable -19.51 1.08-17.99-21.93-17.1-21.93-17.1...
View Full Document

{[ snackBarMessage ]}

Page1 / 9

DS212_Examples_of_Simple_regression_Analysis_in_Excel -...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online