Suppose you are assisting a business looking to relocate to Dallas Fort-Worth. Housing for their workforce is a major consideration for the city they will choose to locate. The business has narrowed its search to three cities: Allen, Plano, and Wylie. The organization has asked you to provide a data analysis on the housing market in these cities. Make report that provides descriptive statistics, data visualizations, and a written analysis of your results in two cities of your choice for the following variables: living area (square feet), number of bedrooms, number of bathrooms, pool, 2021 market value, and 2022 market value

A) Calculate descriptive statistics for each variable separately for each of two of the cities of your choice.

B) Make table of the frequency and relative frequency for each variable for each of the two cities. Use the bin widths identified below: 1- Living Area: 4 bins with a width of 1,000 square feet. Frequency and relative frequency of homes with less than 2,000 SF, 2,000 - 3,000 SF, 3,000 - 4,000 SF, more than 4,000 SF.

2- Number of bedrooms: 4 bins with widths of your choice.

3- Number of bathrooms: your choice on number and and width of bins.

4- Pool: 2 bins, yes and no.

5- Market Value: 5 bins with a width of $100,000. Frequency and relative frequency of homes with a market value less than $300,000, $300,000 - $400,000, $400,000 - $500,000, $500,000 - $600,000, greater than $600,000.

C) Using the data generated in Step 2, make a relative frequency histogram for each variable, comparing the relative frequency for each of the two cities.

Make a detailed report that summarizes the descriptive statistics for each variable. Include relevant tables and charts from your Excel work. Fully explain the data visuals to help reader understand the descriptive statistics.

	Living area	# of bathrooms	# of bedrooms	Pool	2021 Market Value	2022 Market value
Plano	2,649	4	3	NO	$360,484.00	$475,244.00
Plano	2,600	4	3	NO	$361,222.00	$453,224.00
Plano	2,860	4	3	NO	$374,565.00	$462,320.00
Plano	2,692	4	3	NO	$357,766.00	$449,183.00
Plano	3,572	5	4	NO	$435,066.00	$537,262.00
Wylie	2,619	3	4	NO	$325,144.00	$383,717.00
Wylie	2,238	0	4	NO	$299,696.00	$354,015.00
Wylie	2,580	3	4	YES	$364,580.00	$422,332.00
Wylie	2,921	3	4	NO	$352,361.00	$414,575.00
Wylie	2,551	2	4	NO	$336,013.00	$402,937.00