View Single Post
  #2  
Old 08-21-2007, 10:54 PM
AaronBrown AaronBrown is offline
Senior Member
 
Join Date: May 2005
Location: New York
Posts: 2,260
Default Re: How to do simple Trend Analysis?

I don't see a trend, I see two numbers essentially the same, then one jump up. But maybe you see it in the donor-by-donor numbers.

My first advice is that a trend analysis is not appropriate here, because organs per donor is not the key performance indicator. You could inflate it by rejecting any donor for whom you will get three or fewer organs, or by harvesting substandard organs or by murdering healthy people at convenient times.

It's more important to understand the reason for the increase because (a) then you can consolidate and even increase your gains and (b) you know that it is a real improvement and not a statistical artifact. Are you getting healthier donors? Are you processing more efficiently? Are you getting more demand for transplants? You should be able to investigate these things, both from the numbers and other information. This is valuable work.

To do a straight trend analysis, you would first decide whether the data suggest a steady increase or a sudden change with the new DHS.

I assume your data are in Excel with dates in column A and number of organs harvested in B (you might have two or more rows with the same date, if you had more than one donor on that date). Say you have 500 rows, then you select a 2 coumn x 5 row array of cells somewhere and type:

=LINEST(B1:B500,A1:A500,TRUE,TRUE)

Then hit CTRL-SHIFT-ENTER (all three keys at once). The Excel help or your statistics book will explain what the output means.

If you instead want to compare the performance before and after a certain date, you want to do a t-test. Your statistics book will tell you how to do with with the Excel data, it's easier than the regression.

I warn you again, this is not the right way to analyze the data, and, in any case, these techniques can be misleading without some training.
Reply With Quote