Make sure the following questions are covered in the data analysis: Create 50 r

Make sure the following questions are covered in the data analysis:
Create 50 randomly selected properties from the random number table based on your PIA ID number, you will need to use these identification numbers to select properties from the Excel sheet of the population property data. Use your data to answer questions 2-10.
Use Excel to create frequency distributions, Bar charts, and Pie charts for the number of bedrooms and bathrooms. Comment on the key findings. (10 marks)
What type of variable (Continuous, Discrete, Ordinal, or Nominal) is the number of bedrooms, and justify your answer. (2 marks)
Use Excel to create Histogram for the Price of the property and Land size (square ft lot). Also, Comment on the key findings. (10 marks)
Show descriptive summary statistics for the Price of the property in thousand dollars and Land size (square ft lot). Comment on the shape, canter, and spread of these two distributions. (15 marks)
Check the normality of the Price of the property data with three pieces of evidence. (8 marks)
Construct a 95% confidence interval for the population’s average Price of the property, also Interpret
Construct a 95% confidence interval for the population’s average Land size (square ft lot) of the
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%. (15 marks)
(10 marks)
the confidence interval. (10 marks)
property, also Interpret the confidence interval. (10 marks)provided
State your conclusion in context.Data is