Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started