What is a "Location Quotient" and how do I calculate it?

Economics
economic-modelling
Informed  Decisions

Informed Decisions

Contributor

Key Highlights

    • A Location Quotient (LQ) measures how concentrated an industry is in a region compared to a broader benchmark, revealing local strengths.
    • Calculation: Divide the local industry share by the same industry’s share at higher levels. An LQ above 1 means the region is more specialised.
    • Example: In Lismore, the "Information Media & Telecommunications" sector is twice as concentrated as in regional NSW, with an LQ of around 2.2.
    • LQs can be applied to employment, value-added, exports, imports, and more to map economic concentration.
    • Analysts and councils can compute LQs manually (e.g. via Excel) or use tools like economy.id for quick, multi-industry analysis.

Location Quotient (LQ) is a term that we hear a lot when working in the area of economic development so we thought it would be useful to explain exactly what it is and how it can be calculated using our online economic profile economy.id .

An LQ is a simple ratio used to determine the concentration or dominance of a particular industry in a region (i.e. Local Government area) in comparison to a larger reference or benchmark region (i.e. State or Nation). It is traditionally used to compare an industries share of regional employment, however it can also be used for other economic measures, such as value add, imports or exports.

For example, in Lismore NSW, the industry “Information Media and Telecommunications” is relatively small, employing only 461 people or 2.1% of the workforce in 2011/12.

However, when we compare this to Regional NSW, the same industry only represents 0.9% of the workforce. Using this two % figures we can create a LQ to illustration this difference.

Simply divide the Lismore % by the Regional NSW % to calculate the LQ, 2.1 / 0.9 = 2.2. In general, an LQ above 1.5 indicates that there is a degree of specialisation or concentration in that particular industry within the area, therefore with an LQ of 2.2 “Information Media and Telecommunications” is an important industry in Lismore performing well above the average when it comes to employment.

Using this same method you can also calculate the LQs for all the other industries in Lismore. This can be quite time consuming particularly if you would like to do it at the 2 digit ANZSIC code level, so the economy.id site is laid out in a way that allows you do this quickly and simply across all industries.

Firstly, we must access the online economic profile www.economy.id.com.au/lismore, and then go to the employment by industry page in the structure section of the economic profile (as shown below).

All the information you need to calculate the Location Quotient is on this page. You could do it manually for each industry as demonstrated earlier, however by exporting this table to excel and using basic excel skills, you can calculate this for all industries quickly and simply.

To export to excel simply click the export button above the table.

Once you have the table in excel it is simply a case of entering a simple formula in the column of empty cells at the end of the table, for this example it is column I.

To create the LQ for the example above we need to divide the percentages in column C by the percentages in D. This is done by typing the formula ‘=C4/D4’ in the cell at the end of row 4 (Column I). Then simply copy this formula down column I to row 22 to get the LQ for each industry. This gives you the following Location Quotients for employment in each industry in Lismore for the 2011/12 financial year.

Employment (total) by industry

Lismore City2011/121
Industry Number%Regional NSW %Location Quotient
Information Media and Telecommunications4612.10.92.2
Health Care and Social Assistance4,50420.213.21.5
Education and Training2,37210.67.51.4
Professional, Scientific and Technical Services1,1885.34.41.2
Financial and Insurance Services4782.11.81.2
Retail Trade2,95113.211.81.1
Public Administration and Safety1,2805.75.91
Administrative and Support Services6302.83.10.9
Wholesale Trade5412.42.70.9
Arts and Recreation Services2781.21.40.9
Other Services88844.70.8
Agriculture, Forestry and Fishing1,2795.770.8
Construction1,4906.78.60.8
Manufacturing1,3896.28.60.7
Rental, Hiring and Real Estate Services22911.50.7
Electricity, Gas, Water and Waste Services2080.91.50.6
Mining360.22.90.1

Using the LQ for all the industries in Lismore we can see that Lismore has a specialisation in ‘Information Media and Telecommunications’, ‘Health Care and Social Assistance’ and ‘Education and Training’.

To get a more detailed view of each industry you can also create the LQ based on other measures such a value-added or exports. Creating the LQ for other years will also enable you to see how it is changing over time – to see if the specialisation of particular industries is increasing or decreasing.

Councils can benefit from the wealth of economic information in economy.id, which tells the story of your local economy. If you are interested in having a look at economy.id for your council, please drop us a line – info@id.com.au or (03) 9417 2205.

STAY INFORMED

Subscribe to monthly updates