Excel and Statistics(13), Moving average

Excel and Statistics, everybody should know.  : Contents

 

 

Moving average

Call ‘moving average’.

 

Specify ‘input range’ and ‘output range’. For now, leave ‘Interval’ blank.

 

The forecast value is in column E, and it can be seen that it is the average value of the three actual values in column DŒ. If you look at the chart, the forecast is less volatile, because of course it shows three values as an average.

 

Now specify ‘interval’ as 5 and ‘output range’ so that it does not overlap.

 

Increasing the interval from 3 to 5 will naturally reduce volatility even more.

 

 

 

Excel and Statistics, everybody should know.  : Contents

=================================================

• R statisics portal https://tinyurl.com/stat-portal

• R data visualization book 1  https://tinyurl.com/R-plot-I (chart)

• R data visualization book 2
  

https://tinyurl.com/R-plot-II-2  simple variables
https://tinyurl.com/R-plot-II-3-4   many variables / map
https://tinyurl.com/R-plot-II-5-6   time related / statistics related
https://tinyurl.com/R-plot-II-7-8   others / reactive chart 

• R data visualization book 3    https://tinyurl.com/R-data-Vis3 
  

• R data visualization book 4   R 데이터 시각화 4권
  

• Meata Analysis book 1  https://tinyurl.com/MetaA-portal
• Meata Analysis book 2  https://tinyurl.com/MetaA-portal(2)

 

• Preciction Model and Machine Learning   https://tinyurl.com/Machine-Learning-EZ
• Sample Size Calculations   https://tinyurl.com/MY-sample-size 
• Sample data  https://tinyurl.com/data4edu 

• easier R than SPSS with Rcmdr : Contents