Dillard's Promotion: Dillard's is a national chain of stores specializing on clothing's and household utensils. The chain is considering launching a promotion of a new women's outfit and would like to send out discount coupons to all the Dillard's card customers. This promotion will be considered a success if more than 10% of those receiving the coupons use them. Before going national with the discount, a sample of 100 Dillard's card customers who received the coupon were asked whether they used the coupon. The data below summarizes the results from the sample study.

No	No	No	No	No	No	No	No	No	Yes
No	No	No	No	No	Yes	No	No	No	No
No	No	No	No	No	No	No	Yes	No	Yes
Yes	No	No	No	No	No	No	No	No	Yes
No	No	Yes	No	No	No	No	No	No	No
No	No	No	No	No	No	No	No	No	No
Yes	No	No	Yes	No	No	No	No	No	No
No	No	Yes	No	No	No	Yes	No	No	No
No	No	No	No	Yes	No	No	No	No	No
No	No	No	No	Yes	No	No	No	No	No

a) (2) Find the estimate of the population proportion of those that used the coupon.

b) (2) Develop a 95% confidence level of the proportion of Dillard's customers that used the coupon.

c) (2) The management feels that the promotion will be successful if more than 10% of the customers use the coupon. Develop a hypothesis test that confirms the managementassertion that more than 10% of the customers who receive the promotion coupons will use them.

d) (2) Conduct an analysis of the hypothesis s and make a decision

e) (2) Draw a conclusion based on your test results.

Please show the excel work, step-by-step.