LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Larry Holt
 
Posts: n/a
Default dealing with a projection

I am trying to establish the best way to make a simple projection.
I have National and State Level Data for 1992, 1997 and 2002.
Local Data has not been released for 2002, and I would like to make a
projection. Of course, the local data is a subset of the state data. I
can do a simple trendline of course, but I don't believe that accounts
for the relationship between the locality and the state. Hopefully this
is enough info. Thanks!
Larry

Data Example:
1992 1997 2002
US 620,912 823,499 1,197,988
State 14,707 19,077 28,684
Local 3,218 5,045

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dealing with worksheet groups Bob K Excel Worksheet Functions 0 October 19th 05 04:08 PM
VLOOKUP - dealing with lookup_value differences Cheese Excel Worksheet Functions 1 July 29th 05 11:00 PM
Dealing with hidden apostrophes... MavrikGandalf Excel Discussion (Misc queries) 1 July 26th 05 09:43 PM
Map projection as an Excel chart Piviq Charts and Charting in Excel 0 February 23rd 05 09:49 AM
Dealing with FALSE and O responses to IF formulas Tom Atlanta Excel Worksheet Functions 2 December 2nd 04 03:29 PM


All times are GMT +1. The time now is 11:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"