: Seasonal and = amounts listed below f 020 37,237

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
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:
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
392,620
512,393
458,459
437,586 927,701 535,856 851,239
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
Assuming 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.
April
May
June
428,153
Transcribed Image Text: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: 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 392,620 512,393 458,459 437,586 927,701 535,856 851,239 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 Assuming 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. April May June 428,153
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman