First Name	Last Name	Discharge Diagnosis	Readmitted within 30 days
Darren	Dove	Gangrene	Not readmitted <30 days
Anthony	Lowe	Gangrene	Not readmitted <30 days
Arthur	Nuna	Gangrene	Not readmitted <30 days
Cameron	Lynch	Gangrene	Not readmitted <30 days
Johnathan	Lyons	Gangrene	Not readmitted <30 days
Seth	Baldonado	Gangrene	Not readmitted <30 days
Pat	Mann	Gangrene	Not readmitted <30 days
Floyd	Maxwell	Gangrene	Not readmitted <30 days
Winifred	Mcbride	Gangrene	Not readmitted <30 days
Cedric	Anderson	Gangrene	Not readmitted <30 days
Georgia	Mccoy	Gangrene	Not readmitted <30 days
Ismael	Mendoza	Gangrene	Not readmitted <30 days
Crystal	Stiles	Gangrene	Not readmitted <30 days
Juanita	Miller	Gangrene	Not readmitted <30 days
Sue	Osborne	Gangrene	Not readmitted <30 days
Morris	Darsons	Gangrene	Not readmitted <30 days
Florence	Patrick	Gangrene	Not readmitted <30 days
Steve	Paul	Gangrene	Not readmitted <30 days
Joyce	Perez	Gangrene	Not readmitted <30 days
Oscar	Powell	Gangrene	Not readmitted <30 days
Holly	Dice	Gangrene	Not readmitted <30 days
Mike	Ramsey	Gangrene	Not readmitted <30 days
Josh	Day	Gangrene	Not readmitted <30 days
Lora	Reese	Gangrene	Not readmitted <30 days
Duane	Reeves	Gangrene	Not readmitted <30 days
Chris	Reynolds	Gangrene	Not readmitted <30 days
Dean	Rice	Gangrene	Not readmitted <30 days
Ramon	Rice	Gangrene	Not readmitted <30 days
Meghan	Mitchell	Gangrene	Readmitted <30 days
Kay	Gorgan	Gangrene	Readmitted <30 days
Tyrone	Morris	Gangrene	Readmitted <30 days
Lauren	Morrison	Gangrene	Readmitted <30 days
Spencer	Morton	Gangrene	Readmitted <30 days
Darrin	Moss	Gangrene	Readmitted <30 days
Milton	Nunoz	Gangrene	Readmitted <30 days
Ella	Nash	Gangrene	Readmitted <30 days
Victoria	Stewman	Gangrene	Readmitted <30 days
Cassandra	Norton	Gangrene	Readmitted <30 days
Heidi	Oliver	Gangrene	Readmitted <30 days
Thelma	Alvarado	All other admissions	Not readmitted <30 days
Janis	Horton	All other admissions	Not readmitted <30 days
Lila	Houston	All other admissions	Not readmitted <30 days
Muriel	Hubbard	All other admissions	Not readmitted <30 days
Andres	Ingram	All other admissions	Not readmitted <30 days
Marvin	Jensen	All other admissions	Not readmitted <30 days
Anna	Johnson	All other admissions	Not readmitted <30 days
James	Johnson	All other admissions	Not readmitted <30 days
Ernest	Keller	All other admissions	Not readmitted <30 days
Wendell	Bennett	All other admissions	Not readmitted <30 days
Dallas	Bradley	All other admissions	Not readmitted <30 days
Ramon	Brewer	All other admissions	Not readmitted <30 days
Orlando	Bridges	All other admissions	Not readmitted <30 days
Marcos	Christensen	All other admissions	Not readmitted <30 days
Ernesto	Cortez	All other admissions	Not readmitted <30 days
Lindsey	Craig	All other admissions	Not readmitted <30 days
Esteban	Cramer-Martin	All other admissions	Not readmitted <30 days
Deborah	Fuller	All other admissions	Not readmitted <30 days
Carroll	Hanson	All other admissions	Not readmitted <30 days
Melanie	Harmon	All other admissions	Not readmitted <30 days
Candace	Howard	All other admissions	Not readmitted <30 days
Damon	Lewis	All other admissions	Not readmitted <30 days
Sonya	Ortiz	All other admissions	Not readmitted <30 days
Darla	Powers	All other admissions	Not readmitted <30 days
Harvey	Riley	All other admissions	Not readmitted <30 days
Bill	Robbins	All other admissions	Not readmitted <30 days
Emmett	Sandoval	All other admissions	Not readmitted <30 days
Lynn	Sharp	All other admissions	Not readmitted <30 days
Terry	Sullivan	All other admissions	Not readmitted <30 days
Julio	Torres	All other admissions	Not readmitted <30 days
James	Turner	All other admissions	Not readmitted <30 days
Raymond	Walsh	All other admissions	Not readmitted <30 days
Stephen	Willis	All other admissions	Not readmitted <30 days
Jack	Woods	All other admissions	Not readmitted <30 days
Richard	Andrews	All other admissions	Not readmitted <30 days
Raymond	Arnold	All other admissions	Not readmitted <30 days
Cecil	Ballard	All other admissions	Not readmitted <30 days
Kristin	Barber	All other admissions	Not readmitted <30 days
Molly	Cook	All other admissions	Not readmitted <30 days
Martha	Dennis	All other admissions	Not readmitted <30 days
Hector	Fields	All other admissions	Not readmitted <30 days
Jeanette	Fleming	All other admissions	Not readmitted <30 days
Helen	Garrett	All other admissions	Not readmitted <30 days
Betty	Garza	All other admissions	Not readmitted <30 days
Clark	Goodwin	All other admissions	Not readmitted <30 days
Lionel	Greene	All other admissions	Not readmitted <30 days
Scott	Hampton	All other admissions	Not readmitted <30 days
Estelle	Harmon	All other admissions	Not readmitted <30 days
Sandra	Harrington	All other admissions	Not readmitted <30 days
Freda	Conner	All other admissions	Not readmitted <30 days
Carlton	Cook	All other admissions	Not readmitted <30 days
Carlos	Cross	All other admissions	Not readmitted <30 days
Shari	Cruz	All other admissions	Not readmitted <30 days
Sergio	Cummings	All other admissions	Not readmitted <30 days
Ebony	Curry	All other admissions	Not readmitted <30 days
Anne	Curtis	All other admissions	Not readmitted <30 days
Martha	Daniel	All other admissions	Not readmitted <30 days
Brooke	Davidson	All other admissions	Not readmitted <30 days
Tina	Davis	All other admissions	Not readmitted <30 days
Carole	Dawson	All other admissions	Not readmitted <30 days
Cornelius	Delgado	All other admissions	Not readmitted <30 days
Mindy	Diaz	All other admissions	Not readmitted <30 days
Violet	Drake	All other admissions	Not readmitted <30 days
Ora	Duncan	All other admissions	Not readmitted <30 days
Ronnie	Duncan	All other admissions	Not readmitted <30 days
Mark	Elliott	All other admissions	Not readmitted <30 days
Antonia	Fisher	All other admissions	Not readmitted <30 days
Rosemarie	Fletcher	All other admissions	Not readmitted <30 days
Jason	Flowers	All other admissions	Not readmitted <30 days
Shawn	Floyd	All other admissions	Not readmitted <30 days
Merle	Fowler	All other admissions	Not readmitted <30 days
Gwen	Franklin	All other admissions	Not readmitted <30 days
Tracey	Fuller	All other admissions	Not readmitted <30 days
Louise	Garner	All other admissions	Not readmitted <30 days
Wanda	Glover	All other admissions	Not readmitted <30 days
Santos	Cass	All other admissions	Not readmitted <30 days
Rex	Bates	All other admissions	Not readmitted <30 days
William	Petrov	All other admissions	Not readmitted <30 days
Karen	Brown	All other admissions	Not readmitted <30 days
Troy	Buchanan	All other admissions	Not readmitted <30 days
Brooke	Burke	All other admissions	Not readmitted <30 days
Billie	Butler	All other admissions	Not readmitted <30 days
Jean	Linnley	All other admissions	Not readmitted <30 days
Everett	Casey	All other admissions	Not readmitted <30 days
Lindsey	Castillo	All other admissions	Not readmitted <30 days
Candice	Chambers	All other admissions	Not readmitted <30 days
Janice	Gonzales	All other admissions	Not readmitted <30 days
Kristopher	Smoot	All other admissions	Not readmitted <30 days
Amelia	Grant	All other admissions	Not readmitted <30 days
Madeline	Graves	All other admissions	Not readmitted <30 days
Nora	Gray	All other admissions	Not readmitted <30 days
Karen	Hampton	All other admissions	Not readmitted <30 days
Jan	Hardy	All other admissions	Not readmitted <30 days
Ernestine	Harmon	All other admissions	Not readmitted <30 days
Lula	Harmon	All other admissions	Not readmitted <30 days
Sharon	Harrington	All other admissions	Not readmitted <30 days
Beverly	Hart	All other admissions	Not readmitted <30 days
Alice	Hayes	All other admissions	Not readmitted <30 days
Susie	Henderson	All other admissions	Not readmitted <30 days
Sammy	Hernandez	All other admissions	Not readmitted <30 days
Jo	Hogan	All other admissions	Not readmitted <30 days
Daniel	Holmes	All other admissions	Not readmitted <30 days
Willie	Keller	All other admissions	Not readmitted <30 days
Judith	Kennedy	All other admissions	Not readmitted <30 days
Muriel	Knight	All other admissions	Readmitted <30 days
Johnny	Lambert	All other admissions	Readmitted <30 days
Jeremy	Lane	All other admissions	Readmitted <30 days
Jamie	Lee	All other admissions	Readmitted <30 days
Laverne	Lewis	All other admissions	Readmitted <30 days
Owen	Lindsey	All other admissions	Readmitted <30 days
Ron	Lindsey	All other admissions	Readmitted <30 days
Ken	Lopez	All other admissions	Readmitted <30 days
Orville	Roberson	Congestive Heart Failure	Not readmitted <30 days
Deanna	Roberts	Congestive Heart Failure	Not readmitted <30 days
Susie	Robinson	Congestive Heart Failure	Not readmitted <30 days
Elsie	Santos	Congestive Heart Failure	Not readmitted <30 days
Lynda	Santos	Congestive Heart Failure	Not readmitted <30 days
Shari	Saunders	Congestive Heart Failure	Not readmitted <30 days
Connie	Sharp	Congestive Heart Failure	Not readmitted <30 days
Salvatore	Shaw	Congestive Heart Failure	Not readmitted <30 days
Melba	Simmons	Congestive Heart Failure	Not readmitted <30 days
Tabitha	Simmons	Congestive Heart Failure	Not readmitted <30 days
Tiffany	Sims	Congestive Heart Failure	Not readmitted <30 days
Justin	Sparks	Congestive Heart Failure	Not readmitted <30 days
Arnold	Stanley	Congestive Heart Failure	Not readmitted <30 days
Devin	Strickland	Congestive Heart Failure	Not readmitted <30 days
Martin	Sullivan	Congestive Heart Failure	Not readmitted <30 days
Emanuel	Tate	Congestive Heart Failure	Not readmitted <30 days
Hubert	Todd	Congestive Heart Failure	Not readmitted <30 days
Geneva	Torres	Congestive Heart Failure	Not readmitted <30 days
Brenda	Tucker	Congestive Heart Failure	Not readmitted <30 days
Sean	Underwood	Congestive Heart Failure	Not readmitted <30 days
Jamie	Valdez	Congestive Heart Failure	Not readmitted <30 days
Herman	Vega	Congestive Heart Failure	Not readmitted <30 days
Juan	Wagner	Congestive Heart Failure	Not readmitted <30 days
Bill	Walker	Congestive Heart Failure	Not readmitted <30 days
Brandon	Ward	Congestive Heart Failure	Not readmitted <30 days
Tracey	Warner	Congestive Heart Failure	Not readmitted <30 days
Dana	Warren	Congestive Heart Failure	Not readmitted <30 days
Melinda	Watts	Congestive Heart Failure	Not readmitted <30 days
Travis	Welch	Congestive Heart Failure	Not readmitted <30 days
Alfonso	Wilkerson	Congestive Heart Failure	Not readmitted <30 days
Miriam	Williams	Congestive Heart Failure	Not readmitted <30 days
Ramona	Willis	Congestive Heart Failure	Not readmitted <30 days
Alice	Wilson	Congestive Heart Failure	Not readmitted <30 days
Lee	Wilson	Congestive Heart Failure	Not readmitted <30 days
Vicki	Wong	Congestive Heart Failure	Not readmitted <30 days
Greg	Wood	Congestive Heart Failure	Not readmitted <30 days
Andrew	Zimmerman	Congestive Heart Failure	Readmitted <30 days
Dominic	Washington	Congestive Heart Failure	Readmitted <30 days
Alexander	Waters	Congestive Heart Failure	Readmitted <30 days
Lula	Watson	Congestive Heart Failure	Readmitted <30 days
Roger	Watson	Congestive Heart Failure	Readmitted <30 days
Elsie	Hayes	Congestive Heart Failure	Readmitted <30 days
Edgar	Hicks	Congestive Heart Failure	Readmitted <30 days
Fred	Hodges	Congestive Heart Failure	Readmitted <30 days
Freddie	Houston	Congestive Heart Failure	Readmitted <30 days
Ben	Hughes	Congestive Heart Failure	Readmitted <30 days
Rosemarie	James	Congestive Heart Failure	Readmitted <30 days
Joshua	King	Congestive Heart Failure	Readmitted <30 days
Marguerite	Love	Congestive Heart Failure	Readmitted <30 days
Mona	Martinez	Congestive Heart Failure	Readmitted <30 days
Spencer	Martinez	Congestive Heart Failure	Readmitted <30 days
Orlando	Massey	Congestive Heart Failure	Readmitted <30 days
Kelly	Maxwell	Congestive Heart Failure	Readmitted <30 days
John	Mckenzie	Congestive Heart Failure	Readmitted <30 days
Perry	Meyer	Renal Failure	Not readmitted <30 days
Bobby	Norton	Renal Failure	Not readmitted <30 days
Chad	Obrien	Renal Failure	Not readmitted <30 days
Christian	Ortega	Renal Failure	Not readmitted <30 days
Darlene	Padilla	Renal Failure	Not readmitted <30 days
Kevin	Parker	Renal Failure	Not readmitted <30 days
Donna	Paul	Renal Failure	Not readmitted <30 days
Elena	Potter	Renal Failure	Not readmitted <30 days
Sarah	Ramsey	Renal Failure	Not readmitted <30 days
Joanne	Reyes	Renal Failure	Not readmitted <30 days
Lucas	Riley	Renal Failure	Not readmitted <30 days
Rudolph	Shelton	Renal Failure	Not readmitted <30 days
David	Spencer	Renal Failure	Not readmitted <30 days
Albert	Stanley	Renal Failure	Not readmitted <30 days
Dominick	Summers	Renal Failure	Not readmitted <30 days
Reginald	Thornton	Renal Failure	Not readmitted <30 days
Michele	Vaughn	Renal Failure	Not readmitted <30 days
Van	Walsh	Renal Failure	Not readmitted <30 days
Roosevelt	Watts	Renal Failure	Not readmitted <30 days
Van	Wong	Renal Failure	Not readmitted <30 days
Edna	Wright	Renal Failure	Not readmitted <30 days
Pamela	Abbott	Renal Failure	Not readmitted <30 days
Dan	Adkins	Renal Failure	Not readmitted <30 days
Alberto	Allen	Renal Failure	Not readmitted <30 days
Dana	Alvarez	Renal Failure	Not readmitted <30 days
George	Andrews	Renal Failure	Not readmitted <30 days
Clifford	Arnold	Renal Failure	Not readmitted <30 days
Shannon	Robertson	Renal Failure	Readmitted <30 days
Marty	Rogers	Renal Failure	Readmitted <30 days
Patsy	Romero	Renal Failure	Readmitted <30 days
Rodolfo	Ross	Renal Failure	Readmitted <30 days
Garrett	Roy	Renal Failure	Readmitted <30 days
Dale	Ruiz	Renal Failure	Readmitted <30 days
Julian	Scott	Renal Failure	Readmitted <30 days
Kristi	Baker	Sickle Cell Anemia	Not readmitted <30 days
Ricardo	Baldwin	Sickle Cell Anemia	Not readmitted <30 days
Cecil	Barker	Sickle Cell Anemia	Not readmitted <30 days
Israel	Barton	Sickle Cell Anemia	Not readmitted <30 days
Matt	Bass	Sickle Cell Anemia	Not readmitted <30 days
Oliver	Bowen	Sickle Cell Anemia	Not readmitted <30 days
Erin	Boyd	Sickle Cell Anemia	Not readmitted <30 days
Corey	Brewer	Sickle Cell Anemia	Not readmitted <30 days
Robin	Briggs	Sickle Cell Anemia	Not readmitted <30 days
Debra	Buchanan	Sickle Cell Anemia	Not readmitted <30 days
Lauren	Burns	Sickle Cell Anemia	Not readmitted <30 days
Jerome	Carlson	Sickle Cell Anemia	Not readmitted <30 days
Bertha	Carson	Sickle Cell Anemia	Not readmitted <30 days
Marcia	Carter	Sickle Cell Anemia	Not readmitted <30 days
Helen	Castillo	Sickle Cell Anemia	Not readmitted <30 days
Clara	Chambers	Sickle Cell Anemia	Not readmitted <30 days
Freda	Cole	Sickle Cell Anemia	Not readmitted <30 days
Grady	Becker	Sickle Cell Anemia	Readmitted <30 days
Cory	Benson	Sickle Cell Anemia	Readmitted <30 days
Sylvia	Bishop	Sickle Cell Anemia	Readmitted <30 days
Laurie	Blair	Sickle Cell Anemia	Readmitted <30 days
Henry	Blake	Sickle Cell Anemia	Readmitted <30 days

