(a) Use Excel, MegaStat, or MINITAB to fit three trends (linear, quadratic, expo

Question

(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.)

(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.)

Please just answer the parts ive asked for. Thank you.

Number of Certified Organic Farms
in the United States, 2001–2008 Year Farms 2001 6,272 2002 6,630 2003 7,300 2004 7,273 2005 7,712 2006 8,592 2007 10,310 2008 11,848

Explanation / Answer

a)

linear

=-1465232 + 735.08x

Quadratic

500000000-500000X+100X^2

exponential  

= 1.626 E-71 e^(0.085x)

PS: We are directed to solve only first if multiple questions are posted

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.