Question: EIN3235 Course Project Assignment The data file that is provided to you is number of COVID-19 cases reported at different colleges on November 5th 2020.

EIN3235 Course Project Assignment The data file that is provided to you is number of COVID-19 cases reported at different colleges on November 5th 2020. Use this data file and perform the following data analysis by using statistical software like MiniTab, Excel: Tasks 1. Take 10 simple random sample (SRS) each of size of 5, calculate the mean of COVID-19 cases for each sample. Find the distribution of sample means. 2. Take 10 simple random sample (SRS) each of size of 31, calculate the mean of COVID-19 cases for each sample. Find the distribution of sample means. 3. Take one simple random sample (SRS) each of size of 50, calculate the mean and standard deviation of COVID-19 cases for this sample. Use this sample's information to find the 95% CI of population mean. Find the population mean . Is it included in the 95% CI that you calculated? 4. Use one of graphical summary options like, bar chart or pie chart and show the total number of cases for each state. 5. Select 10 colleges, and look up the total student population for each. Is there a correlation between the number of cases and student population? Explain. You will submit. I NEED QUESTION NUMBER 3 ANSWERED. here is the link for the data https://docs.google.com/spreadsheets/d/1Ifbezi-mXcc0cXRz9pqFZKBMw9bXTuqc/edit?usp=drive_link&ouid=111318579258625573777&rtpof=true&sd=true

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!