Question
Open a blank Excel workbook, and then upload the Champagne Sales Download Champagne Sales .CSV file using the buttons in the Data tab. Once you've
Open a blank Excel workbook, and then upload the Champagne Sales Download Champagne Sales .CSV file using the buttons in the Data tab. Once you've done that, use Forecast Sheet to forecast the next two years of champagne sales. Take note of the seasonality component. Add another Forecast Sheet where you manually set Seasonality to 4 periods. The Excel document you submit should have 3 worksheets: one with the Champagne Sales data, one with the automatic seasonality forecast, and a third with the manual seasonality set to 4 periods. Date Perrin Freres monthly champagne sales millions ?
Date | Perrin Freres monthly champagne sales millions ?64-?72 | Column1 |
1/1/64 | 2815 | |
2/1/64 | 2672 | |
3/1/64 | 2755 | |
4/1/64 | 2721 | |
5/1/64 | 2946 | |
6/1/64 | 3036 | |
7/1/64 | 2282 | |
8/1/64 | 2212 | |
9/1/64 | 2922 | |
10/1/64 | 4301 | |
11/1/64 | 5764 | |
12/1/64 | 7312 | |
1/1/65 | 2541 | |
2/1/65 | 2475 | |
3/1/65 | 3031 | |
4/1/65 | 3266 | |
5/1/65 | 3776 | |
6/1/65 | 3230 | |
7/1/65 | 3028 | |
8/1/65 | 1759 | |
9/1/65 | 3595 | |
10/1/65 | 4474 | |
11/1/65 | 6838 | |
12/1/65 | 8357 | |
1/1/66 | 3113 | |
2/1/66 | 3006 | |
3/1/66 | 4047 | |
4/1/66 | 3523 | |
5/1/66 | 3937 | |
6/1/66 | 3986 | |
7/1/66 | 3260 | |
8/1/66 | 1573 | |
9/1/66 | 3528 | |
10/1/66 | 5211 | |
11/1/66 | 7614 | |
12/1/66 | 9254 | |
1/1/67 | 5375 | |
2/1/67 | 3088 | |
3/1/67 | 3718 | |
4/1/67 | 4514 | |
5/1/67 | 4520 | |
6/1/67 | 4539 | |
7/1/67 | 3663 | |
8/1/67 | 1643 | |
9/1/67 | 4739 | |
10/1/67 | 5428 | |
11/1/67 | 8314 | |
12/1/67 | 10651 | |
1/1/68 | 3633 | |
2/1/68 | 4292 | |
3/1/68 | 4154 | |
4/1/68 | 4121 | |
5/1/68 | 4647 | |
6/1/68 | 4753 | |
7/1/68 | 3965 | |
8/1/68 | 1723 | |
9/1/68 | 5048 | |
10/1/68 | 6922 | |
11/1/68 | 9858 | |
12/1/68 | 11331 | |
1/1/69 | 4016 | |
2/1/69 | 3957 | |
3/1/69 | 4510 | |
4/1/69 | 4276 | |
5/1/69 | 4968 | |
6/1/69 | 4677 | |
7/1/69 | 3523 | |
8/1/69 | 1821 | |
9/1/69 | 5222 | |
10/1/69 | 6872 | |
11/1/69 | 10803 | |
12/1/69 | 13916 | |
1/1/70 | 2639 | |
2/1/70 | 2899 | |
3/1/70 | 3370 | |
4/1/70 | 3740 | |
5/1/70 | 2927 | |
6/1/70 | 3986 | |
7/1/70 | 4217 | |
8/1/70 | 1738 | |
9/1/70 | 5221 | |
10/1/70 | 6424 | |
11/1/70 | 9842 | |
12/1/70 | 13076 | |
1/1/71 | 3934 | |
2/1/71 | 3162 | |
3/1/71 | 4286 | |
4/1/71 | 4676 | |
5/1/71 | 5010 | |
6/1/71 | 4874 | |
7/1/71 | 4633 | |
8/1/71 | 1659 | |
9/1/71 | 5951 | |
10/1/71 | 6981 | |
11/1/71 | 9851 | |
12/1/71 | 12670 | |
1/1/72 | 4348 | |
2/1/72 | 3564 | |
3/1/72 | 4577 | |
4/1/72 | 4788 | |
5/1/72 | 4618 | |
6/1/72 | 5312 | |
7/1/72 | 4298 | |
8/1/72 | 1413 | |
9/1/72 | 5877 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started