Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions