Question
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
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