Analyzing Influenza Case Statistics: Mean, SD, and Outliers

Day # #Reported Cases Mean 1 SD 1 z score 1 18 19.97 9.61 -0.205402 2 15 -0.517506 3 14 -0.62154 4 16 -0.413471 5 14 -0.62154 6 16 -0.413471 7 16 -0.413471 8 16 -0.413471 9 22 0.210737 11 18 -0.205402 12 24 0.418806 13 19 -0.101367 14 27 0.73091 15 29 0.938979 16 21 0.106702 18 25 0.522841 19 29 0.938979 20 49 3.019672 21 33 1.355118 22 24 0.418806 23 24 0.418806 24 24 0.418806 25 26 0.626875 26 21 0.106702 27 26 0.626875 28 37 1.771256 29 16 -0.413471 30 24 0.418806 31 16 -0.413471 32 21 0.106702 33 14 -0.62154 34 17 -0.309436 35 16 -0.413471 36 16 -0.413471 37 14 -0.62154 38 20 0.002668 39 6 -1.453817 40 -15 -3.638545 41 11 -0.933644

Step 1 > Find the mean and standard deviation Step 2 > Identify and highlight outliers based on Z > |3|

Day # #Reported Cases Mean 2 SD 2 Step 3 > Delete the 1 18 20.135 6.334 Step 4 > Calculate t 2 15 Step 5 > Do you see 3 14 4 16 5 14 6 16 7 16 8 16 9 22 11 18 12 24 13 19 14 27 15 29 16 21 18 25 19 29 21 33 22 24 23 24 24 24 25 26 26 21 27 26 28 37 29 16 30 24 31 16 32 21 33 14 34 17 35 16 36 16 37 14 38 20 39 6 41 11 The changes in M towards a higher in the overall va

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

e outliers obtained in Step1-2 sheet and paste the remaining data on the left the mean and sd again (without the outliers) e any difference between the new values (Mean 2 and SD 2) and the values (i.e., Mean 1 and SD 1) th Mean and SD suggest a shift r average value and a reduction ariability of the data.

hat you calculated in Step1-2 sheet? Explain.

Day # #Reported Cases Step 6 1 18 #Reported Cases 2 15 3 14 Mean 20.1351351351 4 16 Standard Error 1.04131050644 5 14 Median 19 6 16 Mode 16 7 16 Standard Deviation 6.33404453095 8 16 Sample Variance 40.1201201201 9 22 Kurtosis 0.45681330752 11 18 Skewness 0.48479518429 12 24 Range 31 13 19 Minimum 6 14 27 Maximum 37 15 29 Sum 745 16 21 Count 37 18 25 Confidence Level(95.0 2.11187559126 19 29 21 33 22 24 23 24 24 24 25 26 26 21 27 26 28 37 29 16 30 24 31 16 32 21 33 14 34 17 35 16 36 16 37 14 38 20 39 6 41 11

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Use data from Step 3-4-5 sheet and predict the CI within which 95% of reported cases will fall into? LCI UCI 18.02326 22.24701

ndividual Task 2_Influenza cases

Related Documents