### Descriptive Statistics in R

Descriptive statistics is the term given to the analysis of data that helps, describe, show or summarize data in a meaningful way, It doesn’t allow…

### EXCEL : Importing External Data

External data is defined as data that exists outside of the Excel workbook, in some other place.  Other places could be almost anywhere; and Excel…

### Excel: Functions-II

TEXT FUNCTIONS 1. TRIM: Removes all spaces from a text string except for single spaces between words SYNTAX: =TRIM (text) TEXT: Required. The text from…

### Excel: Functions

MATHEMATICAL FUNCTION  1. SUM: Sum function is used to calculate a simple total for a range of numeric cells. SYNTAX:  =SUM (number1, [number2], …) EXAMPLE: Add…

### T – Test

Introduction An Irish statistician, W.S. Gossett in 1908, applied this test for test for testing the significance of difference between the means of two different…

### 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 ??? From one of the great leaps forward in succeeding versions of Microsoft Excel it has been in clarifying information in…

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

error: Content is protected !!