Exponential smoothing, or Exponential moving average, is a method in time series analysis that helps us to analysis time based data and predicting of new period data. The approach of this method is getting average of all the data in time line with more attention on newest data periods. we can create a very fast report by using data analysis add in of Excel.
Tag: Add ins
Moving Average in Excel data analysis add in
Moving average is the simplest method for analyzing time series data. The moving average approach is to getting average of nearest data (instead of getting average from whole data). we can create a very fast report by using data analysis add in of Excel.
Histogram and frequency in Excel data analysis add in
By using Histogram tool in Excel data analysis add in, we can simply generate a report which contains the auto calculated bins, frequency, Histogram chart as well as Pareto analysis
Rank and Percentile in Excel data analysis add in
By using Rank and percentile in Excel data analysis add in, we can simply generate a report which will rank and sort our data very fast
Generating random number by Excel data analysis tool
By using random number generator of Excel analysis add ins we can generate a matrix of random numbers with custom seed
Data sampling with Excel data analysis tool
Instead of using formulas to generate random numbers and then selecting random samples from a data set, we can use data analysis add ins in Excel to generate random samples from a data set