Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In the realm of real estate, where comprehensive datasets serve as indispensable tools for unraveling market intricacies, the realtor-data.csv file stands out as a trove

"In the realm of real estate, where comprehensive datasets serve as indispensable tools for unraveling market intricacies, the "realtor-data.csv" file stands out as a trove of information. This dataset meticulously documents over 700,000 real estate listings in the United States, encapsulating essential details in its ten discerning columns. From the current status and architectural specifics to geographical nuances like state, city, and zip code, the dataset provides a comprehensive view of each property. Crucial metrics such as bedrooms, bathrooms, acreage, and living space size lay the foundation for exploring trends within the real estate landscape. As we embark on this analysis, our focus narrows to three key variables bedrooms, state, and price. Through a meticulous examination of these factors, our objective is to unveil insights into how the number of bedrooms and the geographical location, represented by the state, influence housing prices. This study aims to contribute valuable findings for informed decision-making, shedding light on the intricate dynamics that govern the pricing dynamics in the dynamic real estate market."

Conduct the analysis by running data mining strategy that produce defendable and significant results (show step by step in excel): Hypothesis testing

Using the results of each of the analysis, select and produce at least one MS Excel visualizations that show the significance of the results. Make sure that:

  • At least one visual is from Excel
  • At least one visual is from Tableau Public

The analyses, the results, and the related visualizations are to be used to produce a persuasive argument in a report that will describe any recommended actions to fully address the problems described in the initial scenario.

image text in transcribed

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

Personal Finance An Integrated Approach

Authors: Bernard J. Winger

4th Edition

0198520972, 9780132696302

More Books

Students also viewed these Finance questions

Question

Compare and contrast what-if analysis and goal seeking.

Answered: 1 week ago

Question

Explain the employee benefits that are required by law.

Answered: 1 week ago

Question

List the types of incentive plans.

Answered: 1 week ago