Instead of having (50 rows of data signifying states) X [3 snapshots (At least, some years had up to 12 snapshots so this amount right here determines how high and low it could actually be)] X (12 years) which is at least 1800 rows of column we have found a better method of collecting data.
I finished with only needing to do [12 rows (which represents years) X [50 tabs (separate tabs for each state)] which amounted to 600 rows.
Basically went from 1800 rows minimum to exactly 600.
Streamlining
Hey Huy! Your project sounds extremely interesting. What factors are you considering in your fatality prevention (e.g. better hospital treatment, accident prevention, or other factors)?
ReplyDeleteWhat this data should show is that an increased amount of trauma centers should have an inverse relationship with fatalities. Now that's only a preventive measure of death after the accident has happened. The team has other people researching different aspects for this project and where I can see prevention happening from all this is through the lessening of distracted driving
DeleteHuy your project sounds like its moving along nicely, what do you expect your final outcome to look like? That is if you have any solid prediction at this point.
ReplyDeleteI'm expecting to see a strong correlation between increasing trauma centers to decreasing fatalities rates up to 2015. There has to be something that explains why fatalities are increasing which comes from previous research but I don't think this data collection process can answer that. It can however give us evidence we need to say "we have a problem"
Delete