Results 1 to 5 of 5

Project user data

Threaded View

  1. #1
    Registered User
    Join Date
    02-03-2011
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2003
    Posts
    4

    Project user data

    I'm sure this is something simple that I'm overlooking. I really don't know much about Excel except what I've been forced to learn on the job.

    I have sets of data with three kinds of data:
    Column A is years
    Column B is number of persons using a specific service.
    Column C is number of persons within the total population set

    I need to project out to 2015

    Currently I'm using the Forecast function like so:
    =FORECAST(2011,B3:B6,A3:A6)

    The problem is that the data results that I'm getting don't seem to jive with expectations.. they seem a bit too inflated.

    What would be a better function to use in order to project the change in the users and population based on the past trends?

    Thanks so much for any help!

    PS - This is my first post.. I spent a lot of time searching and could not find anything that made sense for my application so I apologize if I missed something.

    PPS - I attached a file to show what I'm talking about. Sorry I didn't do it sooner.
    Attached Files Attached Files
    Last edited by DBarto; 02-08-2011 at 04:13 AM. Reason: WOOHOO! solved!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1