The transition from pre-COVID to the economic downfall that was due to the pandemic lead businesses in multiple industries to reconsider their business model and merchandise due to the restriction on the purchasing power from face-to-face transactions. In this analysis we shall extract data mined between 2017 - 2020 by the Australian Bureau of Statistics (ABS) to discuss the money commited for Business expenditure for R&D (BERD) in each industry in Australia to reveal any potential trends regarding the industry's growth and future foresights.
-
Originally the provided data set categorised the industries under 'Industry' and 'Subindustry', these have been changed to 'Division' and 'Subdivision' as defined by the ABS by 1292.0 - Australian and New Zealand Standard Industrial Classification (ANZSIC), 2006 (Revision 1.0) .
-
While 'Industry', 'Sub-industry', and 'Total expenditure on R&D' are personally defined according to the value of the data provided. The remaining Fields are defined by the ABS by 1297.0 - Australian Standard Research Classification (ASRC), 1998.
| New name | Description |
|---|---|
| Division | Branch of economy dedicated to manufactor a new certain good, as defined by the ABS |
| Subdivision | The more specific class of the industry |
| Pure basic research | Experimental and theoretical work undertaken to acquire new knowledge without looking for long term benefits other than the advancement of knowledge. |
| Strategic basic research | Experimental and theoretical work undertaken to acquire new knowledge directed into specified broad areas in the expectation of useful discoveries. It provides the broad base of knowledge necessary for the solution of recognised practical problems. |
| Applied research | Original work undertaken primarily to acquire new knowledge with a specific application in view. It is undertaken either to determine possible uses for the findings of basic research or to determine new ways of achieving some specific and predetermined objectives. |
| Experimental development | Systematic work, using existing knowledge gained from research or practical experience, that is directed to producing new materials, products or devices, to installing new processes, systems and services, or to improving substantially those already produced or installed. |
| Total expenditure on R&D | The estimated total amount of money (AUD) spent on including the hidden amounts due to data privacy protection. |
- Top Industries' commitment to R&D.
- Top States and Terrortories with the largest commitment to R&D.
- Types of Research with the largest commitment to R&D.
Top Industries' commitment to R&D
It was able to extract that the top 3 industries alone contribute to approximately 75% of the BERD contribution. These industries in descending order are
- Professional, Scientific, and Technical Services having had the greatest contribution to the BERD ($6.101 billion AUD/34%).
- Manufacturing ($4.763 billion AUD/26%).
- Financial and Insurance Services ($2.714 billion AUD/15%).
From Figure 1 it can be concluded that there was on average a 6.7% increase on the funding for Research and Development. Even after adjusted for inflation at a 0.89% according to the Reserve Bank of Australia.
It should also be pointed out that there was an overall redistribution of the funding for the BERD, as industries such as Retail Trade, Construction, and Information Media, Telecommunications, which could have been reallocated to Professional, Scientific, and Technical Services from large telecommunications and technology companies merging (ie. Telstra, Afterpay and Block).
This can be accredited to the transition away from face-to-face/in person business operations to virtual and online business operations. This includes the (essentially) mandatory and fundamental dependency on the use of over the internet communications to keep in contact with families. It should be taken into investigation regarding the use of internet from each different age group over the pandemic. This transition also includes the use of online shopping for everyone's grocery shopping and personal goods, as a result from news reports CONTINUE
Figure 1: Top 10 Industry's Commitment to Research and Development Graph
The data set files can be downloaded directly from the original source from the Australian Bureau of Statistics or in the GitHub repo.
| Data set | Year | Web download | GitHub download |
|---|---|---|---|
| Business expeniture on R&D, by ANZIC06 industry subdivision, by type of activity | 2017-18 | Web Link | GitHub Link |
| Business expeniture on R&D, by ANZIC06 industry subdivision, by location of expenditure | 2017-18 | Web Link | GitHub Link |
| Business expeniture on R&D, by ANZIC06 industry subdivision, by type of activity | 2019-20 | Web Link | GitHub Link |
| Business expeniture on R&D, by ANZIC06 industry subdivision, by location of expenditure | 2019-20 | Web Link | GitHub Link |
- Import the analysis from xlsx to csv then run Python scripts under the Jupyter Notebook. This can be found here
- As I assume that there as an overhaul of the interface of the ABS's web interface I was not able to extract the data sets for 2011-12, 2013-14, and 2015-16. As a result it was required to create data from the original website's overall summary of these years, not allowing for more deep data mining and analysis for these years.
- These data sets were not able to be provided in .csv format, rather exclusively as a restricted .xlsx file. As a result, data was mined and analysed by simple data extraction from the values of the table onto another .xlsx file.
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent