Example: Following is the data set consisting 40 rows on Sales, advertising, Size of the firm and income. We may use MS Excel to compute multiple linear regression.
|
No |
Advertising |
Size |
Income |
Sales |
|
21 |
21 |
1480 |
41 |
215 |
|
22 |
27 |
1590 |
46 |
240 |
|
23 |
32 |
1690 |
50 |
260 |
|
24 |
37 |
1790 |
54 |
280 |
|
25 |
43 |
2020 |
61 |
330 |
|
26 |
23 |
1510 |
42 |
222 |
|
27 |
28 |
1610 |
48 |
248 |
|
28 |
33 |
1710 |
52 |
268 |
|
29 |
38 |
1810 |
56 |
292 |
|
30 |
46 |
2120 |
66 |
345 |
|
31 |
19 |
1450 |
39 |
205 |
|
32 |
25 |
1570 |
45 |
232 |
|
33 |
30 |
1670 |
49 |
258 |
|
34 |
35 |
1770 |
53 |
278 |
|
35 |
41 |
2030 |
60 |
322 |
|
36 |
22 |
1500 |
41 |
218 |
|
37 |
27 |
1600 |
46 |
242 |
|
38 |
32 |
1700 |
50 |
262 |
|
39 |
37 |
1800 |
55 |
285 |
|
40 |
45 |
2100 |
65 |
338 |
Statlearner
Statlearner