Distribution Assignment – Homework Experts

Open a new Excel file and use the data set from the Distribution Assignment. You will plug the raw score data into your new Excel file.

Complete calculation 1: Convert the raw scores to standardized z-scores. Determine which z-score corresponds to the top 15% of the class scores.
Complete calculation 2: Follow the posted instructions for identifying population percentage of high/low income groups.
Complete a write-up in Word describing what you found for calculations 1 & 2. This should be in APA format with a title page. This should be no more than one paragraph. Include a pasted image from your Google search (try to make the resolution clear) at the top of the page before the writeup.

Calculation 1
You are the advisor for Phi Alpha, the social work honors society, and a criterion for acceptance is assuring that students have a GPA in the top 15%. The mean GPA for social work students is 3.0, with a standard deviation of 0.25. Of the following students GPAs, which would meet the criteria for acceptance?

1. 2.92

2. 3.00

3. 3.11

4. 3.16

5. 2.89

6. 3.25

7. 3.42

8. 3.16

9. 3.50

10. 3.69

Think critically on how to accomplish this.

Calculation 2:

Using an internet search engine, try to find some graphed images by typing “median U.S. household income graph” or “U.S. income distribution graph.”

You should be able to tell what percent of the population is in the highest and lowest income groups. Even if the data are presented as bar charts, try to fit the data (in your mind) to a data distribution model.

Complete a write-up describing the distribution and discuss what you see (and what it means for the data) in APA format. This should be no more than one paragraph. Include a pasted image (try to make the resolution clear) at the top of the page before the writeup. Complete this in a word document. Include a title page.