Sampada Soni - 62310151
Sampada Soni - 62310151
__Assignment 2________________
_____Sampada Soni __________
Q4. To find out the population proportion, column 8 was created with a conditional formula
that had values:
If Age>30, then 1
Or else 0
This yields the population proportion of 0.288443. Through this we can interpret that 28.8% of
the houses are old. Then we generated a histogram and created the 95% and 99% confidence
intervals for this proportion of old houses in the region. Applying CLT, we can conclude:
A) For 95% Confidence Interval- We are 95% confident that population proportion of old
houses lies in the range- 0.260957-0.31593
B) For 99% Confidence Interval- We are 99% confident that population proportion of old
houses lies in the range- 0.252296-0.324591