dolution

/in /by

Using only the Nashville sales data:

1. Forecast sales for January 7th through January 30th using a three-day weighted moving average. (5pts)

The weights are:

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

Day

Weight

1 day previous

-0.50

2 days previous

-0.30

3 days previous

-0.20

2. Find the mean absolute deviation of the sales forecasts for January 7th through January 29th. You should not include the forecast for January 30th since there is no corresponding sales figure for that date. (3pts)

3. Find the mean squared error of the sales forecasts, again for January 7th through January 29th. (4pts)

4. Create a scatter scatter-chart for the three-day weighted moving average. Label your chart axes properly. (2 pts)

Date

Chicago

Seasonal Relatives for Chicago Sales

Nashville

Seattle

1/4/21

272

0.4

659

456

1/5/21

388

0.5

493

672

1/6/21

622

1.3

483

584

1/7/21

605

1.7

579

609

1/8/21

222

1.4

652

596

1/9/21

222

1.6

535

529

1/10/21

302

0.9

399

612

1/11/21

338

1.2

423

683

1/12/21

239

0.5

619

565

1/13/21

283

0.3

567

559

1/14/21

505

0.7

548

785

1/15/21

829

1.1

766

783

1/16/21

686

1.4

479

599

1/17/21

893

2.2

435

711

1/18/21

184

0.6

651

756

1/19/21

188

0.7

650

712

1/20/21

290

0.8

491

512

1/21/21

369

0.9

549

447

1/22/21

395

1.3

463

574

1/23/21

846

1.5

595

654

1/24/21

961

1.9

829

552

1/25/21

193

0.5

886

470

1/26/21

193

0.8

639

596

1/27/21

245

0.8

645

562

1/28/21

317

0.9

627

454

1/29/21

480

1

459

800

1/30/21
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"