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

For this assignment, use the data you created in your W1 Midweek Assignment (ATTACHED)

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.

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Math homework help

Do not let math assignments discourage you from trying your best. One of our math experts can help you with math homework online. Our math tutors can help you with any level of algebra, calculus, or geometry. Ask your question to get the support you need 24/7.

Order Over WhatsApp Place an Order Online

Do you have an upcoming essay or assignment due?

All of our assignments are originally produced, unique, and free of plagiarism.

If yes Order Similar Paper