Statistic

No Picture

World’s changes in fascinating animation of statistics

My understanding on world’s changes has been enriched by Gapminder who provides fascinating animation of  various facts. Gapminder presents the facts with animated bubble reflecting time series numbers such world’s population, world’s oil reserve, familiy…


No Picture

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…


No Picture

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…


No Picture

How to protect your Excel sheet

If you have done something complex computation task of excel, you might be need to protect your sheet. Sheet protection will prevent changes on formula, deletion or even cell moving.   In Excel, we can arrange…