Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Statistical chart (Excel 2003)

    I have a large list of assets with varying lives, and a cost for each asset. I want to show in a chart the distribution of lives so that I can determine the range where most of the cost is covered. Sort of the standard distribution idea, I think. I am looking for some guidance on how to do this: would a pivot table be best, or some other approach? I have so many rows of data that any chart would be too detailed to be useful. I suspect there is some function or formula directly in Excel that I am not familiar with that would quicly give me my answer. Thanks in advance for the advice!

  2. #2
    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: Statistical chart (Excel 2003)

    I am not entirely sure of what you have, but If i understand what you have, 3 columns:
    Asset name
    Life
    Cost

    One option would be to plot life vs Cost (or Cost vs Life, whichever is more appropriate) and to group them into quadrants (Hi Cost/Hi life, HiCost, lo Life, etc) or if many items , 9 sections (Hi, Med, Low for each). You could use the chart to setup the criteria you want to use then add a column calculating the criteria and then list /sort to display the assets for each "type".

    The chart and list could be used to decide which assets are more "worthwhile" (low cost, high life) and which are dogs (high cost, low life). It comes down to is the life of the object is worth the cost and the chart could give you some ideas of which groups need to be focused on as items to consider...

    Steve

Posting Permissions

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