DAT565 Wk 6 Practice Wk 6 Exercises Q11 Year Spending 2001 5153 2002 5454 2003 6178 2004 6150 2005 6598 2006 7486 2007 9248 2008 11043 Number of Certified Organic Farms in the United States, 20012008 Year Farms 2001 5,153 2002 5,454 2003 6,178 2004 6,150 2005 6,598 2006 7,486 2007 9,248 2008 11,043 (a) Fit three trends (linear, quadratic, exponential) to the time series (A negative value should be indicated by a minus sign Do not round the intermediate calculations Round your final answers to 2 decimal places ) Linear y t 768 71 x t Quadratic y t 138 94 x t 2 x t Exponential y t 4373 29 e x 0 10 (b) Use each of the three fitted trend equations to make numerical forecasts for the next three years (Round the intermediate calculations to 2 decimal places and round your final answers to 1 decimal place ) t Linear Exponential Quadratic 9 10622 96 12707 07 10 11391 68 14865 19 11 12160 39 17301 19 WK 6 Practice Wk 6 Exercises (due Day 5) 0 Saved 11 2 points Number of Certified Organic Farms in the United States, 2001 2008 Year Farms 2001 5,153 2002 5,454 2003 6,178 2004 6,150 2005 6,598 2006 7,486 2007 9,248 2008 11,043 eBook References Click here for the Excel Data File (a) Fit three trends (linear, quadratic, exponential) to the time series (A negative value should be indicated by a minus sign Do not round the intermediate calculations Round your final answers to 2 decimal places ) Yt Linear Quadratic Exponential Yt 768 71 xt 138 94 x 2 4373 29 Xt yt 0 10 x (b) Use each of the three fitted trend equations to make numerical forecasts for the next three years (Round the intermediate calculations to 2 decimal places and round your final answers to 1 decimal place ) t Exponential 9 Linear 10622 96 11391 68 12160 39 Quadratic 12707 07 14865 19 17301 19 10 11

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 27, 2024

DAT565 Wk 6 - Practice: Wk 6 Exercises Q11 Year Spending 2001 5153 2002 5454 2003 6178 2004 6150 2005 6598 2006 7486 2007 9248

DAT565 Wk 6 - Practice: Wk 6 Exercises Q11

Year	Spending
2001	5153
2002	5454
2003	6178
2004	6150
2005	6598
2006	7486
2007	9248
2008	11043

Number of Certified Organic Farms in the United States, 20012008
Year	Farms
2001	5,153
2002	5,454
2003	6,178
2004	6,150
2005	6,598
2006	7,486
2007	9,248
2008	11,043

(a) Fit three trends (linear, quadratic, exponential) to the time series. (A negative value should be indicated by a minus sign. Do not round the intermediate calculations. Round your final answers to 2 decimal places.)


Linear	y_t = 768.71 x_t + ?
Quadratic	y_t = 138.94 x_t^{2 ?} + x_t + ?
Exponential	y_t = 4373.29 e^{x 0.10}

(b) Use each of the three fitted trend equations to make numerical forecasts for the next three years. (Round the intermediate calculations to 2 decimal places and round your final answers to 1 decimal place.)

t	Linear	Exponential	Quadratic
9	10622.96		12707.07
10	11391.68		14865.19
11	12160.39		17301.19

image text in transcribed

WK 6 - Practice: Wk 6 Exercises (due Day 5) 0 Saved 11 2 points Number of Certified Organic Farms in the United States, 2001-2008 Year Farms 2001 5,153 2002 5,454 2003 6,178 2004 6,150 2005 6,598 2006 7,486 2007 9,248 2008 11,043 eBook References Click here for the Excel Data File (a) Fit three trends (linear, quadratic, exponential) to the time series. (A negative value should be indicated by a minus sign. Do not round the intermediate calculations. Round your final answers to 2 decimal places.) Yt = Linear Quadratic Exponential Yt = 768.71 xt + 138.94 x+2+ 4373.29 Xt + yt = 0.10 x (b) Use each of the three fitted trend equations to make numerical forecasts for the next three years. (Round the intermediate calculations to 2 decimal places and round your final answers to 1 decimal place.) t Exponential 9 Linear 10622.96 11391.68 12160.39 Quadratic 12707.07 14865.19 17301.19 10 11