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