Real Estate Property Data provided below: https://docs.google.com/spreadsheets/d/1grL9zKg4Bs6zR9bc7dN0APQsuJVpHmT41sBkoRQqthk/edit?usp=sharing

Required:

• Use Excel to create frequency distributions, Bar charts and Pie charts for number of bedrooms and Number of bathrooms. Comment on the key findings.
• What type of variable (Continuous, Discrete, Ordinal or Nominal) is number of bedrooms and justify your answer.
• Use Excel to create Histogram for Price of the property and Land size (square ft lot). Also Comment on the key findings.
• Show descriptive summary statistics for Price of the property in thousand dollars and Land size (square ft lot). Comment on the shape, canter and spread of these two distributions.
• Check the normality of the Price of the property data with three evidence.
• Construct a 95% confidence interval for the population's average Price of the property, also Interpret the confidence interval.
• Construct a 95% confidence interval for the population's average Land size (square ft lot) of the property, also Interpret the confidence interval.
• Test whether the population's average Price of the property in thousand dollars is different from $530. Formulate the null and alternative hypotheses. State your statistical decision using the significant value () of 5%.
• State your conclusion in context.