Data Analysis with Exponential Smoothing

Exponential smoothing is a time series analysis that omits irregular variation without take account of both seasonal variation and trend.  MS Excel provides exponential smoothing as a part of tools in Data Analysis.  The tool can predict a value based on the forecast for previous period. Exponential smoothing adjusts error in that prior prediction. It uses Constanta which is reflects the magnitude of which control how strongly the forecasts react to errors in the previous prediction. Smaller constants can result in long lags for prediction values.

How to apply exponential smothing analysis in Excel 2007? You should install add-ins of Data Analysis before.

(more…)

Related terms
    exponential smoothing excel, exponential smoothing excel 2007, exponential smoothing in excel, exponential smoothing in excel 2007, Excel exponential smoothing, how to do exponential smoothing in excel 2007, how to do exponential smoothing in excel, Exponential Smoothing Excel 2010, excel 2007 exponential smoothing

Use Correlation Test of MS Excel

Data Analysis of Excel has a function to determine the relationship between two variables.  Result of this function is coefficient of correlation which shows the strengh or weakness of a relationship. The value of coefficient ranges between -1.0 to +1.0

How to run the correlation test?
(more…)

Related terms
    how to run a correlation in excel, how to run correlation in excel, correlation test excel, how to run correlations in excel, how to run correlation in excel 2007, correlation test in excel, excel correlation test, testing correlation in excel, run correlation in excel

How to use data validation

Data Validation adalah salah satu tools di Excel yang bisa meningkatkan ketelitian kita dalam entry data.  Tools ini akan mencegah terjadinya kesalahan ketika kita sedang memasukan data (data entry). Kesalahan memasukan data bisa terjadi  karena salah ketik, atau data berada di luar range yang telah kita buat sebelumnya.

(more…)

Related terms
    data validation, fungsi data validation, membandingkan data di excel, data validation excel, contoh data validation excel, fungsi data validation pada excel, data palidation, validate excel 2010 pada file lain, menghindari double entry pada excell