Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    CAlCULATION OF CUSUM (2000)

    I have accident data in a hospitals, there are about on average 10 work related (plus or minus 3) accidents per month in a the average large hospital. I need to compute the CUSUM every month for each hospital, that would generate an alarm if there is an larger than expected. I need a reference or a xl file with real data on how to do this in xl.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: CAlCULATION OF CUSUM (2000)

    A Google search for Excel Cusum should yield something useful. The first hit I got was http://www.stat.umn.edu/users/cusum/software.htm - various spreadsheets for download.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: CAlCULATION OF CUSUM (2000)

    I am not sure CUSUM is the best tool, I would think that an "attributes chart" dealing with ratios might be better (eg a proportions chart) or even a "count chart" to treat the accidents like "defects", but I have few details to give an "informed" decision.

    This site gives a spreadsheet example to make a CUSUM chart, though it doesn't give a lot of details on how to choose the "h" and "k" values, just some suggested ranges.

    Steve

  4. #4
    New Lounger
    Join Date
    Sep 2001
    Location
    Paignton, Devon, England
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: CAlCULATION OF CUSUM (2000)

    I agree that attribute charts are a more useful way to go. Have a look here for downloadable Excel tools: http://www.freequality.org/beta freequal/fq web site/tools.htm#chart. There is a cusum tool on this page as well. You could also Google 'Statistical Process Control' or SPC for more resources.

    Graeme

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •