Recall that an underlined phrase means that it is a link off of the web page itself. This page can be accessed from the class highlights page. Take our your mean, median and mode lab in addition to your regression lab. 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.

- does NOT hit the 1st quartile (q1)
"on the head" for the number of competitors of
the family bathroom. The general command for the 1st quartile of data
in the sth column is =quartile(s2:s25,1). Do not re-order the column - Excel
doesn't need that for the command to work.

Which column does the clue apply to?

What is q1 of that column? (Replace s in the quartile command with the column you chose)

Describe the kinds of numbers that can be eliminated (the people who contradict the statement and hence do hit the quartile).

Choose a color for this clue and highlight the rows in that color. How many suspects can you eliminate?

- does fall within the middle 50% of the class on
the boxplot of the
distance from home

Sketch the boxplot here (use quartile commands in Excel to help you =quartile(d2:d25,0), =quartile(d2:d25,1),...).

Describe the kinds of distances that can be eliminated (people who contradict the statement).

How many additional suspects can you eliminate?

Choose a different color for this clue and highlight the rows in that color. How many total people have now been eliminated?

- has a golden mean of (1+sqrt(5))/2 embedded in the
forearm to hand
ratio within a 0.2 decimal range.

Compute the golden mean in decimal form and write it down here. You may wish to review the related Heart of Mathematics reading.

Describe the kinds of numbers that can be eliminated (those who contradict the statement).

In Excel, compute the forearm to hand ratios of the remaining suspects (in the second row of an empty column, 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 (as we did in the golden mean lab). Now use the clue to eliminate additional people.

How many additional suspects have been eliminated?

Choose a third color and highlight the new eliminations. How many total people have now been eliminated?

- helps the statistics that say that people
are better able to remember real words than nonsense words.

How many additional suspects have been eliminated?

- hits the median of head circumference "on the head."

How many people can you eliminate?

- hurst the statistics that say that women perform more poorly on the
Timed MRT test (ie this could be a woman who performed above the men's average
on that test, or a man that performed below the woman's average on that test)

How many people can you eliminate?

- pulls
the regression line for "does armspan predict height" down
since the actual height value corresponding to the actual armspan is
below the predicted value for the actual armspan given by plugging into
the equation of the best fit line.

What is the equation of the best fit line (use the one from your last lab)?

Compute the predicted value for the actual armspan for your suspect and show work to give evidence that your suspect does indeed satisfy this clue.

Gender______ Armspan______ Height______ Foot Length______ Head Circ______ Hand______

Forearm______ Class Yr_________________ Siblings______ Home_______

Major_______________________ Minute______ RealWds______ NonsenseWds______

Timed MRT______ Untimed MRT______

Next read through the final project guidelines under the due date in December, from the main web page.

Then read through the study guide for Thursday's test and write down any questions you have to ask Dr. Sarah on Tuesday.

Choose something to work on - Project 5 due tomorrow, review or the WebCT quiz for Thursday, the personal reflection due next Tuesday, or the final project. review, the WebCT quiz, Project 5 due tomorrow, the personal reflection due next Tuesday.