308.2 Assignment 2 – Data Analyst Scenario
308.2 assignment 2 – data analyst scenario
Every state has differences based on the graphs created. There Medicare Advantage Participation Rate varies from each other. However, it might be challenging to read or compare some values in the graphs because of the single ruled lines used to create the graphs.
Differences between the States Based on the Graphs that is Created
CA Medicare Advantage Participation Rate: Almeda County has a 93,519 rate. Bakersfield has a 39,046 rate. Chico has a 1,270 rate. Fresno has 45,549 rates. Los Angeles has 624, 327 rates. Los Angeles has the highest rate, followed by Almeda County, then. Fresno then Bakersfield and finally Chico which has the lowest rate.
Al Medicare Advantage Participation Rate: Dothan has a 10,298 rate. Huntsville has a 16,223 rate. Mobile has a 45,747 rate. Montgomery has a 16,719 rate. Tuscaloosa has a 4,265 rate. Mobile has the uppermost rate, followed by Montgomery, then Huntsville, then Dothan and finally Tuscaloosa has the bottommost rate. It may not be easier to read or compare the values of Huntsville and Tuscaloosa.
GA Medicare Advantage Participation Rate: Albany has a 9,594 rate. Augusta has a 31,043 rate. Columbus has a 13,422 rate. Macon has a 34,249 rate. Savannah has a 35,372 rate. Savannah has the highest rate, followed by Macon, then Augusta, Columbus and Albany have the lowermost rate. It may not be easier to read or compare the values of Columbus and Albany.
LA Medicare Advantage Participation Rate: Baton Rouge has a 56,429 rate. Lafayette has a 9,815 rate. Metairie has a 39,552 rate. New Orleans has 47,764 rates. Slidell has a 12,896 rate. Baton Rouge has the highest rate, while Lafayette has the lowest rate.
Quiz 4
The percentages differ across each HRR because of gender and ethnic makeup differences across each HRR. The overall number of admissions can be similar by gender; however, variations can emerge among age groups.
Differences in Gender and Ethnic Makeup for Each HRR
CA Los Angeles HRR: In the HRR the females have a higher percentage of 0.57, and males have a rate of 0.43. Hispanic whites have a higher ethnic makeup percentage of 0.57, while African Americans have the lowest percentage of 0.07. Both. Los Angeles females and Hispanic white have the same rate of 0.57.
Al Mobile HRR: In the HRR, the males have a higher percentage of (0.56), while the females have a lower rate (0.44). Hispanic White has the highest ethnic makeup (0.82), while the African American, the unknown and the Hispanic have the lowest ethnic makeup
.
GA Atlanta HRR: In the HRR, the percentage of females (0.57) is higher than that of males (0.43). Hispanic White has the highest ethnic makeup of (0.7972) while the African American and the Hispanic have the lowest ethnic composition.
LA Metairie HRR: In the HRR the percentage of females is higher than that of males. Hispanic White has a higher ethnic makeup of 0.81, followed by African American, then Hispanic and finally the other unknown which has the smallest percentage.