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…
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…
