0
Using the cells A1 to A15, the following functions can be used for what you want:
To get the highest value you can use either of two functions, though we most commonly use the first of these:
=MAX(A1:A15)
=LARGE(A1:A15,1)
The LARGE function can not only get the highest value, but also the second highest or third highest etc., by changing the 1 at the end to 2 or 3 etc.
To get the lowest you can use either of these two functions, where SMALL works similar to LARGE:
=MIN(A1:A15)
=SMALL(A1:A15,1)
To get an average you use the AVERAGE function:
=AVERAGE(A1:A15)
You could also get an average in this way, by totalling the values and divided by the amount of values by counting them, but it would be rarely used:
=Sum(A1:A15)/Count(A1:A15)
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
How do you add the lowest number and highest number to get an average?
you get the lowerst and add it to the highest and there is your average
What will be the resultant if third digit of the lowest number is multiplied with the second digit of the highest number?
The answer will depend on what the highest and lowest numbers are!The answer will depend on what the highest and lowest numbers are!The answer will depend on what the highest and lowest numbers are!The answer will depend on what the highest and lowest numbers are!
What are the highest number and lowest number on the pH scale?
1 is the lowest 14 is the highest and 7 is the middle
What does average mean in math form?
Average - the central tendency of a data set is a measure of the "middle" or "expected" value of the data set (mean, median, mode) Layman's terms - the average of a math problem is the middle number, usually found by taking the highest number and subtracting the lowest number, or taking the highest and lowest numbers and finding the middle number.
Is a range the highest number and the lowest number divided by two?
no, it is the highest number subtracted by the lowest number ex: 4,5,8,10,17 the range would be 13
What is the highest and lowest factor?
Of any given positive number, the highest factor is the number itself, and the lowest factor is 1.
What is the highest and the lowest four-digit numbers?
Lowest four-digit number: 1000 Highest four-digit number: 9999
Is the mean an the average the same thing?
no, the mean is the number that appears in the middle when placed from lowest to highest, the average is the sum of the numbers divided by the amount of numbers.
Does range mean the highest number subtracted by the lowest number?
Yes. Range is when you subtract the lowest number by the highest.
How do you find the median when theres four numbers?
When sorted lowest to highest (or highest to lowest) the median is (2nd number + 3rd number)/2
When you subtract the highest data point from the lowest data point?
you just take the highest number in the data and the lowest number in the data. then you get the range.
What are the lowest prime number and the highest prime number between 1 and 100?
The lowest prime number is 2. The highest prime number less than 100 is 97.
