Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed
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 idy

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Elementary & Intermediate Algebra Functions And Authentic Applications

Authors: Jay Lehmann

2nd Edition

0321923456, 9780321923455

More Books

Students also viewed these Mathematics questions