Pivot table instructions:

1. In the spreadsheet, select and highlight all the cells that include data.
2. Then select Insert>Pivot Table
3. Leave the default selections as they are (defaults are: "Select a table or range"/ 'Admission Data' and New Worksheet). Press OK.
4. On the right-hand side of the pivot table screen, click and drag the "Readmitted within 30 days" check box into the Columns box.
5. Then click and drag the "Discharge Diagnosis" check box into the Rows box.
6. Finally, click and drag the "Readmitted within 30 days" into the Values box.

Questions

Examine the resulting pivot table for the readmission report data from the last quarter's admissions to the General Hospital. Use the data presented in the pivot table to calculate rates of readmissions in order to answer the questions below. As a reminder, a readmission is defined as two or more hospital admissions within a 30-day window, for any reason. On the pivot table, "Readmitted <30 days" means readmitted within the one-month window of discharge. "Not readmitted <30 days" means not readmitted within the one-month window of discharge.Answer the following questions.

1. What was the overall rate of readmission for all diagnoses last quarter? Round to the nearest percent.
2. What is the rate of readmission for unnamed diagnoses or all other admissions? Round to the nearest percent.

List the rates of readmission for each diagnosis listed below. Round to the nearest percent:

1. Gangrene:
2. Congestive heart failure:
3. Renal Failure:
4. Sickle Cell Anemia:
5. What diagnosis has the highest rate of readmission?