Statistics Detective Review


Goal: Investigate real-world data and interpret key features.
Goal: Utilize technology to adapt or build and use mathematical formulas that include cell referencing to answer real-world questions and interpret results
Instructions: 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 or Ribbon is checked. You can use the fill-in feature to eliminate suspects by clicking on the row number and then the paint can. In this way, your document will show suspects eliminated using the clues as painted rows, where each color represents a different clue. The suspect...
  1. 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.

  2. 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.

  3. 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 Q1 or strictly above Q3
    Choose a different color and highlight any new eliminations in Excel.
  4. 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 Q1? _______________

    -What is Q1 of that column: ______
    eliminate those who are different than Q1
    -You should have 3 people remaining at this point. Write down the number of each row that is left.

    _______         _______         _______

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