Question: Do regression and correlation analysis of given data in excel Observations DLH Total Costs 1 89,300 17,682,150 2 93,500 17,641,000 3 95,000 17,709,625 4 100,500
Do regression and correlation analysis of given data in excel
| Observations | DLH | Total Costs |
| 1 | 89,300 | 17,682,150 |
| 2 | 93,500 | 17,641,000 |
| 3 | 95,000 | 17,709,625 |
| 4 | 100,500 | 17,618,250 |
| 5 | 95,500 | 17,819,450 |
| 6 | 97,000 | 17,723,825 |
| 7 | 102,250 | 17,878,400 |
| 8 | 99,500 | 19,508,125 |
| 9 | 96,650 | 17,867,725 |
| 10 | 83,000 | 18,150,625 |
| 11 | 91,850 | 18,084,400 |
| 12 | 91,250 | 18,131,875 |
| 13 | 98,500 | 18,636,950 |
| 14 | 112,500 | 18,805,000 |
| 15 | 98,400 | 18,606,225 |
| 16 | 109,000 | 18,762,725 |
| 17 | 101,000 | 18,758,125 |
| 18 | 81,600 | 18,846,450 |
| 19 | 80,400 | 19,158,150 |
| 20 | 86,000 | 19,193,500 |
| 21 | 115,500 | 19,435,950 |
| 22 | 92,650 | 19,349,450 |
| 23 | 97,950 | 19,339,350 |
| 24 | 91,000 | 19,317,575 |
| 25 | 98,000 | 19,444,825 |
| 26 | 122,000 | 20,052,850 |
| 27 | 101,500 | 19,451,150 |
| 28 | 92,000 | 19,624,900 |
| 29 | 84,000 | 20,080,125 |
| 30 | 116,000 | 19,821,875 |
| 31 | 90,500 | 19,975,825 |
| 32 | 98,250 | 17,312,625 |
| 33 | 105,500 | 19,933,900 |
| 34 | 104,000 | 20,209,000 |
| 35 | 105,000 | 18,004,500 |
| 36 | 106,000 | 19,592,675 |
| 37 | 100,000 | 20,336,250 |
| 38 | 99,350 | 19,435,450 |
| 39 | 104,400 | 18,965,400 |
| 40 | 94,000 | 17,654,675 |
| 41 | 100,750 | 17,972,675 |
| 42 | 102,150 | 20,587,500 |
| 43 | 80,000 | 16,792,000 |
| 44 | 87,000 | 16,801,875 |
| 45 | 96,500 | 17,012,875 |
| 46 | 88,500 | 17,039,175 |
| 47 | 119,000 | 19,513,000 |
| 48 | 96,000 | 17,458,350 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
