Question

1, 2, 4, 6, 7, 8, 11, 12, 16, 20, 28, 30 5) Given the following data: . What is the percentile of the 8 data value? Sketch the boxplot for the data (so you'll need to find Q1, Q2, a Q3, etc.).

Answer 1

Insert Page Layout Formulas Data Review View Developer Add-ins Help Tell me what you want to do File Home Cut ▼ | 11 ·A' A' み Wrap Text Minion Pro General Copy ▼ B I U·E-3-A. ___ 터 부Merge & Center. $-96 , .00 joo Conditional Format as Cell Formatting Table Styles 4.0 .00 Conditional Format as Cel Insert Delete Format .00 →.0 Insert Delete Format Paste Format Painter Clipboard Font Alignment Number Cells Rank Observation Percentile rank of "8" = # of values below 'B" Percentile rank of"8" 7/12 100 6 58.33 Formulas 10 Min = QUARTII.E(H 5:H 16,0) 12 5.5 QUARTILEHS:H16,1) -QUARTILE HS:H16,2) 13 16 9.5 10 20 =QUARTI LE(H 5:H 16,3) 14 Max = 15 28 -QUARTILE H5:H 16,4) 12 16 17 18 21 Max. 15 25 10 24 25