A data analyst is working with a dataset of customer ages in a Microsoft Excel worksheet. To summarize the data, the analyst needs to find the central tendency by calculating the arithmetic mean of the ages. Which function should be used to accomplish this task?
AVERAGEA
MEDIAN
SUM
AVERAGE
AVERAGE computes the arithmetic mean by adding the values and dividing the sum by the total number of values.
SUM only adds the values without calculating a mean.
MEDIAN returns the middle value in a sorted list and does not calculate a mean.
AVERAGEA handles cells differently, including text or logical values (evaluating text as 0), which can alter the result from a pure arithmetic mean of numbers.
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
All IT & Cybersecurity Package plans include the following perks and exams .
Our pricing is simple. Full access to all certifications and exams in each package, for one price.
As many practice tests for as many topics as you want.
Use study mode non-stop, no limits.
Access to our AI assistant, Bash, trained to help you pass your exam.
Track your scores over time in study mode and report cards.
See how you improve over time, and where you need to focus.
Access our store with even bigger discounts than before.
Unlimited access to all performance questions and be prepared for the real thing.
All IT & Cybersecurity Package plans include unlimited access to the following study materials.
Create an account or sign in to access our study materials.