Problem 1
Answers:
Mean = 51.68
Median = 51
There are 100 values
IQR = 54
Explanation:
The values are found in the table. The IQR (interquartile range) is the difference of Q3 and Q1.
IQR = Q3 - Q1 = 77 - 23 = 54
Problem 2
C) Mean is greater than the median
Explanation:
The main clump of values is pretty much between 80 and 110. The other values can be considered in the right tail, which is pulled out more compared to the left tail. We consider this a right skewed distribution, and that indicates the mean is larger than the median. The tails always pull on the mean toward it. A very long way to confirm this answer is to manually enter the values into a calculator and compute the mean and median, but that would be tedious busy work in my opinion.
Problem 3
Answers: A) Mean and median are the same value
Explanation:
This data set is uniform and symmetric about the center, so the mean = median.
Problem 4
Choice A)
=MIN(A1:A10)
Explanation:
We use the MIN function, and we select everything from cell A1 to A10. The colon tells us to select everything between those endpoints and including those endpoints. If we wrote =MIN(A1,A10), then we would only select the two endpoints only and nothing in between, which isn't what we want.
Problem 5
Choice D
=QUARTILE(A1:A10, 3)
Explanation:
The QUARTILE function is what we'll use. It has two inputs. The first is the data itself, which is the values from A1 to A10. The second input entry is the quartile we want, which is the third quartile. So we'll use "3" in the second slot as choice D indicates.
As far as I know, excel doesn't have an "upperquartile" function and neither does any other spreadsheet program (I could be mistaken however). Choice B describes finding the first quartile on the items from A1 to A10.
Choice C is nonsense because cell B1 isn't shown, that item isn't in the proper column. If you want to select another column, you need to tack that onto the end rather at the beginning. Also, and this is very important, the selection input must be rectangular. So if you wanted to include column B, you would have to start at A1 and end at B10. The input would be A1:B10. Saying A1:B1 would produce an error.
