Hit Statics
Week 4 Assignment
GENERAL INSTRUCTIONS: 1. Transfer data into an Excel spreadsheet each one on a specific tab on the bottom broken down into 8 tabs, one for each table (don’t forget to label the document with your name, a title, headings, and each tab). 2. Insert an applicable graph for each of the 8 tables located at the bottom of the table (be sure to label each graph). 3. Submit Excel spreadsheet to the Dropbox.
Here is the data that you are required to put into an Excel document, each on its own tab within the document.
DATA: There were 577 new cases accessioned in the previous year. Site | Total Number | Males | Females | Lung | 77 | 67 | 10 | Larynx | 15 | 6 | 9 | Colon | 72 | 47 | 25 | Stomach | 16 | 8 | 8 | Rectum | 25 | 17 | 8 | Uterus | 27 | 0 | 27 | Bladder | 30 | 16 | 14 | Prostate | 23 | 23 | 0 | Cervix | 38 | 0 | 38 | Breast | 72 | 9 | 63 | Others | 195 | 98 | 97 |
Stage at Diagnosis | Number | In Situ | 41 | Localized | 262 | Regional | 230 | Distant | 56 |
Age Distribution | Number | 11-25 | 58 | 26-40 | 89 | 41-60 | 217 | 61-75 | 141 | 76+ | 84 |
Number of Lung Cancer Case Accessioned over a 5 Year period Year | Number | 1998 | 33 | 1999 | 46 | 2000 | 40 | 2001 | 68 | 2002 | 77 |
Lung Cancer - Age at Diagnosis Age | Number | 0-44 | 0 | 45-54 | 3 | 55-64 | 18 | 65-74 | 52 | 75+ | 4 |
Diagnosis of Lung Cancer Made By: How Dx Made | Number | Excision of lesion | 2 | Percutaneous biopsy | 22 | Bronchoscopy | 49 | Mediastinoscopy | 4 |
Histology of Lung Cancer Histology | Number | Squamous Cell | 10 | Adenocarcinoma | 62 | Undifferentiated | 5 |
Lung Cancer Treatment Type of Treatment | Number | Lobectomy | 38 | Pneumonectomy | 19 | Radiation only | 4 | Chemotherapy only | 1 | Combination | 13 | No treatment | 2
GENERAL INSTRUCTIONS: 1. Transfer data into an Excel spreadsheet each one on a specific tab on the bottom broken down into 8 tabs, one for each table (don’t forget to label the document with your name, a title, headings, and each tab). 2. Insert an applicable graph for each of the 8 tables located at the bottom of the table (be sure to label each graph). 3. Submit Excel spreadsheet to the Dropbox.
Here is the data that you are required to put into an Excel document, each on its own tab within the document.
DATA: There were 577 new cases accessioned in the previous year. Site | Total Number | Males | Females | Lung | 77 | 67 | 10 | Larynx | 15 | 6 | 9 | Colon | 72 | 47 | 25 | Stomach | 16 | 8 | 8 | Rectum | 25 | 17 | 8 | Uterus | 27 | 0 | 27 | Bladder | 30 | 16 | 14 | Prostate | 23 | 23 | 0 | Cervix | 38 | 0 | 38 | Breast | 72 | 9 | 63 | Others | 195 | 98 | 97 |
Stage at Diagnosis | Number | In Situ | 41 | Localized | 262 | Regional | 230 | Distant | 56 |
Age Distribution | Number | 11-25 | 58 | 26-40 | 89 | 41-60 | 217 | 61-75 | 141 | 76+ | 84 |
Number of Lung Cancer Case Accessioned over a 5 Year period Year | Number | 1998 | 33 | 1999 | 46 | 2000 | 40 | 2001 | 68 | 2002 | 77 |
Lung Cancer - Age at Diagnosis Age | Number | 0-44 | 0 | 45-54 | 3 | 55-64 | 18 | 65-74 | 52 | 75+ | 4 |
Diagnosis of Lung Cancer Made By: How Dx Made | Number | Excision of lesion | 2 | Percutaneous biopsy | 22 | Bronchoscopy | 49 | Mediastinoscopy | 4 |
Histology of Lung Cancer Histology | Number | Squamous Cell | 10 | Adenocarcinoma | 62 | Undifferentiated | 5 |
Lung Cancer Treatment Type of Treatment | Number | Lobectomy | 38 | Pneumonectomy | 19 | Radiation only | 4 | Chemotherapy only | 1 | Combination | 13 | No treatment | 2