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!