**The Shift - Overall Growth Column will have the same percentage since this is the overall shift for the economy of Canada (this percentage should be what you calculated for Column G5) Location Quotient = local employment in an industry divided by total local employment ALL divided by national employment in an industry divided by total national employment LQ Transportation 1st Pt in Time LQ Construction 1st Pt in Time LQ Transportation 2nd Pt in Time LQ Construction 2nd Pt in Time Proportional Shift (change of an industry to the total of all industries) - calculated by subtracting the total of all industry rate of growth for the country from the industry by industry growth or decline Differential Shift (dif in the rate of growth or rate of decline in a local industry compared to the same industry nationally) - calculated by subtracting the rate of growth of ea industry at the national level from the rate of growth of the same industry at the local level Proportional Shift Relative change of an industry to the total of all industries Does that industry have an advantage of disadvantage compared to overall economic growth If Transportation and warehousing are growing faster than the overall economy they are proportionately more likely to contribute to economic growth This calculation allows you to look at the industries that contribute to an economy's growth or decline Differential Shift Looks at the difference in the rate of growth or decline in a local industry relative to the rate of growth or decline in the same industry nationally Where the proportional shift is flat (the industry as a whole is growing or declining at the same rate as the overall economy), local growth or decline shows that the local industry is doing better or worse than would be expected if the local area were just like the larger region