Question
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
Get Instant Access with AI-Powered 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