Number of Certified Organic Farms in the United States, 2001-2008 Year 2001 2002
ID: 3316506 • Letter: N
Question
Number of Certified Organic Farms in the United States, 2001-2008 Year 2001 2002 2003 2004 2005 2006 2007 2008 Farms 6,949 7,323 8,035 8,021 8,493 9,469 11,352 12,941 Click here for (a) Use Excel, MegaStat, or MINITAB to 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 Quadratic Xt t (b) Use each of the three fitted trend equations to make numerical forecasts for the next 3 years. (Round the intermediate calculations to 2 decimal places and round your final answers to 1 decimal place.) Linear Exponential Quadratic 10Explanation / Answer
I have used excel trendline function by plotting scatter plot.
(a) Linear : y^ = 795.99t + 5490.93
Quadratic : y^ = 135.85t2 - 426.67t + 7528.70
Exponential : y^ = 6074e0.0845x
(b) The table for forecast are given below.
Linear Qudratic Exponential 2008 9 12654.84 14692.52 12994.3853 2008 10 13450.83 16847 14140.1372 2008 11 14246.82 19273.18 15386.9134Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.