Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linear Algebra and Its Applications

Authors: Gilbert Strang

4th edition

30105678, 30105676, 978-0030105678

More Books

Students also viewed these Mathematics questions

Question

What is the difference between persistence and self-determination?

Answered: 1 week ago