image taken from https://www.mathsisfun.com/data/mean-deviation.html
Mean Absolute Deviation (MAD) is how far, on average, all data values are from the middle.
To find the MAD, you can follow 3 easy steps:
- Find the mean of the values
- Find the distance of each value from that mean (subtract the mean from each value, ignore minus signs which is also the absolute value)
- Then find the mean of those distances
For this Math Mini Spark, you’ll be finding the MAD on a spreadsheet. Follow the steps below.
Step 1: Make a Copy of this Spreadsheet by clicking the link: https://docs.google.com/spreadsheets/d/1ndcgCZ1EeVcKausxtkmBkONVfCeilbQNE6ukdUCWYk8/copy
Step 2: Watch the video below and complete the steps shown in the video on your own spreadsheet.
NOTE: This mini-spark can be used as 1 spreadsheet lesson for the Spreadsheet Superstar Badge.