Simple Regression Model.xlsx

# Simple Regression Model.xlsx - 1 A B C E H Assignment Miles...

• 3

This preview shows page 1 - 3 out of 3 pages.

5529b5e2a5cff3816253ae4c244910fb64259383.xlsx Regression and SSE Assignment Miles Time (Observed) Predicted Observed - Predicted SSE i 1 100 9.3 8.06 1.24 1.55 2 50 4.8 4.67 0.13 0.02 3 100 8.9 8.06 0.84 0.71 4 100 6.5 8.06 -1.56 2.42 5 50 4.2 4.67 -0.47 0.22 6 80 6.2 6.70 -0.50 0.25 7 75 7.4 6.36 1.04 1.08 8 65 6.0 5.68 0.32 0.10 9 90 7.6 7.38 0.22 0.05 10 90 6.1 7.38 -1.28 1.63 Total SSE 8.03 Correlation 0.814905707 =CORREL(B3:B12,C3:C12) Intercept, b0 1.2739 =INTERCEPT(C3:C12,B3:B12) Slope, b1 0.0678 =SLOPE(C3:C12,B3:B12) time = .0678(miles)+1.2739 Miles Time 0.0678 1.2739 80 6.6979 m b 81 6.7657 for any one increase in travel (mi) the time is going to increase x amount 40 50 60 70 80 90 100 110 0 1 2 3 4 5 6 7 8 9 10 f(x) = 0.067826087x + 1.2739130435 time v miles miles Time ˆ e i i i y y 2 2 ˆ e ( ) i i i y y 0 1 ˆ i i y b b x i x i y A B C E H K L M N O P Q R S 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
5529b5e2a5cff3816253ae4c244910fb64259383.xlsx Regression and r^2 Assignment Miles Time (Observed) Mean Predicted Predicted - Mean SST SSR SSE i 1 100 9.3 6.70 8.06 2.60 1.36 1.24 6.76 1.84 1.55 2 50 4.8 6.70 4.67 -1.90 -2.03 0.13 3.61 4.14 0.02 3 100 8.9 6.70 8.06 2.20 1.36 0.84 4.84 1.84 0.71 4 100 6.5 6.70 8.06 -0.20 1.36 -1.56 0.04 1.84 2.42 5 50 4.2 6.70 4.67 -2.50 -2.03 -0.47 6.25 4.14 0.22 6 80 6.2 6.70 6.70 -0.50 0.00 -0.50 0.25 0.00 0.25 7 75 7.4 6.70 6.36 0.70 -0.34 1.04 0.49 0.12 1.08 8 65 6.0 6.70 5.68 -0.70 -1.02 0.32 0.49 1.04 0.10 9 90 7.6 6.70 7.38 0.90 0.68 0.22 0.81 0.46 0.05 10 90 6.1

#### You've reached the end of your free preview.

Want to read all 3 pages?

• Fall '17

### What students are saying

• 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.

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

• 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.

Dana University of Pennsylvania ‘17, Course Hero Intern

• 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.

Jill Tulane University ‘16, Course Hero Intern