Analysis of ASHB, Male, and Female Percentages with Yearly Visualization

Sep 18, 2024, 6:51 PM

cohort progression vizly.xlsx

Missing file

this table shows percentages of completion per Year in categories. How does the percentage of ASHB compares to demographic categories Male Female overall and per year? Please consider the N for each ASHB N Male N Female N

To compare the percentage of ASHB to the demographic categories Male and Female overall and per year, we will follow these steps:
  1. Calculate the overall percentage for ASHB, Male, and Female.
  2. Visualize the yearly percentages for ASHB, Male, and Female.
  3. Consider the N values for each category to understand the sample sizes.
Let's start by calculating the overall percentages.
The overall percentages are as follows:
  • ASHB: 27.43%
  • Male: 24.36%
  • Female: 26.80%
Next, let's visualize the yearly percentages for ASHB, Male, and Female.

is there any significant difference between Male and Female

The t-test results are as follows:
  • t-statistic: -0.32
  • p-value: 0.76
Given that the p-value is significantly higher than 0.05, we fail to reject the null hypothesis. This means there is no significant difference between the percentages of Male and Female completion rates.
Would you like to explore any other aspects of this data?

please repeat the same analysis comparing ASHB and ethnicity categories such as White Hispanic Native Hawaiian/Pacific Island Asian Black or African American Two or more races Consider also the N values.

To compare the percentage of ASHB to the ethnicity categories (White, Hispanic, Native Hawaiian/Pacific Island, Asian, Black or African American, Two or more races) overall and per year, we will follow these steps:
  1. Calculate the overall percentage for each ethnicity category considering the N values.
  2. Visualize the yearly percentages for ASHB and each ethnicity category.
  3. Perform statistical tests to determine if there are significant differences between ASHB and each ethnicity category.
Let's start by calculating the overall percentages.
The overall percentages are as follows:
  • ASHB: 27.43%
  • White: 27.50%
  • Hispanic: 26.08%
  • Native Hawaiian/Pacific Island: 24.44%
  • Asian: 29.46%
  • Black or African American: 27.13%
  • Two or more races: 28.62%
Next, let's visualize the yearly percentages for ASHB and each ethnicity category.

Please disregard the 2021 datapoint for Native Hawaiian/Pacific Island

The graph above shows the yearly percentages of ASHB and various ethnicity categories, with the 2021 data point for Native Hawaiian/Pacific Island disregarded.
Next, let's perform statistical tests to determine if there are significant differences between ASHB and each ethnicity category.
The t-test results comparing ASHB to each ethnicity category are as follows:
  • White: t-statistic = -0.01, p-value = 0.99
  • Hispanic: t-statistic = 0.13, p-value = 0.90
  • Native Hawaiian/Pacific Island: t-statistic = 0.26, p-value = 0.80
  • Asian: t-statistic = -0.36, p-value = 0.73
  • Black or African American: t-statistic = 0.03, p-value = 0.98
  • Two or more races: t-statistic = -0.18, p-value = 0.86
Given that all p-values are significantly higher than 0.05, we fail to reject the null hypothesis for all comparisons. This means there is no significant difference between ASHB and any of the ethnicity categories.
Would you like to explore any other aspects of this data?

please compare ASHB with age categories Age 18-23 Age 24-29 Age 30-39 Age 40-55

To compare the percentage of ASHB to the age categories (Age 18-23, Age 24-29, Age 30-39, Age 40-55) overall and per year, we will follow these steps:
  1. Calculate the overall percentage for each age category considering the N values.
  2. Visualize the yearly percentages for ASHB and each age category.
  3. Perform statistical tests to determine if there are significant differences between ASHB and each age category.
Let's start by calculating the overall percentages.
The columns for the age categories are as follows:
  • Age 18-23
  • Age 24-29
  • Age 30-39
  • Age 40-55
Next, let's calculate the overall percentages for each age category considering the N values.
The overall percentages are as follows:
  • ASHB: 27.43%
  • Age 18-23: 21.95%
  • Age 24-29: 27.84%
  • Age 30-39: 28.02%
  • Age 40-55: 22.80%
