Descriptive Statisticsand Weighted Averages

By hand or using Excel, find the mean, median, mode, 25th percentile, 75th percentile, maximum, minimum, and range. (Estimate the percentiles when working problems by hand.)

1. Professor Ivy has the following scores on her final exams:

97 88 66 55 89 72 94 32 84 89 72 76 77

a. Find: Mean ___________(rounded to the nearest hundredth)

Median ______________

Mode ________________

25th percentile _________

75th percentile _________

b. Find: Maximum ____________

Minimum _________________

Range ____________________

2. The total points scored in the games of an NBA playoff series:

195 176 215 200 189 232 201

a. Find: Mean _______________(Round to the nearest whole number)

Median __________________

Mode ____________________

b. Find: Maximum _________________

Minimum ______________________

Range _________________________

3. a. Determine whether the following distributions are skewed right, skewed left or symmetrical.

b. Write a sentence about the meaning of the skewedness for the information shown on the graphic.

Graphic 1

4. a. Determine whether the following distributions are skewed right, skewed left or symmetrical.

b. Write a sentence about the meaning of the skewedness for the information shown on the graphic.

Graphic 2

5. a. Determine whether the following distributions are skewed right, skewed left or symmetrical.

b. Write a sentence about the meaning of the skewedness for the information shown on the graphic.

Graphic 3

6. Normally, the distribution of birth weights for newborns is symmetrical. Would you expect the distribution of birth weights of babies admitted to neo-natal intensive care units to be symmetrical, skewed left or skewed right? Why?

7. Would you expect the distribution of freshman students by age at a four year college (like Indiana University) to be symmetrical, skewed left or skewed right? Why?

8. Would the distribution of the heights of high school basketball players to be symmetrical, skewed left or skewed right? Why?

Weighted Averages

9. PTK is having a bake sale. They have 30 cookies selling for $0.75 each, 24 cupcakes selling for $1.00 each and 15 brownies selling for $1.50 each. What is the average price of the items sold?

10. On the varsity baseball team, there are 9 eighteen-year-olds, 7 seventeen-year-olds, 5 sixteen-year-olds and 2 fifteen-year-olds. What is the average age of the players on the team?

11. Calculate the grade point average.

An “A” is considered 4.0, a “B” is 3.0, a “C” is 2.0, a “D” is 1.0, and an “F” is 0. If in your first semester, you received the following grades, what would your grade point average be? (round to the nearest tenth.)

Grade Point Hours Grade

English 3 C

Chemistry 4 B

Communications 3 A

Student Seminar 1 A

12. Calculate the GPA for the following student.

An “A” is considered 4.0, a “B” is 3.0, a “C” is 2.0, a “D” is 1.0, and an “F” is 0. (Round to the nearest tenth.)

Grade Point Hours Grade

Math 3 A

Chemistry 4 C

Biology 3 B

Computers 2 D

PE 1 A

13. Calculate the final course grade.

A student’s final grade in MATH 123 is determined by the following weights:

Weight Average

Homework 10% 80

Quizzes 10% 82

Projects 25% 78

Exam 1 20% 82

Exam 2 20% 84

Exam 3 15% 65

a. What is the final course grade for this MATH 123 student? (Round to the nearest tenth.)

b. What letter grade would this student earn based on the grading scale for MATH 123? (Hint: Grading scale is listed in the syllabus and course overview.)

c. What is the highest course grade he could earn if he improved his homework grade? (Rounded to the nearest tenth.) Which would result in what letter grade with no rounding up?

14. Calculate the final grade.

A student’s final grade in chemistryis determined by the following weights:

Lab report 15%

Quizzes 5%

Exam 1 20%

Exam 2 20%

Research Paper 15%

Final exam 25%

Use the following grades for a particular student:

Lab report 75 80 70 75 85 69 90 75

Quizzes 85 60 70 0 75 80 80 80

Exam 1 80

Exam 2 70

Research paper 85

Final exam 75

a. What is the average lab report grade for this student? (Rounded to the nearest tenth).

b. What is the average quiz score? (Rounded to the nearest tenth).

c. What is the final grade for this student? (Rounded to the nearest tenth).

15. The Excel spreadsheet provided shows the number of Teens aged 16-19 not attending school and not working in 2013. Source http://datacenter.kidscount.org/data/tables/

a. Download Excel spreadsheet with data. Use the Excel formulas and functions to find the Mean, Median, Mode, Maximum, Minimum, Range for the number of 16-19 year olds not attending/working in 2013.

b. Use the same Excel spreadsheet from 15a. Use the Excel formulas and functions to find the Mean, Median, Mode, Maximum, Minimum, Range for the percent of 16-19 year olds not attending/working in 2013.

c. Write a paragraph about your findings regarding teens not attending school and not working. When comparing the states is it better to compare the number or the percent? Why? How does the state of Indiana compare to the surrounding states?

1

a

Excel was used to make all computations for parts a and b. Please see the attached Excel file for the computations.

Mean 76

Median 77

Mode 89

25th percentile 69

75th percentile 89

b

Maximum 97

Minimum 32

Range 65

2

a

Excel was used to make all computations for parts a and b. Please see the attached Excel file for the computations.

Mean 201

Median 200

Mode none

b

Maximum 232

Minimum 176

Range 56

3

a

The distribution in Graphic 1 is skewed left.

b

The profits were low in 1975, then increase as the years increase, and are highest in the year 2010.

4

a

The distribution is skewed right.

b

A high percentage of men aged 16-24 spend at least one hour per week participating in sports or exercise; this percentage steadily decreases as the men age, and is lowest in men aged over 75.

5

a

The distribution is symmetrical.

b

The turn around time is …

Computations have been made in Excel where appropriate. The Excel file contains the formulas and functions used. The Word file contains the solutions for each problem.