Question: We have discussed linear and exponential trend lines. Another popular choice is a power trend line, also called a constant elasticity trend line. This trend

We have discussed linear and exponential trend lines. Another popular choice is a power trend line, also called a constant elasticity trend line. This trend line has the form y = axb, and it has the property that when x increases by 1%, y changes by a constant percentage. In fact, this constant percentage is approximately equal to the exponent b (which could be positive or negative). The power trend line is often cited in the economics literature, where, for example, x might be price and y might be demand. Fortunately, it can be found through Excel’s Trendline tool; the power trend line is just another option. Estimate and interpret a 14.4 Multiple Regression Models 805 power trend line for the data on demand and price of a commodity listed in the file P14_09.xlsx. In particular, if price increases by 1%, what do you expect to happen to demand? Calculate the MAPE for this power trend line. Would you say it indicates a good fit?

Step by Step Solution

3.31 Rating (178 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Price Demand Predicted Abs error 4867 1465 14067 398 3770 1786 1... View full answer

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

Document Format (3 attachments)

PDF file Icon

1497_60b74124de627_696635.pdf

180 KBs PDF File

Excel file Icon

1497_6045da3f65583_696635.xlsx

300 KBs Excel File

Word file Icon

1497_60b74124de627_696635.docx

120 KBs Word File

Students Have Also Explored These Related Practical Management Science Questions!