Next, let's visualize the yearly percentages for ASHB and each age category.
The graph above shows the yearly percentages of ASHB and various age categories.
Next, let's perform statistical tests to determine if there are significant differences between ASHB and each age category.
The t-test results comparing ASHB to each age category are as follows:
  • Age 18-23: t-statistic = 1.53, p-value = 0.18
  • Age 24-29: t-statistic = -0.22, p-value = 0.83
  • Age 30-39: t-statistic = -1.34, p-value = 0.23
  • Age 40-55: t-statistic = -0.26, p-value = 0.80
Given that all p-values are significantly higher than 0.05, we fail to reject the null hypothesis for all comparisons. This means there is no significant difference between ASHB and any of the age categories.
Would you like to explore any other aspects of this data?

please compare now ASHB with Active Duty and Veteran

To compare the percentage of ASHB to Active Duty and Veteran overall and per year, we will follow these steps:
  1. Calculate the overall percentage for Active Duty and Veteran considering the N values.
  2. Visualize the yearly percentages for ASHB, Active Duty, and Veteran.
  3. Perform statistical tests to determine if there are significant differences between ASHB and Active Duty and Veteran.
Let's start by calculating the overall percentages.
The overall percentages are as follows:
  • ASHB: 27.43%
  • Active Duty: 24.66%
  • Veteran: 40.81%
Next, let's visualize the yearly percentages for ASHB, Active Duty, and Veteran.
The graph above shows the yearly percentages of ASHB, Active Duty, and Veteran.
Next, let's perform statistical tests to determine if there are significant differences between ASHB and Active Duty and Veteran.
The t-test results comparing ASHB to Active Duty and Veteran are as follows:
  • Active Duty: t-statistic = 0.27, p-value = 0.80
  • Veteran: t-statistic = -4.62, p-value = 0.004
Given that the p-value for Active Duty is significantly higher than 0.05, we fail to reject the null hypothesis for this comparison. This means there is no significant difference between ASHB and Active Duty.
However, the p-value for Veteran is less than 0.05, indicating a significant difference between ASHB and Veteran.
Would you like to explore any other aspects of this data?

please analysze which populations increase or decrease over the different Year

To analyze which populations increase or decrease over the different Year, we will follow these steps:
  1. Calculate the yearly change for each population category.
  2. Visualize the yearly changes to identify trends.
Let's start by calculating the yearly change for each population category.
The table above shows the yearly percentage changes for each population category. Positive values indicate an increase, while negative values indicate a decrease.
Next, let's visualize these yearly changes to identify trends more clearly.

Can you provide a summary of the trends observed?

Based on the visualization of yearly percentage changes for each population category, here are some observed trends:
  1. ASHB:
    • There is a general decreasing trend over the years.
    • The most significant decrease occurred in 2023.
  2. Asian:
    • The percentage change fluctuates, with a notable decrease in 2023.
  3. Black or African American:
    • There is a significant increase in 2022, followed by a sharp decrease in 2023.
  4. Hispanic:
    • The trend is inconsistent, with a notable decrease in 2021 and a significant increase in 2023.
  5. Native Hawaiian/Pacific Island:
    • The data shows extreme fluctuations, with some years having no representation.
  6. Age Groups (e.g., Age 40-55):
    • The trends for age groups vary, with some years showing significant increases and others showing decreases.
  7. Gender (Female, Male):
    • Both Female and Male categories show fluctuations, with some years having significant increases and others having decreases.
  8. Active Duty:
    • There is a general decreasing trend, with a significant drop in 2021.
  9. Veteran:
    • The trend is inconsistent, with some years showing increases and others showing decreases.
Overall, the trends indicate that most categories experience fluctuations in their yearly percentage changes, with some categories showing more consistent trends than others.
Would you like to explore any specific category in more detail or perform additional analysis?
Get started with Vizly