Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

10 20 pts This Excel file contains five years of monthly data on sales (number of units sold) for a particular company. The company suspects

10 20 pts This Excel file contains five years of monthly data on sales (number of units sold) for a particular company. The company suspects that except for random noise, its sales are growing by a constant percentage each month and will continue to do so for at least the near future. Fit an exponential linear trend model to the data and report the resulting equation. Let t represent the time index and Y represent sales. (a) Round your answer to three decimal places, if necessary. If your answer is negative number, enter "minus" sign. Log(Y)= (b) State explicitly what it says about the percentage growth per month. Round your answer to one decimal place, if necessary The equation implies an approximate % increase per month. (c) What are the RMSE and MAPE for the forecast model in part a? Round your answers to two decimal places, if necessary. RMSE is MAPE is %. F28 x fx A B C D E G H 12345 Month Sales 1 5600 2 5740 3 6230 5 6 7 68 456N 6210 7090 7130 7 6690 8 6080 10 9 8040 11 10 8030 12 11 7720 13 12 8200 14 13 7980 15 14 6930 16 15 8310 17 16 6870 18 17 7330 19 18 7670 20 19 7490 21 20 10230 22 21 10230 23 22 11010 24 23 11920 25 24 11530 26 25 13070 27 26 12700 28 27 12000 29 28 12700 30 29 11970 31 30 15690 32 31 17020 33 32 16980 34 33 15330 35 34 14890 36 35 15130 37 36 14630 38 37 15990 Data A B C D E 31 30 15690 32 31 17020 33 32 16980 34 35 m m 33 15330 34 14890 36 35 15130 37 36 14630 38 37 15990 39 38 15910 40 39 16510 41 40 17060 42 41 18080 43 42 18220 44 43 16940 45 44 16600 46 45 17650 47 46 18070 48 47 17930 49 48 17150 50 49 19100 51 50 22090 52 22 51 20540 53 52 22250 54 53 23170 55 54 23610 56 55 26370 57 56 26320 58 57 24710 59 58 24150 60 59 24390 61 60 24360 62 LL F G

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

=+Will the humor help meet the objectives?

Answered: 1 week ago

Question

Draft a proposal for a risk assessment exercise.

Answered: 1 week ago