- 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. Keep track of the elimination color.

- 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?

lower boundary: _______________ upper boundary: _______________

-Which column letter represents forearm? _______________ hand? _______________

-Using cell referencing, what is the Excel formula for forearm/hand for the first person in row 2 (don't forget the equal sign)?

_______________ Type this into O2 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. Keep track of the elimination color.**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,**sketch the boxplot by-hand**after you type in quartile commands in Excel to give you the 5-number summary. Set a reasonable scale for the axis:

=quartile(c2:c61,4) _________________Sketch:__

=quartile(c2:c61,3) _______________

=quartile(c2:c61,2) _______________

=quartile(c2:c61,1) _______________

=quartile(c2:c61,0) _______________

Now eliminate rows who contradict the statement and who fall strictly outside the box borders - ie**eliminate those who are strictly below Q**_{1}or strictly above Q_{3}

Choose a different color and highlight any new eliminations in Excel.

- hits the 1st quartile
"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_{1}? _______________

-What is Q_{1}of that column: ______**eliminate those who are different than Q**_{1}

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

_______ _______ _______

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

-What is the equation of the best fit line from the regression lab (include all the (mis)measurements)? If you don't have your lab, you'll need to reconstruct this.

_____________________________

-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.**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 4cm**

-Which row is the "winner" _______

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

_______