I did it!!

Time Series Analysis

Please use the provided dataset to answer the following time series questions Alabada salmon is a non-migratory salmon. Although it is an economic fish species that often occurs near the Caribbean Sea, scientists still do not understand the mechanism of its reproduction, but according to research, the number of its occurrence may be seasonal. Please help the fishermen to judge the following data based on the number of Alabada salmon recorded by local fishermen in the Caribbean Sea. Number of salmon Q1 Q2 Q3 Q4 2005 19 26 23 29 2006 21 29 27 35 2007 25 31 30 38 (1) Use excel to calculate the seasonal irregularity effect (2) Use excel to calculate the seasonal index (rounding to 4 decimal places) (3) Use excel to calculate the central moving average (4) Use excel to calculate the time series data with seasonal factors removed (rounding to 3 decimal places) Please use the provided dataset to answer the following time series questions Alabada salmon is a non-migratory salmon. Although it is an economic fish species that often occurs near the Caribbean Sea, scientists still do not understand the mechanism of its reproduction, but according to research, the number of its occurrence may be seasonal. Please help the fishermen to judge the following data based on the number of Alabada salmon recorded by local fishermen in the Caribbean Sea. Number of salmon Q1 Q2 Q3 Q4 2005 19 26 23 29 2006 21 29 27 35 2007 25 31 30 38 (1) Use excel to calculate the seasonal irregularity effect (2) Use excel to calculate the seasonal index (rounding to 4 decimal places) (3) Use excel to calculate the central moving average (4) Use excel to calculate the time series data with seasonal factors removed (rounding to 3 decimal places)