Please answer all questions disregarding answers one question rule as requested by asker. The file P02_17.xlsx contains sa

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

Please answer all questions disregarding answers one question rule as requested by asker. The file P02_17.xlsx contains sa

Post by answerhappygod »

Please answer all questions disregarding answers one question ruleas requested by asker.
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 $
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply