Question
List 10 numbers in A1 to A10 on an excel worksheet from Smallest to Largest. In cell A11 type =average(a1:a10) and hit enter Note this
List 10 numbers in A1 to A10 on an excel worksheet from Smallest to Largest.
In cell A11 type =average(a1:a10) and hit enter Note this is the mean.
In Cell A12 type=mode(a1:a10) and hit enter.
In Cell A13 type =median(a1:a10) and hit enter
In Cell A14 type =(a1+a10)/2 and hit enter. Note this is the midrange
In Cell A15 type=stdev.s(a1:a10) and hit enter. Note this is the sample standard deviation.
In Cell A16 type =stdev.p(a1:a10)and hit enter. Note this is the population standard deviation.
In Cell A17 type=var.s(a1:a10)and hit enter. Note this is the sample variance.
In cell A18 type =var.p(a1:a10)and hit enter. Note this is the population variance.
On your Discussion post list your 10 numbers in order from smallest to largest.
Label each of these mean, mode, median, midrange, sample standard deviation, population standard deviation, sample variance, and population variance. Tell what you got for each.
If your excel is not working then you can do these on a calculator.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started