week 3 midweek assignment for lab

/in /by

Due March 5 at 11:59 PM

z-Score

For this assignment, use the data you created in your W1 Midweek Assignment.

Don't use plagiarized sources. Get Your Custom Essay on
week 3 midweek assignment for lab
Just from $15/Page
Order Essay

Using Microsoft Excel and following the instructions given in your lecture, convert each subject’s age and height into a z-score.

Using the z-score of ±1.645 for the 5 percent cutoff and the z-score of ±1.96 for the 2.5 percent in the tail, identify the subject identification (ID) number for subjects who fall at or above the cutoff for the upper 2.5 percent and 5 percent of the scores and those who are at or below the lower 2.5 percent and 5 percent of the scores. Do this by comparing each participant’s z-score with the appropriate critical value (1.645, 1.96, -1.645, -1.96).

To fall into the upper tail of 5% (the 95th percentile), a participant’s z-score would need to be equal to or greater than 1.645. To fall into the upper tail of 2.5% (the 97.5th percentile), the z-score would need to be equal to or greater than 1.96. For the tails at the lower end, you would look for z-scores of -1.645 or lower (5%) or -1.96 or lower (2.5%)

Using the following table, identify the subject ID numbers in the tails for the appropriate cutoffs in an APA formatted Microsoft Word document.

  • Save the Microsoft Excel worksheet.
  • Name your Microsoft Excel worksheet SU_PSY2008_W3_A_Council_A
  • Identify the subject ID numbers for appropriate cutoffs in an APA formatted Microsoft Word document.
  • Name your document SU_PSY2008_W3_A_Council_A.