In: Statistics and Probability
Number of Certified Organic Farms in the United States, 2001–2008 |
|
Year | Farms |
2001 | 6,775 |
2002 | 7,163 |
2003 | 7,848 |
2004 | 7,819 |
2005 | 8,290 |
2006 | 9,205 |
2007 | 10,711 |
2008 | 12,068 |
Linear yt = _______ xt + __________
Quadratic yt = ______ xt^2 + ___________ xt + __________
Exponential yt = __________e-------x
Use each pf the three fitted trend equations to make numerical forecasts for the next 3 years.
t | Linear | Exponential | Quadratic |
9 | ? | ? | ? |
10 | ? | ? | ? |
11 | ? | ? | ? |
Will be using excel to answer this question:
Consider the following data:
Number of Certified Organic Farms in the United States, 2001–2008 | ||
Year | time | Farms |
2001 | 1 | 6,775 |
2002 | 2 | 7,163 |
2003 | 3 | 7,848 |
2004 | 4 | 7,819 |
2005 | 5 | 8,290 |
2006 | 6 | 9,205 |
2007 | 7 | 10,711 |
2008 | 8 | 12,068 |
1. Linear
2. Quadratic
3. Exponential
Forecasted values:
t | Linear | Quadratic | Exponential |
y = 706.35x + 5556.3 | y = 107.57x2 - 261.74x + 7169.8 | y = 6028e0.0785x | |
9 | 11,913.45 | 13,527.31 | 12,218.06 |
10 | 12,619.80 | 15,309.40 | 13,215.83 |
11 | 13,326.15 | 17,306.63 | 14,295.08 |
Please do upvote if you are satisfied! Let me know in the comments if anything is not clear. I will reply ASAP!