STATISTICS
Instructions
You are preparing the 2020 Annual Report for the Hospital Cancer Registry for presentation at the next Cancer Conference. Please use the following information to answer the following questions.
|
DATA: There were 547 newly diagnosed cases in 2020. Site |
Number |
Males |
Females |
|
Lung |
77 |
67 |
10 |
|
Larynx |
11 |
5 |
6 |
|
Colon |
55 |
47 |
8 |
|
Stomach |
16 |
8 |
8 |
|
Rectum |
23 |
17 |
6 |
|
Uterus |
27 |
0 |
27 |
|
Bladder |
27 |
13 |
14 |
|
Prostate |
23 |
23 |
0 |
|
Cervix |
38 |
0 |
38 |
|
Breast |
55 |
2 |
53 |
|
Others |
195 |
98 |
97 |
:
1. Calculate the average number of newly diagnosed cancers for males.
2. Calculate the average number of newly diagnosed cancers for females.
3. Determine the top three cancer sites based on number of cases. Which cancer is highest among males? Among females? Create a table that illustrates this data.
4. What percentage of males were newly diagnosed for lung cancer? What percentage of females were newly diagnosed for bladder cancer?
5. Prepare a pie graph of total cases by type.
I Would need word documents for all answers but charts
Pie charts and tables as an Excel document (.xls, .xlsx)