Time series analysis least square method solved examples

Time series analysis least square method solved examples In statistics or mathematics, a time series is a series of data points indexed (or listed or graphed) in time order. Most commonly, a time series is a sequence taken at successive equally spaced points in time. Thus it is a sequence of discrete-time data. The method of least squares is a standard approach in regression analysis to approximate the solution of overdetermined systems by minimizing the sum of the squares of the residuals made in the results of each individual equation. The most important application is in data fitting.

we have compiled you Time series analysis least square method solved examples to enable you understand and tackle Time series analysis least square method questions or exams with ease.

Time series definition of terms

  • Time series; A collection of observation of well defined data items obtained through repeated measurement over time. the components of time series are: secular trend, seasonal variations, cyclical fluctuations and irregular variations.
  • seasonal variations: is variation in a time series within one year that is repeated more or less regularly. Seasonal variation may be caused by the temperature, rainfall, public holidays, cycles of seasons or holidays.
  • cyclical fluctuations;  refers to regular periodic fluctuations around the trend, excluding the irregular component, revealing a succession of phases of expansion and contraction.
  • secular trend;  describes the movement over the long term of a time series that globally can be increasing, decreasing, or stable. The secular trend can be linear or not.
  • irregular variations; Irregular variations or random variations are not predictable constitute one of four components of a time series. They correspond to the movements that appear irregularly and generally during short periods. 

Importance of time series analysis

  • Helps in cleaning the data
  • Understanding the data
  • For predicting the future

Time series analysis least square method solved examples

Example 1

The table below shows the profit made by textile company within 2011 and 2019

  1. Use the least square method to estimate the trend line equation and values
  2. Estimate the profit for the year 2021
YearValues
20119.8
201211.5
201313.2
201412.8
201512.6
201612.1
201713.8
201815.3
201917.5

Solution 1

The first step to identify and solve the least squares is to know the formula which is given by yP=a+bx where a=sumation of y/N and b =summation of product of xy/(x)squared. You will draw the exaxt same table and add 4 columns for values of X, X2, XY and the trend values which is Yp=a+bx X is found by finding the values of N and pick the mid point

YearValues Y millionX (x-2015)X2xyYp=a+bx(Yp=13.18+0.1717X)
20119.8-416-39.210.33
201211.5-39-34.511.04
201313.2-24-26.411.76
201412.8-11-12.812.47
201512.6000013.18
201612.11112113.89
201713.82427.614.60
201815.33945.915.32
201917.54167016.03
 ΣY =118.6Σx =0Σ X2 =60ΣXY =42.7ΣYp =118.62
soved table
finding trend line value

Estimate the profit for the year 2021

solved estimate the profit 2021
  1. Use the least square method to estimate the trend line equation and values= answer is Yp=13.18+0.1717X
  2. Estimate the profit for the year 2021 answer is 17.45million

QUESTIONS AND ANSWERS TO STATISTICS, QUANTITATIVE TECHNIQUES, QUANTITATIVE METHODS E.T.C

  1. Examples & Formulas For Standard Deviation Variance Mean For Ungrouped Data
  2. Examples & formulas for standard deviation variance mean for grouped data
  3. Price index Laspeyres Paasche’s and fisher’s ideal price index questions and answers
  4. Probability questions and answers statistics
  5. Pearson’s Coefficient of correlation formula example & solution
  6. PERT network diagram critical path example and solution project management
  7. Venn diagrams examples with solution 2 3 circles
  8. Regression equation formula how to calculate solved example
  9. Frequency distribution table example with solution

QUANTITAVE METHODS NOTES(PDF)

We are a group of graduates from Kenya school of TVET which is tasked with Training of Technical Trainers to teach in secondary schools and tertiary institutions, Implementation of various syllabi under TVET Programs in collaboration with stakeholders. Development of relevant syllabi for technical training in collaboration with stakeholders.

Leave a Reply

Your email address will not be published. Required fields are marked *

Back To Top