USING Z SCORE For this assignment, use the data you created in your W1 Midweek Assignment (ATTACHED) Using Microsoft Excel and following the instructions

Click here to Order a Custom answer to this Question from our writers. It’s fast and plagiarism-free.

USING 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. Sheet1

sex (Male=0, Female=1)

Year in college= (1= freshman, 2=sophomore, 3= junior, 4= senior

Subject ID Number Age Sex Height Year in college

S1 18 0 67.2 1

S2 18 0 66.9 1

S3 20 0 67.5 1

S4 18 0 66.8 1

S5 19 0 67.3 1

S6 20 1 63.4 1

S7 19 1 63.2 1

S8 18 1 62.8 1

S9 18 1 63.6 1

S10 21 1 63 1

S11 19 0 67.8 2

S12 20 0 68 2

S13 20 0 68.1 2

S14 21 0 67.6 2

S15 19 0 67.9 2

S16 20 1 64 2

S17 19 1 63.9 2

S18 20 1 64.2 2

S19 19 1 64.3 2

S20 20 1 63.8 2

S21 22 0 68.3 3

S22 21 0 68.2 3

S23 20 0 68.5 3

S24 20 0 68 3

S25 22 0 68.1 3

S26 20 1 63.8 3

S27 21 1 63.6 3

S28 21 1 63.9 3

S29 20 1 64 3

S30 21 1 64.1 3

S31 22 0 69 4

S32 23 0 69.1 4

S33 23 0 69.3 4

S34 21 0 68.8 4

S35 21 0 69.4 4

S36 22 1 64.3 4

S37 21 1 65 4

S38 21 1 64.8 4

S39 23 1 64.3 4

S40 22 1 64.7 4

Place your order now for a similar assignment and have exceptional work written by one of our experts, guaranteeing you an A result.

Need an Essay Written?

This sample is available to anyone. If you want a unique paper order it from one of our professional writers.

Get help with your academic paper right away

Quality & Timely Delivery

Free Editing & Plagiarism Check

Security, Privacy & Confidentiality