HW 7 Excel

HW 7 Excel - 114 18 4.736198 Intercept 3.867507 0.002948...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Salary Year Log Salary 50 1 3.912023 53 2 3.970292 56 3 4.025352 58 4 4.060443 61 5 4.110874 Multiple R 0.999767 63 6 4.143135 R Square 0.999533 67 7 4.204693 Adjusted R 0.999507 70 8 4.248495 Standard E 0.006346 74 9 4.304065 Observatio 20 78 10 4.356709 81 11 4.394449 ANOVA 85 12 4.442651 df SS MS F ignificance F 90 13 4.49981 Regression 1 1.552374 1.552374 38552.83 1.9E-031 93 14 4.532599 Residual 18 0.000725 4.0E-005 99 15 4.59512 Total 19 1.553099 104 16 4.644391 109 17 4.691348 Coefficients tandard Err t Stat P-value Lower 95%Upper 95%ower 95.0% Upper 95.0%
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 114 18 4.736198 Intercept 3.867507 0.002948 1312.036 2.8E-046 3.861314 3.8737 3.861314 3.8737 120 19 4.787492 X Variable 0.048316 0.000246 196.3488 1.9E-031 0.047799 0.048833 0.047799 0.048833 126 20 4.836282 5 10 15 20 25 20 40 60 80 100 120 140 f(x) = 3.9330827068x + 41.2526315789 R = 0.9831813991 Salary over time 5 10 15 20 25 1 2 3 4 5 6 f(x) = 0.0483156041x + 3.8675071714 R = 0.9995333261 Log Salary...
View Full Document

This note was uploaded on 02/16/2012 for the course STOR 155 taught by Professor Andrewb.nobel during the Fall '08 term at UNC.

Ask a homework question - tutors are online