MS EXCEL using your House Price Data File, (i) Calculate 90%, 95% and 99% confidence intervals for the average price of a house in City A in 2018: Data Analytics Assignment, NCI, Ireland
University | National College of Ireland (NCI) |
Subject | Data Analytics |
MS EXCEL using your House Price Data File,
(i) Calculate 90%, 95% and 99% confidence intervals for the average price of a house in City A in 2018.
(ii) Calculate a 95% confidence interval for the average size of a terraced house in the east of City A in 2018.
(iii) Calculate a confidence interval for the proportion of detached houses in City A in 2018.
(iv) What sample size would be required to ensure that the sample error in part (iii) is at most 3% (.03).
Save in a MS EXCEL file and upload on LOOP Note: Do not simply type your answers into MS EXCEL. Use MS EXCEL to calculate confidence intervals. Only use operators and functions. Do not use Data Analysis Tools. Presentation is important!