Question: i need the excel formulas 2 Thirteen senior executives in a company are randomly selected and are asked to report their current salary. The data

i need the excel formulas
i need the excel formulas 2 Thirteen senior executives in a company
are randomly selected and are asked to report their current salary. The

2 Thirteen senior executives in a company are randomly selected and are asked to report their current salary. The data obtained are listed in Column A. Ninco NM Salaries $127,000 $132,000 $138,000 $141,000 $144,000 10 $146,000 11 $152,000 12 $154,000 13 $162,000 14 $171,000 15 $177,000 16 $192,000 17 $241.000 18 19 Required: 20 Find the 90th percentile $221,400 21 Find the median $152,000 22 Find the first quartile $139,500 23 Find the third quartile $174,000 24 Find the 10th percentile $129,000 25 Find the interquartile range $34,500 26 27 Develop a five-number summary 2. fx A B B C 2 $154,000 3 $162,000 14 $171,000 15 $177,000 16 $192,000 17 $241,000 18 19 Required: 20 Find the 90th percentile $221,400 21 Find the median $152,000 22 Find the first quartile $139,500 23 Find the third quartile $174,000 24 Find the 10th percentile $129,000 25 Find the interquartile range $34,500 26 27 Develop a five-number summary. 28 29 Minimum $127,000 30 1st Quartile $139,500 31 Median $152,000 32 3rd Quartile $174,000 33 Maximum $241,000 34 35 36 37 Students: The scratchpad area is for you to do any additional work you n 38 Nothing in this area will be graded, but it will be submitted with your ass 39 Graded Worksheet + Calculation Mode: Automatic Workbook Statistics

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 Accounting Questions!