In this assignment central tendency measures will be calculated for data that is captured from hospital discharge process.

1. Download both data files attached below (Filtering file video is provided as additional guidance).
2. Review the data layout in CHARPublicUseDataSetFileLayout to understand each variable.
3. Filter the data file titled "PatietnDischargeData.csv" based on Principal Diagnosis='A02'
4. Continue the remaining steps using the filtered values.
5. Calculate the measures below using the Charges variable values.
   1. Mean
   2. Mode
   3. Median
   4. First quartile
   5. Third quartile
   6. Interquartile
   7. Standard deviation
   8. Variance
   9. Min
   10. Max
   11. Count
6. Display a scatterplot using the values in Charges and length of stay variables.
7. Explain/interpret the plots and measures calculated (how can the analysis performed in this assignment assist clinical care?)

The submitted assignment document must be a Word document that explains the steps completed and the possible use of the outcomes calculated based on content covered in modules 2 and 3 (guidance provided below). The document must also include screen shots that display all the measures required in the assignment clearly. The measures must be calculated after filtering the data (step 3).

Below a few sample questions/statement are provided to offer guidance in the outcome interpretation (possible use):

1. Discuss the spread of data in Charges variable.
2. What does the spread of the data explain?
3. Does the healthcare facility's charges contain extreme values? Explain your response.
4. Is the increased length of stay correlated with the charges recorded?

pls help

