Question: Regression: Please include the Excel functions thank you C21 fx A B D E The following data has the quantity sold of an item for

Regression: Please include the Excel functions thank you C21 fx A BRegression: Please include the Excel functions thank you

C21 fx A B D E The following data has the quantity sold of an item for different prices. We would like to see whether there is a linear relationship between price (independent variable) and quantity sold (dependent variable). 3 Construct the appropriate regression model of these two variables. Using the regression model, calculate MAPE for the data. MAPE = \begin{tabular}{|c|c|c|c|c|} \hline Price (\$) & Quantity Sold & Forecast & Error & |Percentage Error| \\ \hline 2 & 7500 & & & \\ \hline 5 & 5400 & & & \\ \hline 3 & 7000 & & & \\ \hline 3.5 & 6500 & & & \\ \hline 2.5 & 7500 & & & \\ \hline 4.5 & 6000 & & & \\ \hline 4 & 5500 & & & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!