Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I install Excel 2000 Analysis Tool Pak? | Excel Discussion (Misc queries) | |||
How do I install Excel 2000 Analysis Tool Pak? | Excel Discussion (Misc queries) | |||
How do I get Data Analysis Plus tool pack in tools menu Show up. . | Setting up and Configuration of Excel |