The file P02_17.xlsx contains salaries of 200 recentgraduates from a (fictional) MBA program.
Using the built-in histogram feature, create a histogram forsalary, and choose the correct option below. Make sure to modifythe Axis Options so that the histogram contains thirteen bins.
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 thesedata? Can you tell, or at least make an educated guess, by lookingat the shape of the histogram? Why?
The percentage for the Select68%95%99.7%Item 2 rule isa bit higher than expected, but this is SelectnotsurprisingsurprisingItem 3 , given that the histogram of thesalaries is Selectskewed to the leftsymmetricskewed to theright Item 4 . The percentages for the Select68% and95%68% and 99.7%95% and 99.7%Item 5 rules are almost just asexpected.
Between $ and $
The file P02_17.xlsx contains salaries of 200 recent graduates from a (fictional) MBA program. Using the built-in histog
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am