Question
TOPIC=EXCEL SKILLS (Please help) MY SUBURB 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 prelim 2020 change change Growth PA Median Median
TOPIC=EXCEL SKILLS (Please help)
MY SUBURB | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | prelim 2020 | change | change | Growth PA |
Median | Median | Median | Median | Median | Median | Median | Median | Median | Median | Median | Median | 2018-2019 | 2009-2019 | ||
Vacant Land Cost | 218000 | 230000 | 235000 | 231000 | 235000 | 244000 | 246500 | 255000 | 270000 | 276000 | 274000 | 290000 | -1 | 26 | 2.3 |
House Prices/revenue | 72000 | 99000 | 95500 | 91500 | 98000 | 95000 | 97500 | 106000 | 107500 | 117500 | 116000 | 125000 | -1 | 61 | 4.9 |
CPI | 90.1 | 95.7 | 99.5 | 102.4 | 108.3 | 109.7 | 113.3 | 116.1 | 120.7 | 124.3 | 124.9 | 125.4 |
We are a real estate company who builds houses and sell them for profit. I have this data available for a suburb. I want the pros and cons of making a house in it. Building costs can be assumed. I have to use excel functions and charts to represent the data.
The real data from government site is also given for all surburbs (land and house prices). The data is huge 200+ suburbs so i cannot post it here. I want guidance in how to use that data. which charts to use to compare. which excel functions to use. how to decide whether the suburb above is a good choice or not
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started