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
Price Demand Predicted Abs error 4867 1465 14067 398 3770 1786 1... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (3 attachments)
1497_60b74124de627_696635.pdf
180 KBs PDF File
1497_6045da3f65583_696635.xlsx
300 KBs Excel File
1497_60b74124de627_696635.docx
120 KBs Word File
