Question: Please answer all questions disregarding Chegg one question rule as requested by asker. The file P02_17.xlsx contains salaries of 200 recent graduates from a (fictional)

Please answer all questions disregarding Chegg one question rule as requested by asker.

The file P02_17.xlsx contains salaries of 200 recent graduates from a (fictional) MBA program.

  1. 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.

  2. 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 $

  3. 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!