Hi,

https://docs.google.com/spreadsheets/d/1sBMroeTeBqPWRw-l0VH8-1nsh3zsaJyDE0-cIwOXJ_k/edit?usp=sharing

I have attached a link to google sheets document for the data needed. Please provide solutions for all questions below:

Part] [23 marks] a] [5 marks] Treating the data in column Living Area [sq ft] as the population, use software to nd the population mean and the population standard deviation. Is the population data reasonably normal? Examine a boxplot and a histogram of the data in column Living Area [sq ft] to justify your answer. From here on, assume that the population standard deviation is not known. b] [2 marks] Suppose that for a family of four, the ideal property size is between 2,400 and 2,000 square feet Use software to code the data in column Living Area [sq ft] and put the result in column Ended Data. l[lode living areas between 2,400 and 2,800 square feet as "1" and code living areas outside of this interval as "0". Now calculate the population proportion using software and report the result c] [5 marks] The data in column Sample 1 is a simple random sample drawn from the data in column Living Area [sq ft]. Calculate manually a 95% condence interval for the population mean based on this sample and confirm your calculations using software. d] [5 marks] Code the data in column Sample 1 using the same instructions as in part b] above and put the result in column Sample _p. Calculate manually a 90% condence interval for the population proportion of properties with living areas between 2,400 and 2,300 square feet and confirm your calculations using software. Assume that the required conditions are met, and you can use the normal approximation. e] [-1- marks] Now use software to randomly draw 19 additional samples ofsize n = 40 from column Living Area [sq It]. The procedure must be repeated 19 times. Put these 19 samples in columns Sample 2. Sample 3, Sample 19, Sample 2.0. For each of these additional samples, use software to calculate the 95% condence interval for the population mean. f] [2 marks] Now count the number of condence intervals, obtained from all the 20 samples, that contain the true value of the population mean from part a]. Is this what you might esp ect? Explain your