Statistics open attachments For this assignment, use the data you created in your W1 Midweek Assignment. Using Microsoft Excel and following the instructi

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

Using Microsoft Excel and following the instructi

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

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

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.

Age

Height

Upper Extremes

Lower Extremes

Upper Extremes

Lower Extremes

5%

2.50%

5%

2.50%

5%

2.50%

5%

2.50%

z =        1.645    or higher

z =        1.96       or higher

z=            -1.645    or lower

z=            -1.96    or lower

z =        1.645    or higher

z =        1.96       or higher

z=            -1.645    or lower

z=            -1.96    or lower

Participant IDs for those with z-scores that fall into these extremes go in the boxes below

 

 

 

 

 

 

 

 

Submission Details:

Save the Microsoft Excel worksheet

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