Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Nov 2001
    Location
    Dallas, TX
    Posts
    50
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cum Frequency scale (2000-SR1)

    I'm looking for an Excel add-in that will allow me to change the X axis for a cummulative frequency plot. The axis I need ranges from .01 to 99.99 with the median point (50%) in the middle of the axis. It looks a little like a log scale but it's not. It allows you to plot a normal (or log-normal) distribution as a straight line. Percentiles can then be read directly from the plot. I don't mind buying it (shareware or full retail) but I would think that since it's only a new scale there may be a free-ware add-in out there.

    Thanks for any help the board can provide

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Cum Frequency scale (2000-SR1)

    Can't find an addin, but I think that messages 4 & 5 in this thread on Microsoft.public.excel.charting gives the technique to use. HTH --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    Star Lounger
    Join Date
    Nov 2001
    Location
    Dallas, TX
    Posts
    50
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cum Frequency scale (2000-SR1)

    Sam,

    Thank you for the help. It should work as a short-term solution. As a more permanent solution, I would still be interested if anyone knows of an add-in that allows the probability scale to be printed on the chart.

    Wayne

  4. #4
    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: Cum Frequency scale (2000-SR1)

    Look at this example. I think the 4th chart might be like what you are after (or the techniques can be used to get what you want)
    It has 4 charts
    1) Freq Bar Chart
    2) Lower Boundary vs Cum Freq
    3) Lower Boundary vs "transfromed data" (gives a line)
    4) Lower Boundary vs "transfromed data" but does some "tricks":
    a) transformed x is not displayed
    [img]/forums/images/smilies/cool.gif[/img] Add a range with datalabels to "look like" a x-range of Prob data
    c) adds "lines' representing grid-lines for the Prob data

    Steve
    Attached Files Attached Files

Posting Permissions

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