Data Analysis

No Picture

Useful shortcuts for data analysis in Excel

Excel provides shortcuts of various command, from formatting to printing. Find your favorite shortcuts of excel when dealing with data analysis task. Here the useful shortcuts: Post relevance terms: excel data analysis hotkey, excel shortcuts…


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

Use Excel List for Data Analysis

What make data analysis become easier? If we recognize features of Microsoft Excel, we found that create a list is more powerful to get insight of data analysis. The related data groups can be managed…