Question
Researchers need to be able to present and conclude the findings obtained in order to communicate the results with the readers. Given below is the
Researchers need to be able to present and conclude the findings obtained in order to communicate the results with the readers. Given below is the raw data tabulated on number of COVID-19 cases by age group in Malaysia for early 2022. Perform data analysis employing built-in function of Microsoft Excel to answers the following questions.
a. Determine the minimum, maximum, mean and standard deviation of the COVID19 cases for each age group.
b. By using the mean values obtained in plot a bar chart showing each age groups with the error bars based on the calculated standard deviation.
c. Referring to the data, does the COVID-19 cases for the age group of 0-4 years old baby and 60-69 years old adults is equivalent? Show the statistical data and show the analysis summary.
d. Is there any significant difference in the COVID-19 cases between all the age group? Show the statistical data and show the analysis summary.
Number of COVID-19 cases by age group in Malaysia (Weeks 1-20, 2022) Age groups (years old) Weeks 0 - 4 5 - 11 12 - 17 18 - 29 30 - 39 40 - 49 50 - 59 60 - 69 70 - 79 80+ Week 1 1,564 2,293 996 5,790 5,504 3,273 2,327 1,985 853 271 Week 2 1,322 1,933 961 5,213 4,761 2,864 2,285 1,813 771 274 Week 3 1,215 1,985 1,038 5,178 4,859 2,907 2,389 1,873 817 246 Week 4 1,233 2,148 1,242 5,093 4,657 2,761 2,210 1,688 702 234 Week 5 1,165 2,006 2,030 5,736 4,399 2,433 1,976 1,367 539 165 Week 6 1,197 2,435 3,855 6,979 5,331 3,185 2,379 1,567 574 168 Week 7 1,662 3,642 4,251 10,757 7,566 4,056 2,568 1,636 611 195 Week 8 3,651 6,964 6,331 20,965 16,019 8,829 5,567 3,609 1,498 504 Week 9 7,245 13,804 12,164 44,661 33,521 19,530 12,602 7,423 2,924 963 Week 10 9,439 17,208 13,566 53,530 42,827 25,332 16,362 9,376 3,989 1,356 Week 11 10,108 14,251 10,031 51,742 44,205 26,345 16,828 10,730 4,532 1,581 Week 12 12,115 13,962 9,480 58,626 51,331 29,253 19,063 12,664 5,780 2,198 Week 13 11,396 11,532 7,251 49,979 44,953 25,923 17,746 11,863 5,547 2,231 Week 14 9,537 9,734 5,628 38,958 37,069 21,751 14,607 9,486 4,408 2,026 Week 15 7,671 9,795 5,631 30,779 30,300 18,067 11,914 7,577 3,627 1,537 Week 16 6,019 8,172 4,471 23,047 23,311 13,333 8,284 5,135 2,442 1,065 Week 17 4,063 6,102 5,075 15,995 17,518 10,091 6,130 3,712 1,755 881 Week 18 2,894 4,484 6,916 12,138 12,861 7,445 4,441 2,911 1,361 634 Week 19 1,461 2,467 3,391 6,780 7,059 4,372 2,539 1,629 801 342 Week 20 538 746 967 2,942 2,887 1,872 1,107 787 386 197 (Sou http idyStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started