Overview Chat Bike Members News Women
Viewing 7 posts - 1 through 7 (of 7 total)
  • Excel Question – How do I Extrapolate?
  • beamers
    Full Member

    I am trying to produce a graph on Excel which shows projected monthly usage of a service based on historical monthly usage figures.

    Can any of the stats ninjas on here tell me how to do this?

    Ta in advance.

    Posted 14 years ago
    djglover
    Free Member

    right click on the line, add trendline, under options is the bit where you can forecast x periods

    Posted 14 years ago
    flippinheckler
    Free Member

    Posted 14 years ago
    beamers
    Full Member

    Thats exactly what I was wanting to do.

    Ta very much

    Posted 14 years ago
    reggiegasket
    Free Member

    unless there are seasonal or time lag issues…….

    Posted 14 years ago
    gwaelod
    Free Member

    beamers – Member

    I am trying to produce a graph on Excel which shows projected monthly usage of a service based on historical monthly usage figures.

    Can any of the stats ninjas on here tell me how to do this?

    Ta in advance.

    Christ – I hope you don't work at the Treasury

    Posted 14 years ago
    beamers
    Full Member

    Christ – I hope you don't work at the Treasury

    Fortunately not. Although I'm sure that those who do could learn a lot from this forum.

    Posted 14 years ago
Viewing 7 posts - 1 through 7 (of 7 total)

The topic ‘Excel Question – How do I Extrapolate?’ is closed to new replies.

Overview Chat Bike Members News Women