Question: Excel maths question (MUST BE MICROSOFT EXCEL) please provide link to the excel file below after answering. The data in the table below gives the
Excel maths question
(MUST BE MICROSOFT EXCEL)
please provide link to the excel file below after answering.

The data in the table below gives the median house price in Brisbane over the twelve years from 2012 to 2022. Open a new spreadsheet and enter this data from cell A1 to cell 312, name the worksheet Question 4. Brisbane median house price (5'000} 440 448 Source: Australian Bureau of Statistics (a) Enter this data into a new worksheet, call it Question 4, and use Microsoft Excel to produce a scatter graph of Brisbane house prices over the ten years. (b) in cell 315, enter Microsoft Excel's rate function to calculate the average annual rate of growth in median house price for Brisbane from 2012 to 2022. Give the annual rate of growth as a percentage rounded to one decimal place
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
