Question
Given the following set of data (it is a population): 4, 22, 12, 19, 95, 12, 27, 16, 26, 19, 12, 39, 44, 37, 18,
Given the following set of data (it is a population):
4, 22, 12, 19, 95, 12, 27, 16, 26, 19, 12, 39, 44, 37, 18, 28, 12, 27, 15, 16
Using Excel's embedded formulas and UPLOADING YOUR EXCEL SHEET with embedded calculations to demonstrate your skill at using computer technology for statistical analysis in a business setting, find the:
a. Mean - 25
b. Median - 19
c. Mode - 12
d. Range - 91
e. Variance of the population - 356.4
f. Standard deviation of the population - 18.87856
g. The 30thpercentile -
h. The IQR (interquartile range)
i. Discuss whether or not an outlier exists in the data. Support your answer with mathematical evidence.
j. The probability of drawing a number higher than 20 if one number was drawn at random from the list
k. The probability of drawing a number higher than 20, not putting it back, and then drawing a second number higher than 20 from the list
l. The probability of drawing a number higher than 20 GIVEN THAT an even number was drawn.
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