Coconote
AI notes
AI voice & video notes
Export note
Try for free
Understanding Time Series Trend Analysis
Sep 3, 2024
Time Series Lecture Notes
Introduction to Time Series Methods
First Method
: Free Hand Method
Second Method
: Method of Semi Averages
Important and easy to understand
Graphical method
Method of Semi Averages
Objective
: Fit a trend value using the method of semi-averages.
Data Provided
: Sales data from 1991 to 1996 (in thousands of units)
Steps to Calculate Semi Averages:
Divide the Data
:
Split the 6 years data into two groups of 3 years each.
Calculate the Averages
:
First Group (1991-1993)
:
Sales: 20, 24, 22
Total = 20 + 24 + 22 = 66
Average = 66 / 3 =
22
Second Group (1994-1996)
:
Sales: 30, 28, 32
Total = 30 + 28 + 32 = 90
Average = 90 / 3 =
30
Graphical Representation:
X-axis
: Years (1991, 1992, 1993, 1994, 1995, 1996)
Y-axis
: Sales (Class Interval of 10 - From 10 to 40)
Plotting the Actual and Trend Lines:
Plot Actual Sales Data
:
1991: 20
1992: 24
1993: 22
1994: 30
1995: 28
1996: 30
Plot Semi-Averages
:
Average for 1991-1993 (22) is plotted for the year 1992.
Average for 1994-1996 (30) is plotted for the year 1995.
Draw Trend Line
:
Connect the two semi-averages on the graph.
Observations:
The trend line should ideally go through the plotted points of actual sales data.
Verify that the trend line is positioned correctly relative to actual sales.
Conclusion:
Note
:
6 years of data were used. Average for the first three years is 22; for the last three years is 30.
This process is simple and effective for understanding trends in time series data.
Next Steps:
Explore other methods of trend analysis.
Review additional resources linked in the description for further study.
Additional Resources:
Search for specific topics on YouTube (e.g., Break-even point) for more learning materials.
📄
Full transcript