Prev Previous Post   Next Post Next
  #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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I install Excel 2000 Analysis Tool Pak? jamo Excel Discussion (Misc queries) 3 April 4th 05 11:16 PM
How do I install Excel 2000 Analysis Tool Pak? jamo Excel Discussion (Misc queries) 1 April 4th 05 03:25 AM
How do I get Data Analysis Plus tool pack in tools menu Show up. . epsilon8 Setting up and Configuration of Excel 1 February 11th 05 04:13 AM


All times are GMT +1. The time now is 09:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"