Making Graphs
Since my last post, I have done a lot of work, but my main focus has been my presentation and poster. To improve my data set, I have made many visual representations, such as graphs, tables, and flowcharts, to explain my data and methodology. I sorted my data from my spreadsheet by year, and this was slightly tedious as I had to go back into my spreadsheet and find the year published for all the clinical trials and then add that to the spreadsheet. Once done, I had to sort all the clinical trials by year using specific filters. I am not experienced with Microsoft Excel, so it took a little work and googling information to figure out how to implement filters and make graphs using the filtered data instead of the unfiltered data. I made graphs for disparities, comparing census data to clinical trial data for race/ethnicity and gender. I also included graphs for the percentage of annual clinical trials that reported gender, race, and ethnicity. After finishing all this, I did some extra outside research to find examples of clinical trials with different scenarios highlighting racial and ethnic disparities. One of the main methods companies and the government have used to eliminate this negative view on clinical trial racism is to make clinical trial information transparent on a public website and mandatory in government-funded trials. This was put in place through the Revitalization Act of 1993. This was the starting point that revolutionized how we see clinical trials today as a representation of the whole.