Question

1 Approved Answer

Posted on Aug 09, 2024

please answer practice question 2 Check My War D 00 Spreadsheet Book The Ne O2 17x contains salaries of 200 recent graduates from a fictional)

please answer practice question 2 image text in transcribed

Check My War D 00 Spreadsheet Book The Ne O2 17x contains salaries of 200 recent graduates from a fictional) MBA program Dung the built in histogram feature, create a histogram for salary, and choose the correct option below. Make sure to modify the Ass Options so that the stagram contain thirteen bins Histogram for Salary Histogram for Salary 9182 20 15 10 10 terce 1566,146, SES 1500 51001 549.01. (5100 SS 5113, 115, 5135238 CENESIS WESELS saste 2515 1537,500 $109,435,5116,00 (5186,60,5203,7311 stores Tecco 1532.500,541.6231 15220,154, 5237.9771 237,972, 5100 $3,03,5667 1566,146,583 OOTS WSI 11 US, 513523 $100.102.11 15169,435 SEBOU $152,362,5169 STOL S0731 ISTOCES TOP 24,2777 237,877, 23.1001 X (HD) Histogram for Salary (iv) 45 Histogram for Salary 45 40 5 15 30 % 25 20 25 10 5 D 15 10 115 23 DES, SESEO LESSOS SAS. R$300 2. LEGOS COSESSED GIL 2014 Salt the appropriate histogram for salary Do the empirical stats for standard deviations apply to these data? Can you tell or at least make an educated quess, by looking at the shape of the histogram. Why? The percentage for the select rule is a bit higher than expected, but this telect given that the histogram of the sales Solica The percentages for the select rules are almost ust as expected b. If the anpirical rules avaly here, between which two numbers can you be about 68 sure that the salary of any one of the 200 students will fair Hound your answers to the nearest whole dollar, if necessary Between ands If the MBA program wants to make a statement such as some of our recent graduates started out making 1220,000 or more, and almost of the started out making at least 555,000 for their promotional materials, what percentage of graduates made more than $220,000 and made at least 555,0007 Round your answers to one decimal place, necessary Salary above $220,000 555,000 Check My War D 00 Spreadsheet Book The Ne O2 17x contains salaries of 200 recent graduates from a fictional) MBA program Dung the built in histogram feature, create a histogram for salary, and choose the correct option below. Make sure to modify the Ass Options so that the stagram contain thirteen bins Histogram for Salary Histogram for Salary 9182 20 15 10 10 terce 1566,146, SES 1500 51001 549.01. (5100 SS 5113, 115, 5135238 CENESIS WESELS saste 2515 1537,500 $109,435,5116,00 (5186,60,5203,7311 stores Tecco 1532.500,541.6231 15220,154, 5237.9771 237,972, 5100 $3,03,5667 1566,146,583 OOTS WSI 11 US, 513523 $100.102.11 15169,435 SEBOU $152,362,5169 STOL S0731 ISTOCES TOP 24,2777 237,877, 23.1001 X (HD) Histogram for Salary (iv) 45 Histogram for Salary 45 40 5 15 30 % 25 20 25 10 5 D 15 10 115 23 DES, SESEO LESSOS SAS. R$300 2. LEGOS COSESSED GIL 2014 Salt the appropriate histogram for salary Do the empirical stats for standard deviations apply to these data? Can you tell or at least make an educated quess, by looking at the shape of the histogram. Why? The percentage for the select rule is a bit higher than expected, but this telect given that the histogram of the sales Solica The percentages for the select rules are almost ust as expected b. If the anpirical rules avaly here, between which two numbers can you be about 68 sure that the salary of any one of the 200 students will fair Hound your answers to the nearest whole dollar, if necessary Between ands If the MBA program wants to make a statement such as some of our recent graduates started out making 1220,000 or more, and almost of the started out making at least 555,000 for their promotional materials, what percentage of graduates made more than $220,000 and made at least 555,0007 Round your answers to one decimal place, necessary Salary above $220,000 555,000