Skip to main content

FORMULA MS-EXCEL PART-3

STATISTICAL FUNCTION 






1. MAX FUNCTION ()




Summary 
The Excel MAX function returns the largest numeric value in a range of values. The MAX function ignores empty cells, the logical values TRUE and FALSE, and text values.
Purpose 
Get the largest value
Return value 
The largest value in the array.
Syntax 
=MAX (number1, [number2], ...)
Arguments 
  • number1 - Number, reference to numeric value, or range that contains numeric values.
  • number2 - [optional] Number, reference to numeric value, or range that contains numeric values.
Usage notes 
The MAX function can be used to return the largest value from a set of data. For example, the slowest time in a race, the hightest temperature, or the top sales number. Arguments can be provided as constants, or as cell references or ranges, for example:


=MAX(5,10)
=MAX(A1,A2,A3)
-MAX(A1:A10)

2. MIN FUNCTION ()




Summary 
The Excel MIN function returns the smallest numeric value in a range of values. The MIN function ignores empty cells, the logical values TRUE and FALSE, and text values.
Purpose 
Get the smallest value.
Return value 
The smallest value in the array.
Syntax 
=MIN (number1, [number2], ...)
Arguments 
  • number1 - Number, reference to numeric value, or range that contains numeric values.
  • number2 - [optional] Number, reference to numeric value, or range that contains numeric values.
Usage notes 
The MIN function can be used to return the smallest value from a set of data. For example, the fastest time in a race, the lowest temperature, or the smallest sales number. Arguments can be provided as constants, or as cell references or ranges, for example:


=MIN(5,10)
=MIN(A1,A2,A3)
-MIN(A1:A10)

3.AVERAGE FUNCTION ()

Summary 
The Excel AVERAGE function returns the average of values supplied as multiple arguments. AVERAGE can handle up to 255 individual arguments, which can include numbers, cell references, ranges, arrays, and constants.
Purpose 
Get the average of a group of numbers
Return value 
A number representing the average.
Syntax 
=AVERAGE (number1, [number2], ...)
Arguments 
  • number1 - A number or cell reference that refers to numeric values.
  • number2 - [optional] A number or cell reference that refers to numeric values.
Usage notes 
  1. The AVERAGE function returns the average (arithmetic mean) of a group of supplied numbers.
  2. To calculate the average, Excel adds the numbers together and divides by the total number of numbers. For example, AVERAGE (2,4,6) returns 4.
  3. Numbers can be supplied as numbers, ranges, named ranges, or cell references that contain numeric values. Up to 255 numbers can be supplied.
  4. The AVERAGE function will automatically ignore empty cells.

4.COUNT FUNCTION ()









Summary 
The Excel COUNT function returns the count of values that are numbers, generally cells that contain numbers. Values can be supplied as constants, cell references, or ranges.
Purpose 
Count numbers
Return value 
A number representing a count of numbers.
Syntax 
=COUNT (value1, [value2], ...)
Arguments 
  • value1 - An item, cell reference, or range.
  • value2 - [optional] An item, cell reference, or range.
Usage notes 
The COUNT function counts the number of numbers in supplied values. Values can be items, cell references, or ranges. For example, =COUNT(1, 2, "apple") returns 2. And COUNT(A1:A10) will count the number of numeric values in the range A1:A10.
  • Count can handle up to 255 additional values.
  • Use COUNTA to include text and logical values. Use COUNTIF to count based on criteria.
  • Error values or text values that cannot be coerced into numbers are not counted
  • The logical values TRUE and FALSE are not counted.
  • Empty cells and text are not counted

5. COUNTIF FUNCTION ()







Summary 
COUNTIF is a function to count cells that meet a single criteria. COUNTIF can be used to count cells with dates, numbers, and text that match specific criteria. The COUNTIF function supports logical operators (>,<,<>,=) and wildcards (*,?) for partial matching.
Purpose 
Count cells that match criteria
Return value 
A number representing cells counted.
Syntax 
=COUNTIF (range, criteria)
Arguments 
  • range - The range of cells to count.
  • criteria - The criteria that controls which cells should be counted.
Usage notes 
The COUNTIF function in Excel counts the number of cells in a range that match the supplied criteria
Non-numeric criteria needs to be enclosed in double quotes but numeric criteria does not:


=COUNTIF(A1:A10,100) // count cells equal to 100
=COUNTIF(A1:A10,">32") // count cells greater than 32
=COUNTIF(A1:A10,"jim") // count cells equal to "jim"
=COUNTIF(A1:A10,"<"&B1) // count cells less than value in B1
The wildcard characters ? and * can be used in criteria. A question mark matches any one character and an asterisk matches any sequence of characters.
To find a literal question mark or asterisk, use a tilde (~) in front question mark or asterisk (i.e. ~?, ~*).






















Labels:
Location: West End Mall, Janakpuri West, Janakpuri District Center, Janakpuri, Delhi, 110058, India

Comments

Post a Comment

Popular posts from this blog

DIFFERENT OPERATORS IN MS-EXCEL

                                    OPERATORS   Operators are used in formulas to execute operations on the values taken by formulas.  Excel use 4 types of operators : 1.Arithmetic Operators 2.Text Concatenation Operators  3.Comparison Operators  4.Reference Operators  www.ebeescorp.com Arithmetic Operators This operation will explained through example Example  Text Concatenation Operators   This operation will explained through example Example  Comparison Operators  To compare values you can create formulas using comparison operators. These operators return a TRUE or FALSE result depending how the formula evaluate the condition .Some common operator are as follow: Reference Operators  Reference operators enable you to combine absolute and relative references and na...
Post a Comment
Read more

COMPUTER ABBREVIATIONS & SOME INVENTORS

ABBREVIATIONS EBEESCORP www.ebeescorp.com Inventors Of Computer Hardware  (1) Key board — Herman Hollerith, first keypunch device in 1930 (2) Transistor — John Bardeen, Walter Brattain & Wiliam Shockley (1947 - 1948) (3) RAM —        An Wang and Jay Forrester (1951) (4) Trackball — Tom Cranston and Fred Longstaff (1952) (5) Hard Disk — IBM , The IBM Model 350 Disk File (1956 ) (6) Integrated Circuit — Jack Kilby & Robert Noyce (1958) (7) Computer Mouse — Douglas Engelbart (1964) (8) Laser printer — Gary Stark weather at XEROX in (1969) (9) Floppy Disk — Alan Shugart & IBM( 1970) (10) Microprocessor — Faggin, Hoff&Mazor – Intel 4004 COMPUTER TRAINING CENTER 9717717164
Post a Comment
Read more

CHARACTERISTICS OF A COMPUTER & CENTRAL PROCESSING UNIT (C.P.U)

Hello, Readers This Blog will help you understand the Characteristics of Computer & About C.P.U (Central Processing Unit ). Characteristic means Computer capabilities i.e Characteristics of Computer  1.Speed 2.Accuracy 3.Consistency 4. Data Storing Capability 5.Flexibility  A. Speed : A Computer is a very fast device .It can perform , in a few Second ,the amount of work that a human being can do in an entire year working round the clock .The speed of the computer is usually 2 to 4 GHz . A powerful computer is capable of performing  about 10 to 40 million arithmetic calculations in a second. or We can say that Computer speed is measured in   megahertz (MHz) or gigahertz (GHz). One Megahertz equals to one million ticks per second,one Gigahertz equals one billion ticks per second . B. Accuracy : The accuracy of a Computer is consistently high an the degree o accuracy of a particular task is 100% accurate.In  a every computer each and e...
Post a Comment
Read more