Question
The file P02_17.xlsx contains salaries of 200 recent graduates from a (fictional) MBA program. Using the built-in histogram feature, create a histogram for salary, and
The file P02_17.xlsx contains salaries of 200 recent graduates from a (fictional) MBA program.
-
Using the built-in histogram feature, create a histogram for salary, and choose the correct option below. Make sure to modify the Axis Options so that the histogram contains thirteen bins.
(i) (ii) (iii) (iv) SelectHistogram (i)Histogram (ii)Histogram (iii)Histogram (iv)Item 1 is the appropriate histogram for salary.
Do the empirical rules for standard deviations apply to these data? Can you tell, or at least make an educated guess, by looking at the shape of the histogram? Why?
The percentage for the Select68%95%99.7%Item 2 rule is a bit higher than expected, but this is Selectnot surprisingsurprisingItem 3 , given that the histogram of the salaries is Selectskewed to the leftsymmetricskewed to the right Item 4 . The percentages for the Select68% and 95%68% and 99.7%95% and 99.7%Item 5 rules are almost just as expected.
- If the empirical rules apply here, between which two numbers can you be about 68% sure that the salary of any one of these 200 students will fall? Round your answers to the nearest whole dollar, if necessary.
Between $ and $
- If the MBA program wants to make a statement such as "Some of our recent graduates started out making $210,000 or more, and almost all of them started out making at least $65,000" for their promotional materials, what percentage of graduates made more than $210,000 and made at least $65,000? Round your answers to one decimal place, if necessary.
Salary % above $210,000 % $65,000 %
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