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%Item2 rule is a bit higher than expected, but thisis Selectnot surprisingsurprisingItem 3 , given that thehistogram of the salaries is Selectskewed to theleftsymmetricskewed to the right Item 4 . The percentagesfor the Select68% and 95%68% and 99.7%95% and 99.7%Item5 rules are almost just as expected.
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