Solved

After Some Experimentation, You Have Observed the Following Data Concerning

Question 31

Multiple Choice

After some experimentation, you have observed the following data concerning the relationship between marketing and sales. Use Excel's curve fitting method to find the best quadratic equation to model this relationship.
 Marketing ($) 100110120130140 Sales ($100) 3104005006007001501601701801902008509751,1001,3001,4251,600\begin{array}{|l|c|c|c|c|c}\hline \begin{array}{l}\text { Marketing } \\(\$) \end{array} & 100 & 110 & 120 & 130 & 140 \\\hline \begin{array}{l}\text { Sales } \\(\$ 100) \end{array} & 310 & 400 & 500 & 600 & 700 \\\hline\end{array}\begin{array}{|r|r|r|r|r|r|}\hline \\150 & 160 & 170 & 180 & 190 & 200 \\\hline \\850 & 975 & 1,100 & 1,300 & 1,425 & 1,600 \\\hline\end{array}


A) 0.11x2 + 1.4x + 40
B) 0.05x2 ? 1.1x ? 44
C) 0.05x2 + 1.1x + 44
D) 0.11x2 ? 1.4x ? 40
E) 0.05x2 ? 1.1x + 44

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions