Problem 15-8 Spreadsheet Problem: Seasonal and Trend Estimated Sales (LG15-2)John’s Bait and Fish Shop has had the monthly sales amounts listed below for the last four years.Year:2017201820192020January$ 417,772$ 585,999$ 334,477$ 587,237February113,110138,191166,936114,904March139,878177,80486,993138,381April428,153392,620512,393458,459May437,586927,701535,856851,239June743,5411,085,502598,028741,220July1,449,4691,250,8781,564,4431,580,045August1,428,4471,794,6511,850,3851,590,062September1,179,4751,023,896683,008725,453October368,881466,181483,351652,794November257,238389,475262,180310,030December322,024387,349234,914371,080Assuming that there are both seasonality and a trend, estimate monthly sales for each month of the coming year.Note: Round your answers to the nearest whole dollar amount.

you can follow these steps:Define the historical monthly sales data. Create a NumPy array with the…

Answered: Problem 15-8 Spreadsheet Problem:…

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

John’s Bait and Fish Shop has had the monthly sales amounts listed below for the last four years.

Year:	2017	2018	2019	2020
January	$ 417,772	$ 585,999	$ 334,477	$ 587,237
February	113,110	138,191	166,936	114,904
March	139,878	177,804	86,993	138,381
April	428,153	392,620	512,393	458,459
May	437,586	927,701	535,856	851,239
June	743,541	1,085,502	598,028	741,220
July	1,449,469	1,250,878	1,564,443	1,580,045
August	1,428,447	1,794,651	1,850,385	1,590,062
September	1,179,475	1,023,896	683,008	725,453
October	368,881	466,181	483,351	652,794
November	257,238	389,475	262,180	310,030
December	322,024	387,349	234,914	371,080