Explore BrainMass

Explore BrainMass

    Descriptive Statistics and Weighted Averages

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Descriptive Statistics and 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 chemistry is 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? 

    © BrainMass Inc. brainmass.com June 4, 2020, 5:30 am ad1c9bdddf
    https://brainmass.com/statistics/descriptive-statistics/descriptive-statistics-weighted-averages-642825

    Attachments

    Solution Preview

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

    Solution Summary

    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.

    $2.19

    ADVERTISEMENT