QUESTION 1 PART 2 25 MARKS Covid-19 has brought about worldwide disruptions in the way we do business and conduct our daily lives. A number of studies are being conducted to reduce the spread of this pandemic. Experiments are being fast tracked to find a vaccine for immunity and medicines to treat the infected. Other study are being conducted to prevent the spread. The findings of one such study for 10 different districts are shown below. % People who knows someone with covid-19 symptoms 38 47 25 29 25 21 17 18 13 13 % Persons who wear mask in public most or all the time 62 65 76 77 80 83 87 90 91 92 a) Using the regression analysis tool in excel, show the printout for this study 5 marks b) From the printout in a) above develop the least squares estimated regression equation of the study 5 marks c) What is the value of the Product Moment Co-efficient of Correlation? What is the relationship between the variables? 4 marks d) Is the model a good predictor? Explain. 6 marks e) Lincoln district has a population of 230,000, the mayor conducted a survey which indicated that 95% of the persons in Lincoln district wear mask in public most of time. Based on the study above advise the mayor as to the estimated number of persons who would know someone with covid-19 symptoms. 5 marks QUESTION 1 PART 2 25 MARKS Covid-19 has brought about worldwide disruptions in the way we do business and conduct our daily lives. A number of studies are being conducted to reduce the spread of this pandemic. Experiments are being fast tracked to find a vaccine for immunity and medicines to treat the infected. Other study are being conducted to prevent the spread. The findings of one such study for 10 different districts are shown below. % People who knows someone with covid-19 symptoms 38 47 25 29 25 21 17 18 13 13 % Persons who wear mask in public most or all the time 62 65 76 77 80 83 87 90 91 92 a) Using the regression analysis tool in excel, show the printout for this study 5 marks b) From the printout in a) above develop the least squares estimated regression equation of the study 5 marks c) What is the value of the Product Moment Co-efficient of Correlation? What is the relationship between the variables? 4 marks d) Is the model a good predictor? Explain. 6 marks e) Lincoln district has a population of 230,000, the mayor conducted a survey which indicated that 95% of the persons in Lincoln district wear mask in public most of time. Based on the study above advise the mayor as to the estimated number of persons who would know someone with covid-19 symptoms. 5 marks