Posts Tagged ‘Statistic’

World’s changes in fascinating animation of statistics

Posted in Internet on April 24th, 2009 by iip – Be the first to comment

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 number and length of life.

There’s a fact that some people always confused by table and numbers. Presenting facts with fascinating instruments without reducing key massages seems a good way for institution and organization who want to meet their goals with good understanding of their audiences or customers.

Gapminder World has ability to present  oil consumption and production of each countries from 1980 to 2007.  Here the steps: read more »

Incoming search terms :

Data Analysis with Exponential Smoothing

Posted in Spreadsheet tips on December 4th, 2008 by iip – Be the first to comment

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.

read more »

Incoming search terms :

Use Correlation Test of MS Excel

Posted in Spreadsheet tips on November 28th, 2008 by iip – 1 Comment

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?
read more »

Incoming search terms :

Get Adobe Flash playerPlugin by wpburn.com wordpress themes