Question

Use excel's AVEDEV function to find the mean absolute deviation of these five numbers 11,24,32,37,45

Answer 1

To find the mean absolute deviation using Excel, input the numbers into a column, select a cell for the output, and use the =AVEDEV(range) function. The result will be the mean absolute deviation for your data set.

Step-by-step explanation:

To calculate the mean absolute deviation (MAD) of the given numbers (11, 24, 32, 37, 45) using Excel, you can utilize the AVEDEV function. Here's a step-by-step guide to do that:

1. Enter the numbers into a single column (e.g., A1:A5) in an Excel spreadsheet.
2. Click on a cell where you want the result for the MAD to be displayed.
3. Type the formula: =AVEDEV(A1:A5) into the cell and press Enter.
4. The cell will now display the mean absolute deviation of the numbers in the range A1 to A5.

The AVEDEV function in Excel calculates the average of the absolute deviations of data points from their mean. It is a measure of the dispersion of a set of data points.