Final answer:
To calculate the average, add up all the values and divide by the total number. The standard deviation measures the spread of the data. To find the median, arrange the values in order and find the middle value. To compute the range, subtract the lowest value from the highest value.
Step-by-step explanation:
a. To calculate the average, you need to add up all the values in cells B77 to B81 and then divide the sum by the total number of values. For example, if the values are 5, 8, 10, 12, and 15, the average would be (5 + 8 + 10 + 12 + 15) / 5 = 10.
b. To determine the standard deviation, you need to calculate the square root of the variance. The variance is the average of the squared differences between each value and the mean. It measures the spread of the data. You can use a formula or a calculator to calculate the standard deviation.
c. To find the median, you need to arrange the values in ascending order and then find the middle value. If there is an even number of values, the median is the average of the two middle values. For example, if the values are 5, 8, 10, 12, and 15, the median would be 10.
d. To compute the range, subtract the lowest value from the highest value. For example, if the values are 5, 8, 10, 12, and 15, the range would be 15 - 5 = 10.