(Solved by Humans)-All, Can someone help me with number 2 please: 1. Using Excel,
Question
All, ?
? Can someone help me with number 2 please:
1. ?Using Excel, use the forecasted sales from Case 3 to compute the MAPE, by doing the following:
Month
Sales
Hits
Jan
545
1200
Feb
301
820
Mar
510
1151
Apr
485
1050
May
525
1180
Jun
460
1047
Jul
500
1102
Aug
402
1054
Sep
584
1254
Oct
422
1071
Nov
514
1120
Dec
441
1287
5689
474.08
13336
1111.33
Totals
Mean
X
b1
b0
XY
654000
246820
587010
509250
619500
481620
551000
423708
732336
451962
575680
567567
6400453
X2
297025
90601
260100
235225
275625
211600
250000
161604
341056
178084
264196
194481
2759597
Y2
1440000
672400
1324801
1102500
1392400
1096209
1214404
1110916
1572516
1147041
1254400
1656369
14983956
Y
1.2485
519.44
SY.X 81.0793374 Standard Error
Sb1 0.32422161
t-test 3.85076121
t-crit 2.22813885 5%
t-crit 1.81246112 10%
Case 3
1400
1200
f(x) = 1.2485052163x + 519.4378187284
1000
800
Hits
600
400
200
0
250
300
350
400
450
Sales
500
550
600
650
0
250
300
350
400
450
500
Sales
Y? b0 b1 X
Hits
Jan
Feb
Mar
April
Sales
Sales
Forecast
Actual
1164
1972.69
1159
1966.45
1298
2139.99
441
421
355
512
550
600
650
50
600
650
50
600
650
Bypass any proctored exams 2025. Book your Exam today!
Failing attempts? Confusing materials? Overwhelming pressure?
✨ We help you pass your exam on the FIRST TRY, no matter the platform or proctoring software.
✅ Real-time assistance
✅ 100% confidential
✅ No upfront payment—pay only after success!
? Don’t struggle alone. Join the students who are passing stress-free!
? Visit https://proctoredsolutions.com/ and never get stuck with an exam again.
? Your success is just one click away!