ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   dealing with a projection (https://www.excelbanter.com/charts-charting-excel/71866-dealing-projection.html)

Larry Holt

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



All times are GMT +1. The time now is 04:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com