The file P02_17.xlsx contains salaries of 200 recent graduates from a (fictional) MBA program. Using the built-in histog

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

The file P02_17.xlsx contains salaries of 200 recent graduates from a (fictional) MBA program. Using the built-in histog

Post by answerhappygod »

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 $
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply