Question
Number of Certified Organic Farms in the United States 2001-5,511 2002-5,861 2003-6,589 2004-6,578 2005-7,075 2006-7,985 2007-9,777 2008-11,347 (a) Use Excel, MegaStat, or MINITAB to fit
Number of Certified Organic Farms
in the United States 2001-5,511 2002-5,861 2003-6,589 2004-6,578 2005-7,075 2006-7,985 2007-9,777 2008-11,347
(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 finalanswers to 2 decimal places.)
Linearyt=xt+Quadraticyt=xt2+xt+Exponentialyt=ex
(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 finalanswers to 1 decimal place.)
tLinearExponentialQuadratic91011
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started