Help with my statistics homework

No.12953568 ViewReplyOriginalReport
Hello, I'm in a finance program and one of the first year is introductory statistics. I'm an upper year student who dicked around in my early years and failed this class, now its one of the last ones I need to graduate. I've done most of the upper year finance courses yet for some reason, I'm extremely retarded when it comes to statistics. I was hoping someone can give me some direction on this question. We basically have a huge data table of a sample of car accidents, and 1 of the columns is 'Severity' (1 = fatal, 2 = non-fatal), another column is age, where it shows each persons age. I used the count function on excel to determine that there's 593 1's (aka 593 fatal accidents), and seven 2's.

I'm thinking I have to treat the fatal and the non-fatal as 2 separate populations and do a hypothesis test, where the null hypothesis is H0: u1<u2, and H1: u1>u2, where u1 represents the fatal population. So I sorted the sample by severity, and used the average function to find the sample mean of both populations, and the Stdev.S function to find the sample standard deviation. I'm now planning on using these values as well as n1 = 593, n2 = 7 to find the test statistic. Am I on the right track here?