4-1 Correlation and Regression on Data Set 2 .xls

# 4-1 Correlation and Regression on Data Set 2 .xls - Column1...

• 7

This preview shows 1 out of 7 pages.

Column1 Mean 75195.92 Standard E 1352.863 Median 74840 Mode #N/A Standard D 4686.455 Sample Var 21962862 Kurtosis -1.436043 Skewness -0.09226 Range 13699 Minimum 67956 Maximum 81655 Sum 902351 Count 12

Subscribe to view the full document.

Annual Salary Sample of Annual Salaries of Plan 74343 Output 70532 67956 Mean 75195.916667 78024 Standard Error 1352.8630833 80197 Median 74840 69444 Mode #N/A 81655 Standard Deviation 4686.4551918 73438 Sample Variance 21962862.265 79111 Kurtosis -1.436042927 75337 Skewness -0.092260443 71764 Range 13699 80550 Minimum 67956 Maximum 81655 Sum 902351 Count 12 EMPIRICAL RULE lower limit upper limit percent One stdev 70509.4614748238 79882.371859 58.33% 2 Stdev 65823.0062829808 84568.82705 100.00% 3 stdev 61136.5510911379 89255.282242 100.00%
nt Operators

Subscribe to view the full document.

SUMMARY OUTPUT Regression Statistics Multiple R 0.30300518 R Square 0.09181214 Adjusted R Square 0.05937686 Standard Error 1.33523753 Observations 30 PHELP DODGE df SS MS F Regression 1 5.0466073415 5.046607 2.830626 Residual 28 49.9200593252 1.782859 Total 29 54.9666666667 Coefficients Standard Error t Stat P-value Intercept 6.29885057 0.5000101492 12.59745 4.7E-013 X Variable 1 0.04738598 0.0281649303 1.682446

Subscribe to view the full document.

You've reached the end of this preview.

{[ snackBarMessage ]}

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