The AVERAGE() function calculates the arithmetic mean of data points, while the MEDIAN() function calculates the middle value of a range of data points.