Hot Topics in Analytics

### Excel : SORT AND FILTER

Sorting: The literal meaning of sorting is to rearrange the stuff in a desired manner. The exactly same facility is provided by MS Excel to…

### Excel: WHAT-IF ANALYSIS

One of the most appealing aspects of Excel is its ability to create dynamic models. A dynamic model uses formulas that instantly recalculate when you…

### Test Of Hypothesis

1. Introduction to Hypothesis Testing A hypothesis, in statistics, is a statement about a population where this statement typically is represented by some specific numerical…

### Excel with Look up Function

Excel with Look up Function: VLOOKUP:-Vlookup is an excel function to lookup and retrieve data from a specific column. Vlookup support approximate and exact match….

### Unconditional Excellence: Conditional Formatting in Excel

What is conditional formatting option? One of the great leaps forward in successive versions of Microsoft Excel has been in clarifying information in immediate and…

### Learn Multiple Regression using R

Learn Multiple Regression using R: The term “multiple” in multiple regression means that more than one variable as independent (numerical and categorical) to make predictions…

### Pivot Tables For Experts

Now that we know how to create a Pivot table, Let us look into few advanced aspects of it. Let us find out the…

### Pivot Tables For Beginner

What is Pivot Table in MS Excel? Ever wondered what we would do when we have chunks of data with thousands of rows and columns…

### Demonetization and its Impact on Retail Industry

WHAT IS DEMONETIZATION The term demonetization is not new to the Indian economy. The highest denomination note ever printed by the Reserve Bank of India…

### Chisquare Test, Different Types and its Application using R

Chi-Square Test The chi-square statistic is represented by χ2. The tests associated with this particular statistic are used when your variables are at the nominal…

## Subscribe for Data Analytics Edge Newsletter & Share..:-)

error: Content is protected !!