correlation regression data.xlsx

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

• Homework Help
• 50

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

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

Subscribe to view the full document.

250 300 350 400 450 Chart Title
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

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

Subscribe to view the full document.

• Spring '19
• David Notgrass

### 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