Regression Analysis Data
Regression Statistics
|
Multiple R
|
0.455367
|
|
R Square
|
0.207359
|
|
Adjusted R Square
|
-0.05685
|
|
Standard Error
|
771.6569
|
|
Observations
|
25
|
ANOVA
| |
Df |
SS |
MS |
F |
Significance F |
| Regression |
6 |
2803928 |
467321.37 |
0.784815 |
0.59297 |
| Residual |
18 |
10718178 |
595454.32 |
|
|
| Total |
24 |
13522106 |
|
|
|
| |
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
| Intercept |
20951.14 |
8378.948 |
2.5004503 |
0.022287
|
3347.613 |
38554.67 |
| sales |
0.045043 |
0.079711 |
0.5650756 |
0.578998 |
-0.12242 |
0.212509 |
| profits |
-0.00034 |
0.000487 |
-0.695761 |
0.495464 |
-0.00136 |
0.000684 |
| assets |
-7.2E-05 |
9.27E-05 |
-0.781655 |
0.444578 |
-0.00027 |
0.000122 |
| employees |
-0.03029 |
0.058051 |
-0.521801 |
0.608171 |
-0.15225 |
0.09167 |
| sales experience |
-65.8086 |
93.28247 |
-0.705476 |
0.489544 |
-261.788 |
130.1708 |
| tenure |
-22.3804 |
93.75432 |
-0.238713 |
0.814025 |
-219.351 |
174.5903 |
Data for Excel Multiple Regression
| Salary |
Company Revenue |
Yrs Experience |
| 45,200 |
100,000,000 |
2 |
| 47,600 |
100,000,000 |
4 |
| 47,400 |
100,000,000 |
4 |
| 50,100 |
100,000,000 |
7 |
| 53,200 |
100,000,000 |
8 |
| 49,800 |
100,000,000 |
8 |
| 45,100 |
200,000,000 |
2 |
| 45,400 |
200,000,000 |
2 |
| 46,700 |
200,000,000 |
3 |
| 46,500 |
200,000,000 |
3 |
| 53,500 |
200,000,000 |
8 |
| 55,100 |
200,000,000 |
10 |
| 45,100 |
400,000,000 |
1 |
| 46,700 |
400,000,000 |
3 |
| 48,200 |
400,000,000 |
4 |
| 51,900 |
400,000,000 |
6 |
| 52,600 |
400,000,000 |
6 |
| 52,400 |
400,000,000 |
7 |
| 55,100 |
400,000,000 |
8 |
| 55,400 |
400,000,000 |
8 |
| 56,400 |
400,000,000 |
9 |
| 56,300 |
400,000,000 |
10 |
| 57,800 |
400,000,000 |
10 |
| 50,200 |
500,000,000 |
5 |
| 50,700 |
500,000,000 |
5 |
| 52,500 |
500,000,000 |
6 |
| 55,200 |
500,000,000 |
8 |
| 57,200 |
500,000,000 |
9 |
| 45,200 |
700,000,000 |
1 |
| 45,500 |
700,000,000 |
1 |
| 47,800 |
700,000,000 |
3 |
| 49,600 |
700,000,000 |
4 |
| 49,900 |
700,000,000 |
4 |
| 48,900 |
700,000,000 |
4 |
| 52,300 |
700,000,000 |
5 |
| 53,800 |
700,000,000 |
6 |
| 54,100 |
700,000,000 |
6 |
| 58,400 |
700,000,000 |
9 |
| 59,100 |
700,000,000 |
10 |
| 59,700 |
700,000,000 |
10 |
| 46,200 |
1,000,000,000 |
2 |
| 48,100 |
1,000,000,000 |
3 |
| 47,500 |
1,000,000,000 |
3 |
| 49,800 |
1,000,000,000 |
4 |
| 50,200 |
1,000,000,000 |
4 |
| 54,500 |
1,000,000,000 |
6 |
| 57,900 |
1,000,000,000 |
8 |
| 58,200 |
1,000,000,000 |
8 |
| 58,500 |
1,000,000,000 |
8 |