Suppose you have an extra 6 months of data on demands and prices, in addition to the data in the example. These extra data points are (350,84), (385,72), (410,67), (400,62), (330,92), and (480,53). (The price is shown first and then the demand at that price.) After adding these points to the original data, use Excel’s Trendline tool to find the best-fitting linear, power, and exponential trendlines. Finally, calculate the MAPE for each of these, based on all 18 months of data. Does the power curve still have the smallest MAPE?
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here