correlation regression data.xlsx - calls 96 40 104 128 164...

This preview shows page 1 - 8 out of 50 pages.

calls sold 96 41 40 41 calls sold 104 51 calls 1 128 60 sold 0.864632 1 164 61 76 29 72 39 80 50 36 28 84 43 180 70 132 56 120 45 44 31 84 30 0.864632
Image of page 1

Subscribe to view the full document.

Price Sq Ft 245 1400 SUMMARY OUTPUT 312 1600 279 1700 Regression Statistics 308 1875 Multiple R 0.762113713216 R value 199 1100 R Square 0.580817311872 Coefficient of de 219 1550 Adjusted R Square 0.528419475856 405 2350 Standard Error 41.3303236503 324 2450 Observations 10 319 1425 255 1700 ANOVA df SS Regression 1 18934.9347757 Residual 8 13665.5652243 Total 9 32600.5 Coefficients Standard Error Intercept 98.24832962138 58.0334785847 Sq Ft 0.10976773783 0.03296944326 3.3293779624155 98.248329621381 is Y-intercept or A 0.1097677378301 is your slope or B y= is your X
Image of page 2
etermination MS F Significance F 18934.93 11.0847576166179 0.0103940164 1708.196 t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 1.69296 0.128918815854968 -35.577111975 232.07377122 -35.577111975 232.07377122 3.329378 0.010394016376016 0.0337400653 0.1857954103 0.0337400653 0.1857954103 Y= A+B(X) 98.24833 Needs to be less than allowable error to reject Ho 150 200 0 500 1000 1500 2000 2500 3000
Image of page 3

Subscribe to view the full document.

250 300 350 400 450 Chart Title
Image of page 4
V1 a b c d e f V8 V9 V10 comstock 1 1 1 1 3 3 4.00 4.00 0.00 A32 2 2 2 1 1 1 4.00 4.00 0.00 glenn 1 1 2 1 2 3 4.00 4.00 4.00 porter 1 2 2 1 3 3 4.00 4.00 0.00 A66 2 2 2 2 3 1 4.00 4.00 0.00 Farrell 1 2 2 2 1 2 4.00 4.00 0.00 A41 2 2 1 2 3 2 4.00 4.00 0.00 porter 1 2 2 2 3 3 4.00 4.00 0.00 hallerud 1 2 2 1 3 1 4.00 4.00 4.00 krystyna 2 1 2 1 2 2 4.00 4.00 0.00 adams 1 1 1 1 3 3 4.00 3.00 1.20 leindl 1 1 1 1 3 3 4.00 3.00 0.00 Judy Ebe 2 2 2 2 3 3 4.00 4.00 0.00 A65 1 1 2 2 1 1 3.00 4.00 0.00 A11 1 1 2 2 3 1 4.00 4.00 0.00 A63 1 1 2 1 4 1 4.00 3.00 0.00 A84 1 1 2 2 2 1 4.00 4.00 0.00 Williams 2 2 2 1 3 3 4.00 4.00 4.00 A51 1 2 2 2 3 2 4.00 3.00 0.00 A2 1 1 2 1 1 1 4.00 4.00 1.41 debauche 1 1 2 1 4 3 4.00 4.00 3.00 krystyna 1 2 2 1 2 2 4.00 3.00 0.00 Pichop 2 2 1 2 2 3 4.00 4.00 0.00 A57 1 1 1 2 1 2 4.00 3.00 2.00 Jolly 1 1 2 2 3 2 0.00 2.00 0.00 brown 1 1 1 1 3 3 4.00 4.00 0.00 Bruce St 1 1 1 1 2 2 4.00 3.00 0.00 A37 1 1 2 2 1 1 4.00 4.00 2.00 Plessner 1 2 1 2 4 3 4.00 4.00 4.00 bailey 1 1 1 2 4 3 4.00 4.00 3.00 A34 1 1 2 2 4 1 4.00 4.00 0.00 A73 1 1 1 2 3 1 4.00 3.00 2.00 A59 1 1 2 2 3 1 4.00 3.00 0.00 Felice P 1 2 1 2 2 3 3.00 3.00 0.00 bedford 1 2 1 1 4 3 3.00 3.00 0.00 A12 1 1 2 2 2 1 3.00 3.00 0.00 g 1 2 1 1 3 3 4.00 2.00 0.00 Pat Ruck 2 2 2 1 4 3 4.00 3.00 0.00 A64 1 1 2 2 3 1 4.00 4.00 0.00 A83 1 1 2 2 1 2 4.00 2.66 0.00 Shelly F 1 2 2 1 2 2 4.00 3.00 1.00 wilson 1 1 2 1 4 2 3.00 4.00 0.00 metcalf 1 2 1 1 5 3 3.00 4.00 3.00 A54 1 1 2 1 3 1 4.00 0.00 0.00 bridges 2 2 1 2 4 3 4.00 3.00 3.00 stetar 1 2 1 1 2 2 3.00 3.00 0.00 A9 1 1 2 1 4 1 4.00 4.00 1.41
Image of page 5

