Hello, the data needed for the questions in the image is:

https://docs.google.com/spreadsheets/d/108yY3-3arMBmnWDIfZFWLKPJxK3p11Ya/edit#gid=21585450

Part II [12 marks] a) [6 marks] Using the data in column Sample 1, manually test the hypothesis that the population mean is not equal to 2,000 square feet. Use a 5% significance level and the critical value approach. Confirm your results using software. Is your conclusion supported by the confidence interval from part c)? Explain your answer. b) [6 marks] Using the data in column Sample_p, manually test the hypothesis that the population proportion of properties that are ideal for a family of four is less than 20%. Use a 10% significance level. Calculate the p-value manually (i.e., using a normal distribution table) and explain how it confirms the conclusion reached by using the critical value approach. Assume that the normal approximation is reasonable in this case. Check your results using software