Contenido del Curso
Google Spreadsheets
Google Spreadsheets
Statistical Functions
The MIN function returns the smallest value in a specified range of data. This is useful for identifying the lowest value in datasets like grades, sales, or other numerical records.
Syntax
MIN(value1, value2,...value2, ...)
- value1 - The first value or range to consider when calculating the minimum.
- value2, ... - OPTIONALOPTIONAL Additional values or ranges to include in the calculation.
Finding Maximum
The MAX function returns the largest value in a range. It is particularly useful for analyzing maximum results, such as the highest sales or top grades.
Syntax
MAX(value1, value2,...value2, ...)
- value1 - The first value or range to include when calculating the maximum.
- value2, ... - OPTIONALOPTIONAL Additional values or ranges to include in the calculation.
Examples for Min and Max
| Value (A) | Formula | Result | Comment | |
|---|---|---|---|---|
| 6 | MIN(A:A) | -5 | Returns the smallest value in the range. In this case, the minimum value in column A is -5. | |
| 0 | MIN(A2:A6) | -3 | Returns the smallest value in the range. Here, the minimum value is -3. | |
| -3 | MIN(A2:A6, -4) | -4 | Returns the smallest value between the range A2:A6 and the additional value -4. The result is -4, as it is the smallest. | |
| 2 | MAX(A:A) | 8 | Returns the largest value in the range. The maximum value in column A is 8. | |
| -1 | MAX(A2:A6) | 6 | Returns the largest value in the range. Here, the maximum value is 6. | |
| MAX(A2:A6, 7) | 7 | Returns the largest value between the range A2:A6 and the additional value 7. The result is 7, as it is the largest. | ||
| 8 | ||||
| -5 |
Finding Average
The AVERAGE function calculates the arithmetic mean of a specified range of data. It is useful for determining the average result for a group of numbers, like student scores or average sales.
Syntax
AVERAGE(value1, value2,...value2, ...)
- value1 - The first value or range to consider when calculating the average.
- value2, ... - OPTIONALOPTIONAL Additional values or ranges to include in the calculation.
Finding Median
The MEDIAN function returns the median — the middle value in an ordered dataset. For an even number of data points, the median is the average of the two central elements. This function is helpful for excluding the effect of outliers on averages.
Syntax
MEDIAN(value1, value2,...value2, ...)
- value1 - The first value or range to consider when calculating the median.
- value2, ... - OPTIONALOPTIONAL Additional values or ranges to include in the calculation.
Finding Count
The COUNT function returns the number of numeric values in a specified range. It ignores text and empty cells, counting only cells with numbers. This is useful for quickly determining the count of numeric data in a dataset.
Syntax
COUNT(value1, value2,...value2, ...)
- value1 - The first value or range to consider when counting.
- value2, ... - OPTIONALOPTIONAL Additional values or ranges to include in the count.
Examples for AVERAGE, MEDIAN, and COUNT
| Value (E) | Formula | Result | Comment | |
|---|---|---|---|---|
| FALSE | AVERAGE(E:E) | 4.8 | When calculating AVERAGE, logical values TRUE and FALSE are treated as 1 and 0, respectively. The average of the entire column E is 4.8. | |
| 5 | AVERAGE(E3:E5) | 1.667 | The average of the range E3:E5 is calculated as the sum of values (5 + (-3) + 3) divided by the count of elements (3). The result is 1.666.... | |
| -3 | AVERAGE(E7:E8) | 9.5 | The average of the range E7:E8 is calculated as (11 + 8) / 2. The result is 9.5. | |
| 3 | AVERAGE(E3:E6, E7:E9) | 4.8 | The average is calculated for the combined range E3:E6 and E7:E9. The result is 4.8. | |
| some text | MEDIAN(E:E) | 5 | The MEDIAN function ignores text and logical values, calculating the median of all numeric values in column E. The median is 5. | |
| 11 | MEDIAN(E3:E5,E7:E8, -8, -6, 2, 7, 15) | 4 | The median is calculated for all values in the specified ranges and additional numbers -8, -6, 2, 7, 15. The result is 4. | |
| 8 | MEDIAN(E3:E6, E7:E9) | 5 | The median for the combined range E3:E6 and E7:E9 is 5. | |
| TRUE | COUNT(E2:E10) | 5 | The COUNT function counts only numeric values. In the range E2:E10, there are 5 such values. | |
| FALSE | COUNT(E2:E10, 5, "text", "") | 6 | In addition to numbers in the range E2:E10, the value 5 is included. Other arguments, such as text and empty cells, are ignored. The result is 6. |
¡Gracias por tus comentarios!
