Page Image Banner

Appendix

​​​​Appendix 1. Regression Analysis -Worksheet

​​​​Print the worksheet below to calculate your Proportional Value rates. Refer to the step-by-ste​p instructions on manual calculations​ for clarification.

Table 1-a. Worksheet to Manually Calculate Regression

 ABCDEFG
Male Job ClassesJob Value (X)Job Rate $ (Y)Deviation from Average Job Value (X-XM)Deviation from Average Job Rate $ (Y-YM)Square of (X-XM)Square of (Y-YM)Product of (X-XM)(Y-YM)​
        
        
        
        
        
        
        
        
        
        
        
        
        
Sum       
Mean
(Average)
       

Appendix 2. R-squared-Worksheet

​​​​Print the worksheet below to calculate your R-squared. Refer to the step-b​y-step instructions on manual calculations​ for clarification.

Table 2-a. Worksheet to Calculate R-Squared

 ABCDE
Male Job Class​Job Value (X)Job Rate $ (Y)Predicted Job Rate $ (Pred. Y)Error in Prediction $ (E)Square of error (SQE)
      
      
      
      
      
      
      
      
      
Sum     ​​​

Appendix 3. Pay Equity Job Rates and Adjustments

​​​​Print the worksheet below to calculate your PV job rates. Refer to the step​-by-step instructions on manual calculations​ for clarification.

Table 3-a. Pay Equity Job Rates and Adjustments

Female Job ClassesJob ValuePay Equity Job RateCurrent Job RatePay Equity Adjustment
     
     
     
     
     
     
     
     
     
     
     
     
     ​


​​​P​revious​