Question

Hello: Can anybody explain this for me please?

question:

I have 2 columns with vacation rentals yes or no for 2 columns Fall 2010 Fall 2012

Fall 2010 - proportion of units rented = 70/200 = 0.35

Fall 2012 - proportion of units rented = 70/150= 0.467

questions:

Find 95% confidence interval for difference in proportions? (fall 2012 - fall 2010)

Will Fall 2012 have higher rentals than Fall 2010?

null hyp - Fall 2012 <= Fall 2010 rentals
alt hyp - Fall 2012 rentals > Fall 2010 rentals

Can you tell me how i can do this in stat tools or excel and the answer please?

Answer 1