Subscribe to view the full document.

A4 1 1 2 1 1 2 3.00 3.00 0.00 shoemake 1 2 1 1 4 3 4.00 3.00 0.00 Tim Brid 1 2 1 2 4 3 4.00 4.00 0.00 bridges 1 2 1 1 4 3 2.00 3.00 3.00 bennet 1 1 1 2 4 3 3.00 3.00 1.20 A72 1 1 2 2 2 1 0.00 3.00 1.00 schoolin 1 2 1 2 4 3 2.00 1.00 0.00 A70 2 1 1 1 2 1 4.00 2.00 0.00 A28 1 1 1 1 1 1 3.00 3.00 2.00 A7 1 1 1 1 1 1 4.00 4.00 3.00 Renee Po 1 2 2 1 3 3 4.00 4.00 0.00 Kevin Co 2 2 1 1 2 3 4.00 4.00 1.20 puetz 1 2 1 1 3 3 3.24 3.10 0.00 pielstic 1 2 1 1 4 3 3.24 3.10 1.20 A55 1 1 2 2 1 1 4.00 3.00 1.00 A62 1 2 1 1 2 1 4.00 4.00 0.00 A31 1 1 1 1 4 1 3.00 3.00 0.00 A61 1 1 1 2 2 1 4.00 4.00 0.00 smith 1 2 1 2 3 3 4.00 4.00 0.00 A27 2 2 1 1 1 1 3.00 3.00 3.00 conner 1 2 2 2 4 3 3.00 3.00 2.00 A1 1 1 2 1 3 1 3.00 3.00 2.00 George M 1 2 1 2 4 3 3.00 3.00 0.00 kitchner 1 2 1 1 4 3 4.00 3.00 0.00 Braden 1 2 2 1 3 2 4.00 4.00 3.00 A69 1 1 2 1 4 2 4.00 1.00 1.00 Costello 2 2 2 2 3 2 4.00 4.00 4.00 A45 1 2 2 1 2 1 4.00 3.00 0.00 oneil 1 2 1 1 3 3 3.00 3.00 0.00 A17 1 2 1 2 1 1 3.00 3.00 3.00 A8 1 1 1 1 2 3 4.00 3.00 4.00 A43 1 1 1 1 1 2 3.00 2.00 0.00 A49 2 2 1 2 3 2 4.00 4.00 4.00 A60 1 1 2 2 3 1 3.00 3.00 3.00 stetar 1 2 1 1 2 2 4.00 3.00 0.00 franka 1 2 2 1 2 2 3.00 3.00 1.00 A44 1 1 1 1 1 2 4.00 1.00 1.00 bridges 1 2 1 1 4 3 2.00 3.00 4.00 bandow 1 1 2 1 3 3 2.00 2.00 0.00 A39 1 1 1 1 3 1 3.00 3.00 1.00 clarke 2 2 2 1 3 2 4.00 3.00 4.00 A13 1 2 1 2 1 2 2.89 2.66 1.41 A15 1 2 2 1 1 2 2.89 2.66 1.41 A16 1 2 2 2 1 2 2.89 2.66 1.41 A58 2 2 2 1 1 1 2.89 2.66 1.41 Duncan M 1 2 1 1 4 3 3.00 1.00 0.00 heaphym 1 1 2 1 4 3 4.00 4.00 3.00 harper 1 1 2 1 4 3 4.00 4.00 3.00
Image of page 6
eldridge 1 2 1 1 3 3 4.00 4.00 2.00 A22 1 1 1 1 2 1 3.00 3.00 2.00 Teresa G 2 2 2 1 4 3 3.00 4.00
Image of page 7

Subscribe to view the full document.

Image of page 8
  • Spring '19
  • David Notgrass

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