How do you answer the following question in excel, using excel formulas? with explanation please.

For this problem, carry at least four digits after the decimal in your calculations. Answers may vary slightly due to rounding.

In a marketing survey, a random sample of1010supermarket shoppers revealed that260always stock up on an item when they find that item at a real bargain price.

a) Letprepresent the proportion of all supermarket shoppers who always stock up on an item when they find a real bargain.Find a point estimate forp. (Enter a number. Round your answer to four decimal places.)

______

b) Find a 95% confidence interval forp. (For each answer, enter a number. Round your answers to three decimal places.)

Upper Limit______

Lower Limit______

What is the margin of error based on a 95% confidence interval? (Enter a number. Round your answer to three decimal places.)

Margin of Error______

Thank you!