Please show work and formulas in excel. Thank you.

a) (1 pt) Identify the top three trendline methods among Exponential, Linear, Logarithmic, Polynomial (with order 6), Power, and Moving Average (with period 2). You can simply use the plots to identify these methods here.

b) (1 pt + 1 Bonus pt) Compare the three methods that you have identified in part (a) above using MAPE and find the best method.

c) (1.5 pts) Top-down selling tactic is initially offering high-priced items to a customer to pull WTP (reference price) up regardless of whether the customer is interested in or is able to afford these high-priced items. Suppose that you are a) a real estate agent selling houses, b) a mail catalog designer for a blouse company, c) a Wal-Mart store employee stocking pasta shelves, how would you implement the top-down selling tactic?

d) (1.5 pts) When the apartment rental market cools down, the apartment owners think of reducing the rental prices either directly or indirectly to stimulate the demand. Direct reduction is simply reducing the annual rent. One of the indirect reduction strategies is keeping the rent constant but not charging any the rent for the first month of a 12-month lease (also called free first-month). Among these two strategies, which one keeps the reference price higher? Explain. Is it in the interest of the apartment owners to keep the reference price higher?

Please show work and formulas in excel. Thank you.

A B 1 1 2 3 Confirmed Cases 75 100 4 124 5 158 221 6 319 7 8 435 9 541 704 10 11 12 994 1301 Date 1-Mar 2-Mar 3-Mar 4-Mar 5-Mar 6-Mar 7-Mar 8-Mar 9-Mar 10-Mar 11-Mar 12-Mar 13-Mar 14-Mar 15-Mar 16-Mar 17-Mar 18-Mar 19-Mar 20-Mar 21-Mar 22-Mar 23-Mar 13 1697 14 15 2247 2943 3680 16 17 4663 18 6411 19 20 21 9259 13789 19383 24207 33566 43774 22 23 24