THE ANSWER SHOULD BE GIVEN IN EXCEL

3. Vegetable vendors in Bangalore throw away 15% of their produce because of spoilage. Assume that this is the true population proportion. Dr. Singh plans to take a sample survey of 640 vegetable vendors to further investigate their behavior. There are more than 15,000 vegetable vendors in Bangalore.

a. Show the sampling distribution of (p) the proportion of vegetables thrown out by the sample respondents.

b. What is the probability that the survey will provide a sample proportion within .03 of the population proportion?

c. What is the probability that the survey will provide a sample proportion within .01 of the population proportion?