SAS Macro : Test for Normal Distribution

In most of the statistical tests, you need check assumption of normality. There is a test called Shapiro-Wilk W test that can be used to che...

READ MORE

How to Swap Cells in Excel

This article explains how to swap contents of cells in MS Excel. The excel trick is shown in the image below :- To swap the cells in the s...

READ MORE

How to Convert Data from Wide to Long Format in Excel

This tutorial explains how to convert data from wide to long format in Excel. Suppose you have data stored in wide format in Excel. You wan...

READ MORE

Excel Formula : Convert Data from Long to Wide Format

Suppose you have data that is stored in long format in Excel. You want to transpose it to wide format. Example : Suppose you have data in ...

READ MORE

Splitting Data into Training and Test Sets with R

In this tutorial, you will learn how to split sample into training and test data sets with R. The following code splits 70% of the data sel...

READ MORE