Externalcompetitiveness11.xlsx
Sheet1
| | | | | Weighted Pay | | Job Evaluation Points |
| | Front Desk Receptionist | | | 27611.07 | | 120 |
| | Administrative assistant | | | 35749.99 | | 200 |
| | Operations analyst | | | 63325 | | 300 |
| | Production worker | | | 29118.98 | | 290 |
| | Benefits manager | | | 62000 | | 400 |
| | | | | Regression Statistics |
| | | | | Multiple R | | | 0.993 |
| | | | | R Square | | | 0.978 |
| | | | | Adjusted R Square | | | 0.965 |
| | | | | Standard Error | | | 3800 |
| | | | | No. of Observations | | | 4 |
| | | | | ANOVA |
| | | | | | | df | | SS | | MS | | f | Significance F |
| | | | | Regression | | 2 | | 1406565190 | | 1406565190 | | 99.9496 | 0.00345456 |
| | | | | Residual | | 2 | | 53137605.3 | | 15065635 |
| | | | | Total | | 4 |
| | | | | | | Coefficients | | Standard error | | tStat | | P-Value | Lower 98% |
| | | | | Intercept | | -25324.556 | | 7332.5 | | -4.6578 | | 0.0565 | -56509.88 |
| | | | | X variable 1 | | 465.32105 | | 40.456 | | 10.5678 | | 0.00546 | 357.856 |
| | | | | Y= -25324.6 |
| | | | | X =465.3211 |