Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

As described in the module overview, I am going to give you a data file and let you analyze it on your own. I want

As described in the module overview, I am going to give you a data file and let you analyze it on your own. I want you to use at least three of the tools we have covered this term on this project. In the end, you will turn in four things:

1. Excel file showing the application of your first selected tool (or set of tools).

2. Excel file showing the application of your second tool (can be the same workbook with different worksheets).

3. Excel file showing the application of your third tool (can be the same workbook with different worksheets).

4. A MS Word document explaining what you were able to learn about your data set from your analysis.

Here is the scenario. Imagine I am a property developer in the Boston, MA area. I am looking for neighborhoods where there is opportunity for development or there is opportunities for home repair / reconstruction. I have been given a list of 506 neighborhoods. Each of the neighborhoods is described in my data set through 14 fields which are described in the data dictionary below.

Now Imagine that I am enlisting your assistance. Given that I have 14 figures for each neighborhood, I need you to mine through the data and see what you can tell me about it. Which neighborhoods are the best for me to consider seeking construction or remodel opportunities? Which ones are the more affluent? Which ones may have problems that I want to avoid? Which ones will be most appealing to home buyers? What else can you tell me about the data?

Remember, conduct analysis and find me three things about the data set that I might find useful. Then tell me why those three things are interesting.

PLEASE HELP ME WITH THE EXCEL TOOLS AND FEW THINGS ON WHAT AND WHY YOU USED THOSE TOOLS. THANK YOU

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

Recommended Textbook for

Auditor Essentials 100 Concepts Tips Tools And Techniques For Success

Authors: Hernan Murdock

1st Edition

1138036919, 978-1138036918

More Books

Students also viewed these Accounting questions

Question

What are the objectives of Human resource planning ?

Answered: 1 week ago

Question

Explain the process of Human Resource Planning.

Answered: 1 week ago