IN-2021-Homework 1.xlsx

IN-2021-Homework 1.xlsx - A B C D E F G H I J K L M N O P Q...

Info icon This preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
X Y X^2 XY Yo (Yo-ybar)^2 (Y-ybar)^2 A 53 45 2809 2385 54.16672 3.7375642718 123.21 B 36 43 1296 1548 38.13466 322.75346059 171.61 C 88 89 7744 7832 87.17391 965.58783433 1082.41 D 84 79 7056 6636 83.40166 745.38059728 524.41 E 86 84 7396 7224 85.28778 851.92674832 778.41 F 64 66 4096 4224 64.54041 71.240509715 98.01 G 45 49 2025 2205 46.62222 89.828277301 50.41 H 48 48 2304 2304 49.45141 44.203756863 65.61 I 39 43 1521 1677 40.96385 229.10312916 171.61 J 67 76 4489 5092 67.3696 127.00381247 396.01 K 54 59 2916 3186 55.10978 0.9805269743 8.41 L 73 77 5329 5621 73.02797 286.55622898 436.81 M 65 56 4225 3640 65.48347 88.049543561 0.01 N 29 28 841 812 31.53322 603.52658149 789.61 O 52 51 2704 2652 53.22366 8.2733353095 26.01 P 22 27 484 594 24.93178 971.45765567 846.81 Q 76 76 5776 5776 75.85716 390.34534272 396.01 R 32 34 1024 1088 34.36241 472.52284152 488.41 S 51 60 2601 3060 52.2806 14.587840087 15.21 T 37 32 1369 1184 39.07772 289.75794971 580.81 SUM 1101 1122 68005 68740 6576.8235363 7049.8 n 20 b 0.943062 a 4.18441 R^2 0.932909 Y(80) 79.62941 Y(92) 90.94616 Y(59) 59.8251 a) Plot the data b) Compute the coefficients of simple / linear regression and examine the significance of the relationship c) Forecast the Y value for the following X values - 80, 92, 59 10 0 10 20 30 40 50 60 70 80 90 100
Image of page 1

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

View Full Document Right Arrow Icon
20 30 40 50 60 70 80 90 100 f(x) = 0.9430624954x + 4.1844096309 R² = 0.9329092366 Chart Title
Image of page 2
Observation X^2 XY Yo (Yo-ybar)^2(Y-ybar)^2 1 6 11.4 36 68.4 18.166 1691.389 2293.692 2 9 15.74 81 141.66 40.10013 368.347 1896.82 3 17 96.38 289 1638.46 98.59116 1544.385 1375.483 4 6 25.53 36 153.18 18.166 1691.389 1139.906 5 7 31.2 49 218.4 25.47737 1143.463 789.1886 6 18 114.27 324 2056.86 105.9025 2172.496 3022.526 7 8 27.18 64 217.44 32.78875 702.4486 1031.213 8 8 35.49 64 283.92 32.78875 702.4486 566.559 9 15 91.95 225 1379.25 83.9684 608.9002 1066.512 10 9 32.03 81 288.27 40.10013 368.347 743.2439 11 6 25.97 36 155.82 18.166 1691.389 1110.389 12 12 57.74 144 692.88 62.03427 7.517286 2.410256 13 5 23.78 25 118.9 10.85462 2346.229 1261.138 14 7 17.7 49 123.9 25.47737 1143.463 1729.936 15 18 111.33 324 2003.94 105.9025 2172.496 2707.901 16 11 49.57 121 545.27 54.72289 20.88135 94.52701 17 17 87.7 289 1490.9 98.59116 1544.385 806.9861 18 10 44.53 100 445.3 47.41151 141.1579 217.9314 19 12 50.98 144 611.76 62.03427 7.517286 69.09766 20 14 91.46
Image of page 3

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

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern