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

3.52 Rating (149 Votes )

There are 3 Steps involved in it

Step: 1

If that s the case I would start with the Growth column When you re looking at building homes and se... 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

Recommended Textbook for

Business Statistics In Practice Using Data Modeling And Analytics

Authors: Bruce L Bowerman, Richard T O'Connell, Emilly S. Murphree

8th Edition

1259549461, 978-1259549465

More Books

Students also viewed these Accounting questions

Question

Explain how to find the expected value of perfect information.

Answered: 1 week ago

Question

In your own words, define a nonconforming unit.

Answered: 1 week ago