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.

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

A First Course in Differential Equations with Modeling Applications

Authors: Dennis G. Zill

11th edition

1305965728, 978-1305965720

More Books

Students also viewed these Mathematics questions

Question

What six columns should a communications matrix contain?

Answered: 1 week ago