Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Chart/Trend/Growth help (2000/2003)

    Hi All, i am trying to make a chart that looks at three years of data and projects the results for the next 3 years. I have a couple of questions.
    I highlighted all the grades for 2005-2007 and used the autofill handle to drag them across, Is this the proper way I should do this?

    When I did this some grades went over 100, Is there a way to keep them at the 100 ceiling OR have the chart line stop at 100,
    I set the range on the Y axis to 105 so the 104 average would show. Because agrade cannot actually exceed 100. thanks
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Chart/Trend/Growth help (2000/2003)

    Since grades cannot rise above 100, a linear or polynomial trend clearly doesn't make sense, so you'd have to use another model. But with only 3 data points, it is impossible to determine which model would best fit the data. Unless you already know what model you should use, you shouldn't try to extrapolate these data.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Chart/Trend/Growth help (2000/2003)

    <P ID="edit" class=small>(Edited by Jezza on 07-Apr-07 12:44. To extend the range to B53)</P>Hi there

    I would go for an if statement in Cells B53:G53

    In B53 put =IF(B52/50>100,100,B52/50) and copy across to G53.

    Double click the trendline and change it to a Power...
    Jerry

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Chart/Trend/Growth help (2000/2003)

    I have attached the workbook with one possible approach, but since - as I noted in my previous reply - the number of data points is very small, the choice is rather arbitrary: a 1-1/x model.
    Attached Files Attached Files

  5. #5
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart/Trend/Growth help (2000/2003)

    Jerry, Hans -thanks for the solution. We have just been training for 3 years and we are up to about 1200 students annually, so this is demo is to demonstrate where we will be, I believe it is just what I want. Thanks again...I may be back <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  6. #6
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart/Trend/Growth help (2000/2003)

    What I meant was "Are our processes working"

Posting Permissions

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