From Gordon F. Mulligan and Andreas Molin. 2004. Estimating Population Change with a Two-Category Shift-Share Model.
    Annals Regional Science 38: 113-130.          
                   
    e1 (State i 1990)       e2 (State i 2000)  
  Industry 1 Industry 2 Industry 3     Industry 1 Industry 2 Industry 3  
Occupation 1   Occupation 1  
Occupation 2   Occupation 2  
Occupation 3   Occupation 3  
Occupation 4   Occupation 4  
                   
                   
  E1 (Country 1990)     E2 (Country 2000)  
  Industry 1 Industry 2 Industry 3     Industry 1 Industry 2 Industry 3  
Occupation 1   Occupation 1  
Occupation 2   Occupation 2  
Occupation 3   Occupation 3  
Occupation 4 E.1 Occupation 4 E.2
   
                   
    R= (E.2 - E.1) / E.1 R=        
                   
Nj= R * ej1                  
  N2= benchmark growth            
  Industry 1 Industry 2 Industry 3 Total %   Go to Excel Spreadsheet    
Occupation 1          
Occupation 2          
Occupation 3          
Occupation 4          
               
                   
P2= (Rij - R) ej1                
  P2= activity mix            
  Industry 1 Industry 2 Industry 3 Total          
Occupation 1          
Occupation 2          
Occupation 3          
Occupation 4          
               
D2= (rij - Rij) ej1                
  D2= competitive            
  Industry 1 Industry 2 Industry 3 Total          
Occupation 1          
Occupation 2          
Occupation 3          
Occupation 4          
               
                   
      Total Gwth= 100%        

Automatic recalculation 

1