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)