Question
Week 1 Assignment (80 points) Think of the roster of your favorite NBA basketball star or team. Are the players tall, short, in between? We
Week 1 Assignment (80 points)
Think of the roster of your favorite NBA basketball star or team. Are the players tall, short, in between?
We will use the heights of famous NBA basketball players found at https://bleacherreport.com/articles/147714-whos-the-best-nba-player-ever-to-measure-66 and other places.
You may use Excel for this assignment.
1.(10 points) The height of famous players are recorded below. Fill out the last column. Make sure to list the given height in inches.
Player Name
Height in feet, inches
Height (in inches)
James, LeBron
6' 8"
Russell, Bill
6' 10"
Bird, Larry
6'9"
Curry, Stephen
6'3"
Durant, Kevin
6'9"
Johnson, Joe
6'7"
Jordan, Michael
6'6"
Ewing, Patrick
7'
English, Alex
6'7"
Malone, Karl
6'9"
Erving, Julius
6'7"
Olajuwan, Hakeem
7'
Duncan, Tim
6'11"
Gervin, George
6'7"
Magic Johnson
6'9"
Drexler, Clyde
6'7"
2.(7 points) Find the minimum, Q1, median, Q3, maximum, mean, and mode for the heights of the players you listed in Question 1. If needed, round any answers to one decimal place.
MIN:
Q1:
MEDIAN:
Q3: (to 2 decimal places)
MAXIMUM:
MEAN to one decimal place :
MODE:
3.(7 points) Find the minimum, Q1, median, Q3, maximum, mean, and mode for the heights of the players you listed in Question 1 except for the tallest person on your list of data (i.e. recalculate without the tallest person in your data set. If there are two or more people with the tallest height, remove all of them from your data set).
MIN:
Q1:
MEDIAN: to one decimal place
Q3:
MAXIMUM:
MEAN: to one decimal place
MODE:
For the following questions, reflect on your findings from #2 and #3.
4.(3 points) Did the minimum or maximum change? Why or why not? Explain.
5.(3 points) Did the median change? Why or why not? Explain.
6.(3 points) Did Q1 or Q3 change? Why or why not? Explain.
7.(3 points) Did the mean change? Why or why not? Explain.
8.(3 points) Did the mode change? Why or why not? Explain.
9.(14 points) Create a frequency table of the the original players in #1. If needed, round to two decimal places.
Data
Frequency
Relative Frequency
Cumulative Relative Frequency
10.(12 points) Construct a histogram of the frequency of the different heights. Use Excel. Make sure there are no spaces between the bars. Cut and paste below:
11.(7 points) Calculate the standard deviation. What does this tell us?
STANDARD DEVIATION:to 2 decimal places
12.(3 points) What is the population?
13.(3 points) What is the sample?
14.(2 points) Is the data quantitative or qualitative?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started