Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

Can someone explain to me how I am supposed to get the SYX linear and quadratic as well as the MAD linear and quadratic. I

Can someone explain to me how I am supposed to get the SYX linear and quadratic as well as the MAD linear and quadratic. I think I am missing a step in the process and cannot figure it out. I thought I had it but I do not.

The accompanying data represent the yearly amount of solar power installed (in megawatts) in a particular area from 2000 through 2008. The trend forecasting equations below were found, where X is the number of years after 2000.

Yi= -9.867 + 28. 2167xi Y= 20.95 + 1.80xi + 3.3019

I need to find the SYX linear and quadratic and the MAD linear and quadratic. I am using excel but I do not believe I am doing it correctly.

I am not looking for the answer. I am looking for how to get to the answer with the information I have supplied. Thank you

Year Amount
2000 15
2001 27
2002 42
2003 70
2004 79
2005 102
2006 138
2007 206
2008 248

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Thomas Calculus Early Transcendentals

Authors: Joel R Hass, Christopher E Heil, Maurice D Weir

13th Edition

9780321884077

Students also viewed these Mathematics questions

Question

Explain how the Kanban system helps reduce inventories. LO1

Answered: 1 week ago

Question

What is ability? LO1.

Answered: 1 week ago