Logo - The Pay Equity Commission

   [ exit ] [ Prev ]   [ Contents ]   [ Next ]   

Regression Analysis
- Worksheet -

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

Table 1-a
Worksheet to Manually Calculate Regression
  A B C D E F G
Male Job
Classes		 Job 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)		              

 

   [ exit ] [ Prev ]   [ Contents ]   [ Next ]   

This site is maintained by the Government of Ontario, Canada

© Copyright information: Queen's Printer for Ontario, 2002.

Last modified: April 7, 2008