Analytics NEWS
State of Artificial Intelligence in India 2017: Artificial Intelligence Industry in India is currently estimated to be $180 Million annually in revenues. There are approximately 29 Thousand…
Excel: WHAT-IF ANALYSIS – II
As we know excel includes many powerful tools to perform complex mathematical calculations, including what-if analysis. This feature can you help you to explore different…
R : Control Flow
Control flow is the order in which we code and have our statement evaluated. These allow us to control flow of execution of script inside…
Charts and Graphs in Excel
Charts and graphs are used to make information clearer and easier to understand. A good picture is worth a thousand numbers. The most common place for people…
Excel: DATA VALIDATION
Data validation feature allows you to set up certain rules that dictate what can be entered into a cell. It allows you to do the…
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…