... AutoSave or CHARSPublicuseDataSetFileLayout ABU Page Layout Formulas Home Insert Draw Data Review View Tell me Share Comments X Calibr (Body) v 11 ~ AF A = a ab Wrap Text General Insert 28-0 44 D Dalata v WS Paste BU CA y Ideas Merge & Center % Y Sensitivity Conditional Format Cell Formatting as Table Styles Forma v Sort & Filter Find a Select J8 . A B F G H H 1 2 3 4 5 5 6 Field Number D E Washington State Department of Health Center for Health Statistics Public Use Data Set File Layout Comprehensive Hospital Abstract Reporting System (CHARS), 2010 - current Variable Type Length Label 7 1 SEO NO Char 10 Sequence Number 8 2 STAYTYPE Char Type of Stay 9 3 ZIPCODE3 Char 3 Zip Code - first 3 digits Comment Unique sequence number assigned to each record within a year. First four digits are the year of discharge I = Inpatient 2 = Observation patient First three digits of Washington zipcode (zips 98001 - 99403) 000 indicates the zip code is unknown. 111 indicntes an out-of-state (non-WA) zipcode 999 indientes bomelessness (some bomeless poticots my bave o zip code for a shclter or other tempomaty Location). Blanks indicate non-U.S. residence. 1 - Age 0-17 2- Age 18-64 3 = Age 65- F-Female M-Male U=Unknown 0-Weekday 1 = Weekend Year of discharge Computed as discharge date minus admission date minus leave of absence days. Categorized as: 0-1 - Exact of days 10 4 AGEGROUP INum & Age groun 11 S SEX Char 1Sex 12 13 AWEEKEND EKEND Num DIS YR Num 3 Weekend Admission Flag & Year of discharge 7 variables + ... AutoSave or ARSU CHARSPublicuseDataSetFileLayout Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibr (Body) v 11 ~ AF A = Insert X ab Wrap Text General 47-O 44 U DX Delta WS Paste BU CA Ideas y Merge & Center Sersitivity Y Conditional Format Cell Formatting as Table Styles Sort & Filter Forma v Find a Select U J8 . A B C c D E F G H Computed as discharge dale minus admission date minus leave of absence days. Categorized as: 0-7-Exact of days 14-8-14 days 30-15-30 dnys 99-30 or more days 14 8 LOS Num & Length of Stay, categorized 1 -Emergency 2 -Urgent 3-Elective 4-Newbom 5 = Trauma 9 Information not available 15 9 ADM TYPE Char 1 Type of Admission 1 = Physician refcual 2 Clipic rcferral 3-HMO referral (discontinued 10:01/2007) 4 - Transfer from hospital s-Transfer from skilled nursing scility 6 - Transfer from another Health Care Facility 7 - Emergency room (Discontinued by NUBC 6/30/2010) 8-Cour/law enforcement 19 = Admission Info not avnilnble A =Transfer from critical access hospital (discontinued 10/01/2007) D-Transfer from one distinct unit of the hospital to another distinct unit of the saine hospital E-Transfer liom an Ambulatory Surgery Center (beginning 10/01:2007) F-Transfer fram hepice (heginning 11/11/2007) When the type of aclmission is "4 - Newbom", the following is used for Source of Admission: 1 - Normal delivery (discontinued 1001:2007) variables + ... AutoSave or ARSU CHARSPublicuseDataSetFileLayout Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibr (Body) v 11 ~ AF A = X be Insert ab Wrap Text General 28-0 4 DX Delta Paste B 2 1 y CA Merge & Center Ideas Sensitivity Y Conditional Format Cell Formatting as Table Styles Forma v Sort & Filter Find a Select J8 . x B B C D E G H 1 A - Transfer from critical acccss hospital (discontinued 10.01.2007) D-Transfer liom one distinct unit of the hospital to another distinct unit of the same hospital E-Transfer from an Ambulatory Surgery Center (beginning 10/01/2007) F - Transfer from hospice (beginning 10.01:2007) When the type of admission is "4 - Newbom", the following is used for Source of Admission: 1 = Normal delivery (discontinued 10/01/2007) 2 = Premature delivery (discontinued 10/01/2007) 3 - Sick baby (discontinued 10:01/2007) 4 - Extramural bath (discontinued 10:01/2007) s - Born inside hospital (beginning 10/11/2007; Multiple birih 1988-1994) 6 - Ilom outside this hospital (beginning 10/01/2007) 19 - Admission into not available 16 10 ADM SRC Char 1 Source of Admission OL = Routine discharge 02 = Dsch/Tufto another short-term general hospital for inpatient care 03-Dsch Tufte skilled nursing facility w Medicare 04-DschTrito an intermediate care facility 05 - Dsch Tranfto designated cancer center or children's hospital, ellective 04/01:2008; previously was Dsch:"Tmfto another type 06 - Dsch:Trm to home under the case of an health service organization 07 - Lett gainst medical ndvice 08 = Dsch/Tofhome under core of Home IV provider (discontiued 03:01:2007) 09 = Admitted as no lopaticut to this hospital 20 - Expired 21 - Discharged transferred to Court:'Law Enforcement (Effective 10-1-09) 30-Still a patient 43 - Dsch/Trito federal health care facility 50-espice hume 51 - Hospice-medical facility providing hospice level of care variables + ... AutoSave or ARSU CHARSPublicuseDataSetFileLayout Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibr (Body) v 11 ~ AF A = Insert ab Wrap Text General U W 28-0 4 Paste BU CA y +- Ideas DX Delta Format v Merge & Center Conditional Format Cell Formatting as Table Styles Sensitivity Y Sort & Filter Find a Select J8 . D E F G H 1 17 II STATUS char 2 Discharge Status 18 12 CHARGESI Num & Charger, rounded to nearest $1000 51 - Hospice - medical facility providing bospice level of core 61 = Dsch Tufwithin bospital to a hospital based Medicare approved swing bed 62 = Dsch/Tufto an inpaticat rchabilitation facility including rehabilitation distinct parts of a hospital 63-Dschim to another long let care facility . 64 - Dsch'Imfto nursing facility certified under Medicaid but not certified under Medicare 65 - Dsch:Tmfto psychiatric hospital or psychiatric distinct part unit of a hospital 66 - Dsch: Tmfto eritient access hospital 70 = Dsch/Tufto noother Type Healthcare not defined elsewhere in this list The total charges for the discharge record, rounded to nentest 51000, If> $1,000,000 in charges, CHARGESI = 9999999 The primary payer responsible for the bill. Categories are: 001 = Medicare 002 = Medicaid 004 = Health Maintenance Organization (HMO) 006 - Commercial insurance 008 - Labor & Industries 009-Sell pay 610 - Health Care Service Contractor 625 - Other government sponsored patients 630 - Charity care 999 = Infomotion not reported or not available First three digits of Principul diagnosis code used. V'ifadingnosis code is only listed once in a particular combination of ZIPCODE3/AGEGROUP/SEX 19 13 PAYERI Char 3 Primary Payer 20 14 DIAG Char 7 Principal Diagnosis Blank ifanly a diagnosis cadeis only listed once at a particular hospital This is only present for selected ICD-9 codes. Categories include: Y-Yes N=No variables + ... AutoSave or ARSU CHARSPublicuseDataSetFileLayout Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibr (Body) v 11 ~ AF A = X Insert ab Wrap Text General U 44 28-0 W D Delata v Paste B 1 Uy y CA -- +- Merge & Center % Ideas Sensitivity Y Conditional Format Cell Formatting as Table Styles Format v Sort & Filter Find a Select J8 . x A B C. D E F G H H J Y - Yes IN-No IU= No information for the record W = Clinically undetermined 1-Except for POA reporting blank - col reported Available for some reconds beginning in 2017. Difa diagnosis code is only listed once in a particular combination of ZIPCODE3IAGEGROUP SEX First two digils of Principal ICD-9 procedure code used. D'it'a procedure code is only listed once in a particular combination of ZIPCODE/AGEGROUP SEX E+First threedigits of Principal Ecode V'if'an Ecode is only listed once in a particular combination of ZUROCODES/ACIE GROUP SEX 21 15 POA Char 1 Present on Admission for Principal Diagnosis 22 16 PROC Chur 7 Principal Procedure 23 17 ECODE than 7 Principal E Code Blank if an Beode is only listed once at a particular hospital This is only present for selected ICD-9 eodes. Categories include: Y - Yes N-No U-No information for the record W-Clinically undetermined 1 = Excmpe for POA reporting blank Ebot reported Available for some records beginning in 2007. Dif an Ecode is only listed once in a particular combination of 21 CODE3/ACIEGROUPSEX The DR Code assigned based on the grouperin ellect al the date of discharge. The MDC code assigned based on the groupier in effect at the date of discharge. 18 19 POAE DRG 24 25 26 27 28 Char Char Char 1 Present on Admission for Principal E Code 3 2 MDC 20 MIX variables + ... AutoSave or CHARSPublicuseDataSetFileLayout ABU Page Layout Formulas Home Insert Draw Data Review View Tell me Share Comments X Calibr (Body) v 11 ~ AF A = a ab Wrap Text General Insert 28-0 44 D Dalata v WS Paste BU CA y Ideas Merge & Center % Y Sensitivity Conditional Format Cell Formatting as Table Styles Forma v Sort & Filter Find a Select J8 . A B F G H H 1 2 3 4 5 5 6 Field Number D E Washington State Department of Health Center for Health Statistics Public Use Data Set File Layout Comprehensive Hospital Abstract Reporting System (CHARS), 2010 - current Variable Type Length Label 7 1 SEO NO Char 10 Sequence Number 8 2 STAYTYPE Char Type of Stay 9 3 ZIPCODE3 Char 3 Zip Code - first 3 digits Comment Unique sequence number assigned to each record within a year. First four digits are the year of discharge I = Inpatient 2 = Observation patient First three digits of Washington zipcode (zips 98001 - 99403) 000 indicates the zip code is unknown. 111 indicntes an out-of-state (non-WA) zipcode 999 indientes bomelessness (some bomeless poticots my bave o zip code for a shclter or other tempomaty Location). Blanks indicate non-U.S. residence. 1 - Age 0-17 2- Age 18-64 3 = Age 65- F-Female M-Male U=Unknown 0-Weekday 1 = Weekend Year of discharge Computed as discharge date minus admission date minus leave of absence days. Categorized as: 0-1 - Exact of days 10 4 AGEGROUP INum & Age groun 11 S SEX Char 1Sex 12 13 AWEEKEND EKEND Num DIS YR Num 3 Weekend Admission Flag & Year of discharge 7 variables + ... AutoSave or ARSU CHARSPublicuseDataSetFileLayout Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibr (Body) v 11 ~ AF A = Insert X ab Wrap Text General 47-O 44 U DX Delta WS Paste BU CA Ideas y Merge & Center Sersitivity Y Conditional Format Cell Formatting as Table Styles Sort & Filter Forma v Find a Select U J8 . A B C c D E F G H Computed as discharge dale minus admission date minus leave of absence days. Categorized as: 0-7-Exact of days 14-8-14 days 30-15-30 dnys 99-30 or more days 14 8 LOS Num & Length of Stay, categorized 1 -Emergency 2 -Urgent 3-Elective 4-Newbom 5 = Trauma 9 Information not available 15 9 ADM TYPE Char 1 Type of Admission 1 = Physician refcual 2 Clipic rcferral 3-HMO referral (discontinued 10:01/2007) 4 - Transfer from hospital s-Transfer from skilled nursing scility 6 - Transfer from another Health Care Facility 7 - Emergency room (Discontinued by NUBC 6/30/2010) 8-Cour/law enforcement 19 = Admission Info not avnilnble A =Transfer from critical access hospital (discontinued 10/01/2007) D-Transfer from one distinct unit of the hospital to another distinct unit of the saine hospital E-Transfer liom an Ambulatory Surgery Center (beginning 10/01:2007) F-Transfer fram hepice (heginning 11/11/2007) When the type of aclmission is "4 - Newbom", the following is used for Source of Admission: 1 - Normal delivery (discontinued 1001:2007) variables + ... AutoSave or ARSU CHARSPublicuseDataSetFileLayout Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibr (Body) v 11 ~ AF A = X be Insert ab Wrap Text General 28-0 4 DX Delta Paste B 2 1 y CA Merge & Center Ideas Sensitivity Y Conditional Format Cell Formatting as Table Styles Forma v Sort & Filter Find a Select J8 . x B B C D E G H 1 A - Transfer from critical acccss hospital (discontinued 10.01.2007) D-Transfer liom one distinct unit of the hospital to another distinct unit of the same hospital E-Transfer from an Ambulatory Surgery Center (beginning 10/01/2007) F - Transfer from hospice (beginning 10.01:2007) When the type of admission is "4 - Newbom", the following is used for Source of Admission: 1 = Normal delivery (discontinued 10/01/2007) 2 = Premature delivery (discontinued 10/01/2007) 3 - Sick baby (discontinued 10:01/2007) 4 - Extramural bath (discontinued 10:01/2007) s - Born inside hospital (beginning 10/11/2007; Multiple birih 1988-1994) 6 - Ilom outside this hospital (beginning 10/01/2007) 19 - Admission into not available 16 10 ADM SRC Char 1 Source of Admission OL = Routine discharge 02 = Dsch/Tufto another short-term general hospital for inpatient care 03-Dsch Tufte skilled nursing facility w Medicare 04-DschTrito an intermediate care facility 05 - Dsch Tranfto designated cancer center or children's hospital, ellective 04/01:2008; previously was Dsch:"Tmfto another type 06 - Dsch:Trm to home under the case of an health service organization 07 - Lett gainst medical ndvice 08 = Dsch/Tofhome under core of Home IV provider (discontiued 03:01:2007) 09 = Admitted as no lopaticut to this hospital 20 - Expired 21 - Discharged transferred to Court:'Law Enforcement (Effective 10-1-09) 30-Still a patient 43 - Dsch/Trito federal health care facility 50-espice hume 51 - Hospice-medical facility providing hospice level of care variables + ... AutoSave or ARSU CHARSPublicuseDataSetFileLayout Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibr (Body) v 11 ~ AF A = Insert ab Wrap Text General U W 28-0 4 Paste BU CA y +- Ideas DX Delta Format v Merge & Center Conditional Format Cell Formatting as Table Styles Sensitivity Y Sort & Filter Find a Select J8 . D E F G H 1 17 II STATUS char 2 Discharge Status 18 12 CHARGESI Num & Charger, rounded to nearest $1000 51 - Hospice - medical facility providing bospice level of core 61 = Dsch Tufwithin bospital to a hospital based Medicare approved swing bed 62 = Dsch/Tufto an inpaticat rchabilitation facility including rehabilitation distinct parts of a hospital 63-Dschim to another long let care facility . 64 - Dsch'Imfto nursing facility certified under Medicaid but not certified under Medicare 65 - Dsch:Tmfto psychiatric hospital or psychiatric distinct part unit of a hospital 66 - Dsch: Tmfto eritient access hospital 70 = Dsch/Tufto noother Type Healthcare not defined elsewhere in this list The total charges for the discharge record, rounded to nentest 51000, If> $1,000,000 in charges, CHARGESI = 9999999 The primary payer responsible for the bill. Categories are: 001 = Medicare 002 = Medicaid 004 = Health Maintenance Organization (HMO) 006 - Commercial insurance 008 - Labor & Industries 009-Sell pay 610 - Health Care Service Contractor 625 - Other government sponsored patients 630 - Charity care 999 = Infomotion not reported or not available First three digits of Principul diagnosis code used. V'ifadingnosis code is only listed once in a particular combination of ZIPCODE3/AGEGROUP/SEX 19 13 PAYERI Char 3 Primary Payer 20 14 DIAG Char 7 Principal Diagnosis Blank ifanly a diagnosis cadeis only listed once at a particular hospital This is only present for selected ICD-9 codes. Categories include: Y-Yes N=No variables + ... AutoSave or ARSU CHARSPublicuseDataSetFileLayout Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibr (Body) v 11 ~ AF A = X Insert ab Wrap Text General U 44 28-0 W D Delata v Paste B 1 Uy y CA -- +- Merge & Center % Ideas Sensitivity Y Conditional Format Cell Formatting as Table Styles Format v Sort & Filter Find a Select J8 . x A B C. D E F G H H J Y - Yes IN-No IU= No information for the record W = Clinically undetermined 1-Except for POA reporting blank - col reported Available for some reconds beginning in 2017. Difa diagnosis code is only listed once in a particular combination of ZIPCODE3IAGEGROUP SEX First two digils of Principal ICD-9 procedure code used. D'it'a procedure code is only listed once in a particular combination of ZIPCODE/AGEGROUP SEX E+First threedigits of Principal Ecode V'if'an Ecode is only listed once in a particular combination of ZUROCODES/ACIE GROUP SEX 21 15 POA Char 1 Present on Admission for Principal Diagnosis 22 16 PROC Chur 7 Principal Procedure 23 17 ECODE than 7 Principal E Code Blank if an Beode is only listed once at a particular hospital This is only present for selected ICD-9 eodes. Categories include: Y - Yes N-No U-No information for the record W-Clinically undetermined 1 = Excmpe for POA reporting blank Ebot reported Available for some records beginning in 2007. Dif an Ecode is only listed once in a particular combination of 21 CODE3/ACIEGROUPSEX The DR Code assigned based on the grouperin ellect al the date of discharge. The MDC code assigned based on the groupier in effect at the date of discharge. 18 19 POAE DRG 24 25 26 27 28 Char Char Char 1 Present on Admission for Principal E Code 3 2 MDC 20 MIX variables +