Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

1. Given the following set of data (it is a population) 5, 15, 2, 13, 80, 11, 20, 11, 22, 19, 11, 41, 42, 34,

image text in transcribed
1. Given the following set of data (it is a population) 5, 15, 2, 13, 80, 11, 20, 11, 22, 19, 11, 41, 42, 34, 18, 29, 11, 27 Using Excel, find the a. Mean b. Median c. Mode d. Range e. Variance of the population f. Standard deviation of the population g. The 80# percentile h. The IOR (interquartile range) Discuss whether or not an outlier exists in the data. Support your answer with mathematical evidence The probability of drawing a number higher than 23 if one number was drawn at random from the list k. The probability of drawing a number higher than 23, not putting it back, and then drawing a second number higher than 23 from the list 1. The probability of drawing a number higher than 23 GIVEN THAT an even number was drawn. Upload your Excel sheet to the final that you used for this "You must show the embedded formulas

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Intermediate Accounting Volume 2

Authors: Thomas Beechy, Joan Conrod, Elizabeth Farrell, Ingrid McLeod-Dick

6th Edition

9780071338820

Students also viewed these Mathematics questions