Thread: analysis tool
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alex
 
Posts: n/a
Default analysis tool

I have a table with days, planned and actual production, and % of actual vs.
planned.
Day Planned Cs Actual Cs %
26-Feb-06 1667 2025.25 121.49%
30-Apr-06 1667 1838.25 110.27%
19-Feb-06 1667 1950 116.98%
16-Apr-06 1660 1657 99.82%
26-Mar-06 1696 1693.5 99.85%
29-Jan-06 1696 1691 99.71%

I need to find a correlation between a number of cases planned (or actually
produced) and the % (to be on target). Whether having some specific range of
planned cases it's difficult to be on target and having another range or
number of cases it's easier to be on target.
What analysis tool do I need to use for this case and how I would need to
presenty the data?
Thanks.