making generic graph with specific characteristics help!

Discussion in 'Excel Programming' started by adolfo, May 19, 2004.

  1. adolfo

    adolfo Guest

    Im in a deep hole and i need help with excel.

    I want to create a generic graph on excell with no data. I dont have
    the data to plot, what this graph will show is just a represetnation
    of the data tha i want in order to obtain the wanted results. Ok so
    let me explain what i mean by all of this. I want to be able to create
    a graph by stating what standard deviation, mean, max, min etc i want
    the graph to have. For example, say i want a graph with a minimum of 3
    and a max of 70 with an average of 37, a standard deviation of 3 and a
    skew towards 18. I want to be able to input those values i just stated
    and have a program create a graph for me with made up data that fits
    those characteristics. So in theory i would be going backwards,
    instead of having the data and getting a program to tell me what the
    standard deviation, average, max and min i would be having the program
    give me data or random numbers to be able to fit certain characterics
    i choose.

    Could someone please help me out, im going insane trying to do this.

    Thank you very much. if you need more explaining you can email me
     
    adolfo, May 19, 2004
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.