Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Construct a time-series graph of the sales data for MountainWear's line of ski apparel (see data in Week 4 Fall 2022 Case One Data.xls). Does
- Construct a time-series graph of the sales data for MountainWear's line of ski apparel (see data in Week 4 Fall 2022 Case One Data.xls). Does there appear to be a seasonal pattern and/or trend in the sales data? Explain why you think there is or is not seasonality and/or trend in the data.
Period Sales $ Inc NRUR Mar-09 153907 475 6.9 Jun-09 127732 534 6.5 Sep-09 93209 574 6.5 Dec-09 118203 622 6.4 Mar-10 145611 667 6.3 Jun-10 129976 702 6.2 Sep-10 95219 753 6.3 Dec-10 105210 796 6.5 Mar-11 164592 858 6.8 Jun-11 113201 870 7.9 Sep-11 105932 934 8.3 Dec-11 132182 1010 8 Mar-12 174200 1066 8 Jun-12 152918 1096 8 Sep-12 132290 1162 8 Dec-12 152419 1187 7.8 Mar-13 182764 1207 7.5 Jun-13 162921 1242 7.1 Sep-13 132961 1279 6.9 Dec-13 152971 1318 6.5 Mar-14 193271 1346 6.2 Jun-14 172312 1395 5.5 Sep-14 152281 1443 5.3 Dec-14 192314 1528 5 Mar-15 221938 1613 4.8 Jun-15 219223 1646 4.7 Sep-15 182342 1694 4.5 Dec-15 201921 1730 4.4 Mar-16 253901 1755 4.2 Jun-16 243976 1842 4 Sep-16 203338 1832 3.9 Dec-16 246723 1882 3.8 Mar-17 265532 1914 3.5 Jun-17 223008 2027 3.5 Sep-17 219976 1989 3.4 Dec-17 243338 2056 3.4 Mar-18 274456 2032 3.3 Jun-18 253382 2204 3.2 Sep-18 227764 2190 3.1 Dec-18 241138 2342 3.1
Period | Sales $ | Inc | NRUR |
Mar-09 | 153907 | 475 | 6.9 |
Jun-09 | 127732 | 534 | 6.5 |
Sep-09 | 93209 | 574 | 6.5 |
Dec-09 | 118203 | 622 | 6.4 |
Mar-10 | 145611 | 667 | 6.3 |
Jun-10 | 129976 | 702 | 6.2 |
Sep-10 | 95219 | 753 | 6.3 |
Dec-10 | 105210 | 796 | 6.5 |
Mar-11 | 164592 | 858 | 6.8 |
Jun-11 | 113201 | 870 | 7.9 |
Sep-11 | 105932 | 934 | 8.3 |
Dec-11 | 132182 | 1010 | 8 |
Mar-12 | 174200 | 1066 | 8 |
Jun-12 | 152918 | 1096 | 8 |
Sep-12 | 132290 | 1162 | 8 |
Dec-12 | 152419 | 1187 | 7.8 |
Mar-13 | 182764 | 1207 | 7.5 |
Jun-13 | 162921 | 1242 | 7.1 |
Sep-13 | 132961 | 1279 | 6.9 |
Dec-13 | 152971 | 1318 | 6.5 |
Mar-14 | 193271 | 1346 | 6.2 |
Jun-14 | 172312 | 1395 | 5.5 |
Sep-14 | 152281 | 1443 | 5.3 |
Dec-14 | 192314 | 1528 | 5 |
Mar-15 | 221938 | 1613 | 4.8 |
Jun-15 | 219223 | 1646 | 4.7 |
Sep-15 | 182342 | 1694 | 4.5 |
Dec-15 | 201921 | 1730 | 4.4 |
Mar-16 | 253901 | 1755 | 4.2 |
Jun-16 | 243976 | 1842 | 4 |
Sep-16 | 203338 | 1832 | 3.9 |
Dec-16 | 246723 | 1882 | 3.8 |
Mar-17 | 265532 | 1914 | 3.5 |
Jun-17 | 223008 | 2027 | 3.5 |
Sep-17 | 219976 | 1989 | 3.4 |
Dec-17 | 243338 | 2056 | 3.4 |
Mar-18 | 274456 | 2032 | 3.3 |
Jun-18 | 253382 | 2204 | 3.2 |
Sep-18 | 227764 | 2190 | 3.1 |
Dec-18 | 241138 | 2342 | 3.1 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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