Statistics Detective Review
Work in groups. Use the
clues below and effective reasoning skills in order
to identify the "odd person out" in our
class data set as you review.
To mark off eliminated people on the computer, be sure that
View/Toolbar/Formatting is checked. You can use the fill-in feature
to eliminate suspects by
clicking on the row number
(in grey) and then the paint can
in the formatting toolbar. You may change fill-in colors by clicking on
the arrowhead just to the right of the paint can.
In this way, your document will show
suspects eliminated using the clues as painted rows, where each clue
represents a different color:
The suspect...
- supports the statement that says that the average person
is better able to remember real words than nonsense words.
Choose a color for this clue and highlight the eliminated rows in that color
[people who remember nonsense words at least as well as real words].
What row numbers did you eliminate?
How many suspects did you eliminate?
- falls inside the middle 50% of the class on
the boxplot of the
distance from home
First
sketch the boxplot (use quartile commands
in column P in Excel to help you =quartile(d2:d31,4), =quartile(d2:d31,3),
=quartile(d2:d31,2), =quartile(d2:d31,1), =quartile(d2:d31,0)).
Which rows that were not already removed in clue 1 can you now eliminate
(rows who contradict the statement and who fall strictly above or below
the box borders)
How many additional suspects can
you now eliminate?
Choose a different
color for this clue and highlight the new eliminations in that color.
- falls within a small decimal range that includes
numbers between .2 above and .2 below the golden mean
[(1+sqrt(5))/2 ~ 1.618]
embedded in the
forearm to hand
ratio.
In Q2 type =M2/L2 and hit return.
Then, go back up to that box, go to the bottom
right until you see the symbol that resembles a square with
arrowheads on the top left and bottom right corners,
click and pull the mouse down to fill down the column for the forearm to hand
ratios.
Which new rows can you eliminate? (those
who contradict the statement and have a
ratio greater than ~1.818 or less than ~1.418).
How many additional suspects have been eliminated?
Choose a different color and highlight any new eliminations.
- hits the 1st or 2nd quartile (q1 or q2=median)
"on the head" for the number of competitors of
the family bathroom.
Which column does the clue apply to?
What is q1 and q2
of that column?
Which new rows can you eliminate (those who contradict the clue)?
How many additional suspects have been eliminated?
Choose a different color and highlight any new eliminations.
- pulls
the regression line for "does armspan predict height" up by less than
3 cm:
What is the equation of the best fit line from the regression lab
(include all the measurements)?
Compute the predicted value of height by plugging in the
armspan of your remaining
suspects into the equation of the line. Then compare the predicted height with the actual height - only one of them
satisfies this clue. Show work