Use excels to solve the following:

1. A market researcher for a provider of cell phone accessories wants to know the proportion of customers who own cars to assess the market for a new cell phone car charger. A survey of 400 customers indicates that 72% own cars.

(a) What is the standard deviation of the sampling distribution of the proportion? (report your answer in 4 decimal places)

(b) How large would the standard deviation have been if he had surveyed only 100 customers (assuming the proportion is about the same)?(report your answer in 4 decimal places)

2. The number of accidents per week at a hazardous intersection varies withmean = 2:2 and standard deviation = 1:4. This distribution only takes whole-numbervalues, so it is certainly not Normal.

(a)Let Xbe the mean number of accidents per week at the intersection during a year(52 weeks). What is the approximate distribution of Xaccording to the Central LimitTheorem?

(b)What is the approximate probability that Xis less than 2? (report your answer in 4 decimal places)

(c)What is the approximate probability that there are fewer than 100 accidents at theintersection in a year? (Hint: Restate this event in terms of X) (report your answer in 4 decimal places)

3. Information on a packet of seeds claims that the germination rate is 83 %. The manufacturer needs to understand the likelihood of this claim. What's the probability that more than 84% of the 180 seeds in the packet will germinate?(report your answer in three decimal places)

NB. I have solved all these problems; I need help in solving them using excel. I.e the formula and a picture of how it should look.

Upload the Excel File Here. Submit a single Excel file, using one worksheet for each problem (3 worksheets for 3 problems in a single excel file) and using proper cell formatting. Name your file with your last name and first name and the assignment number ( 1 AY B I IE E PA U S X2 x2 E E