USING EXCEL- To answer these questions

Weights of a certain species of snails are normally distributed with a mean, = 81gand a standard deviation ,= 22g.

1) Using excel If you had 250 snails of this species, how many of them would you expect to weigh between 67g and 98g?(round to nearest integer)

2) According to 7News, pet adoptions recorded a spike during the COVID 19 lockdown period. A veterinary clinic owner wanted to know the proportion of people who adopted a pet during the same period in the Ryde City Council (RCC) area. In a survey of 30 randomly selected RCC residents, 10 of them said they adopted a pet during COVID 19 lockdown.

a) What is the best point estimate for the proportion of Ryde City Council residents who adopted a pet during the COVID 19 lockdown period? (round to 3dp)

Construct a 95% confidence interval to estimate the true proportion of Ryde City Council residents who adopted a pet during the COVID 19 lockdown period.

a) The lower bound is (round to 3dp)

b) The upper bound is (round to 3dp)

While flu vaccination does not prevent COVID-19, flu vaccination is critical to protecting Australians' general health from influenza. A researcher surveyed a random sample of 60 people who had been given the flu vaccine last year and found that 15 did not contract the flu.

1. What is the proportion of people who did not contract the flu? (round to 3dp)
2. What is the lower bound of a95% confidence interval for the proportion of people who did not contract the flu? (round to 3dp)
3. What is the upper bound of a95%confidence interval for the proportion of people who did not contract the flu? (round to 3dp)