• 1500+ Experts
  • A+ Grade
  • Free Turnitin Report

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!

Get Solution of this Assessment. Hire Experts to solve this assignment for you Before Deadline.

Submit Your Assignment Questions & Get Plagiarism Free Answers.

Assignment-Help-Ireland.jpg

Submit Your Assignment