- supports the statement that says that the average person
is
*better*able to remember real words than nonsense words.**Eliminate people who contradict the clue and remember nonsense words at least as well as real words**. Choose a color for this clue and highlight any eliminated rows in that color. You'll eliminate 5 people.

- has a golden mean of (1+sqrt(5))/2 ~ 1.618,
within a .200 margin of error,
embedded in the
forearm to hand
ratio.

-What are lower and upper boundaries for the interval rounded to 3 decimal places (Hint: use 1.618 and the margin of error)?

lower boundary: _______________ upper boundary: _______________

-Which column letter represents forearm? _______________ hand? _______________

-If we wanted to look at the ratio of columns J and K in Excel for person 2, we would use the Excel cell referencing command =J2/K2. Using Excel cell referencing, what is the Excel formula for forearm/hand for the first person in row 2 (don't forget the equal sign and use the columns you listed above)?

_______________ Type this into K2 and hit return. Go back to that box, go to the bottom right until you see the symbol change, click and fill down the column for the forearm to hand ratios.

-Eliminate those remaining who*contradict*the statement and have a ratio**outside the interval**since the suspect is within. Choose a clue 2 color and highlight any new eliminations in Excel.**Eliminate anyone (who hasn't already been eliminated) less than the lower boundary. Eliminate anyone greater than the upper boundary.**

- falls within the middle 50% of the class on
the boxplot of the
distance from home.

-First, as a review,**compute in Excel the 5-number summary in some empty boxes, using the following commands, and then roughly sketch the boxplot by-hand**by creating a reasonable scale for the axis. Be sure that your commands match these:**Excel work**:__By-hand sketch:__

Q_{4}or maximum: =quartile(c2:c32,4) _______________

Q_{3}: =quartile(c2:c32,3) _______________

Q_{2}or median: =quartile(c2:c32,2) _______________

Q_{1}: =quartile(c2:c32,1) _______________

Q_{0}or minimum: =quartile(c2:c32,0) _______________

-Now eliminate rows who contradict the statement and who fall strictly outside the box borders - i.e.**eliminate those who are strictly below Q**. Choose a different color and highlight any new eliminations in Excel._{1}or strictly above Q_{3}

- hits the 2nd quartile (the median)
"on the head" for the number of competitors of
the family bathroom.

-Which column does the clue apply to? _______________

-Use Excel cell referencing. What is the Excel command for Q_{2}or the median? (don't forget the equal sign) _______________

-After you execute the command in Excel, what is Q_{2}of that column: ______

-Next,**eliminate those who are different than Q**_{2}

-You should have 3 people remaining at this point. Write down the number of each row that is left.

_______ _______ _______

- has a
*y*-value within 1cm of the best fit line for "does armspan predict height."

-What is the equation of the best fit line from #6 on the correlation lab (include all the (mis)measurements)? If you don't have your lab, you'll need to reconstruct this in Excel and you can review the instructions for random number and armspan and apply them to armspan and height.

*y*=_____________________________

-Compute the*predicted line value of height*by plugging in the*armspan*(the*x*value) of ONLY your remaining suspects into the equation of the line to solve for the*y*value height.**Show work**. Also write down the actual height of each person from Excel.

Predicted height*y*=_____________________________ = ______________. Actual height=_______

Predicted height*y*=_____________________________ = ______________. Actual height=_______

Predicted height*y*=_____________________________ = ______________. Actual height=_______

-Compare the predicted line height value with the actual height and**eliminate the people whose difference is greater than 1cm**

-Which row is the "winner" _______

-Does the "winner" drag the line up or down? I.e. is their actual height value above or below the predicted line value?

Circle one: up down exactly on the line