Description
Download the Excel Template attached to this assignment onto your computer, open it up, and read through the "Red Snapper Scenario" at the top of the page. All of this week's assignments focuses on historical Red Snapper Catches for 2015 through 2018 (by Quarter) off the coast of Louisiana. The last four rows of the table are empty as 2019 is what you are going to forecast using the historical data for 2015 through 2018. As you scroll down through the Spreadsheet, you will notice in the far left column, there are five tasks for you to complete this week. Every one of these tasks is mirrored in the three YouTube videos below. Although this project is about Red Snapper Catches (your faithful designer's favorite fish to catch and eat out of the southern bays of Louisiana) and the videos forecast Car sales, the process for forecasting the future year (in our case 2019) is identical.
You will want to watch these videos as you complete each of the five tasks. Where you want to transition from video 1 to video 2 and from video 2 to video 3 is very easy to see. One easy way to get started is to have a video open on one side of your screen and the excel template on the other.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Hi. Kindly let me know if you have any question, find any problem or detect any error in the answer for revisions. Otherwise, thank you😁
You have been asked to analyze the trends in Red Snapper taken out of the coastal waters of Louisiana. The dat
(assignments) you will need to complete in this Time-Series Data Analysis and forecasting. Be sure to complete a
Historical Quarterly data Red Snapper Take in tons 2015 - 2018 and Forecast for 2019
Task 1
t
Year
Quarter
Tons (x 100) Yt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
2015
1
2
3
4
1
2
3
4
1
2
3
4
1
2
3
4
1
2
3
4
4.50
6.90
3.20
1.60
5.50
7.80
4.10
1.80
6.40
9.20
4.80
2.20
7.30
8.60
5.20
2.30
2016
2017
2018
2019
MA
4.05
4.30
4.53
4.75
4.80
5.03
5.38
5.55
5.65
5.88
5.73
5.83
5.85
Create a Time series visualization of the historical take of Red Snapper by creating a line chart
with markers, by year and quarter, and with an appropriate title. Do not use Column C for this plot, o
Start by highlighting the column headings and then all data down through Quarter 4. Follow the direc
creating this chart given in the "Excel Time Series Part 1...