The Australian Industry Council (AIC) is an organization of Australian business associations. The role of AIC is to represent the interests of business and to identify the concerns of its members and then plans united actions. In this way business policies are developed and the concems of business are represented to government (if applicable). This year, many of its business members are very concerned that inflation can strongly affect to industry, and profit is varied across industries. The Board of Directors of AIC demands a report from you (as a Director of Industry Policy unit) on this matter. To prepare analyses for the report, you determine to look at the past 50 years and concentrate on 5 industry sectors which are Consumer Staples, Energy, Heath Care, Information Technology, and Materials. For each industry, data on industry profit and inflation figures are collected from the Australian Bureau of Statistics (ABS) and from the Reserve Bank of Australia (RBA). Figures on annual inflation are based on the date of releasing industry profit. All data is stored in file ACC75008_si_2020_data.xlsx with the following variables. Column 4: Profit before income tax . To report the profit before income tax figures (in Smillions) of cach firms in their industry sectors Column B: Industry Sectors To indicate the industry sector which the firm belongs to. There are five industry sectors ol-Consumer Staples o 2 - Energy . 3 - Health Care . 4 - Information Technology o 5 - Materials Column C: Inflation To indicate the period of inflation 1 - the period having annual inflation equal or greater than 3% . 2 - the period having annual inflation less than 3% Present a report of your findings (by answering the questions below) as the Director of Industry Policy unit to the Board of Directors of AIC. In your report, answer the following questions. 1. Is there any evidence to show that the periods of inflation and industry sectors are dependent to each other? 2. Is there evidence to indicate that profits are different among the 5 industry sectors? 3. Is there any evidence to suggest that Information Technology sector has lower profit before income tax than Energy sector? no A before income tax (in $ milli- Industry Inflation 1,500 918 1,758 982 1,027 1,325 2,124 2,420 2,897 3.239 3.882 -N-.----- NNNNNNNNN 3,368 3,574 4,342 4,219 3,568 3,587 3,975 3,050 The Australian Industry Council (AIC) is an organization of Australian business associations. The role of AIC is to represent the interests of business and to identify the concerns of its members and then plans united actions. In this way business policies are developed and the concems of business are represented to government (if applicable). This year, many of its business members are very concerned that inflation can strongly affect to industry, and profit is varied across industries. The Board of Directors of AIC demands a report from you (as a Director of Industry Policy unit) on this matter. To prepare analyses for the report, you determine to look at the past 50 years and concentrate on 5 industry sectors which are Consumer Staples, Energy, Heath Care, Information Technology, and Materials. For each industry, data on industry profit and inflation figures are collected from the Australian Bureau of Statistics (ABS) and from the Reserve Bank of Australia (RBA). Figures on annual inflation are based on the date of releasing industry profit. All data is stored in file ACC75008_si_2020_data.xlsx with the following variables. Column 4: Profit before income tax . To report the profit before income tax figures (in Smillions) of cach firms in their industry sectors Column B: Industry Sectors To indicate the industry sector which the firm belongs to. There are five industry sectors ol-Consumer Staples o 2 - Energy . 3 - Health Care . 4 - Information Technology o 5 - Materials Column C: Inflation To indicate the period of inflation 1 - the period having annual inflation equal or greater than 3% . 2 - the period having annual inflation less than 3% Present a report of your findings (by answering the questions below) as the Director of Industry Policy unit to the Board of Directors of AIC. In your report, answer the following questions. 1. Is there any evidence to show that the periods of inflation and industry sectors are dependent to each other? 2. Is there evidence to indicate that profits are different among the 5 industry sectors? 3. Is there any evidence to suggest that Information Technology sector has lower profit before income tax than Energy sector? no A before income tax (in $ milli- Industry Inflation 1,500 918 1,758 982 1,027 1,325 2,124 2,420 2,897 3.239 3.882 -N-.----- NNNNNNNNN 3,368 3,574 4,342 4,219 3,568 3,587 3,975 3,050