Question: I need help converting the formulas for H10, H11, H12, H13. I did H10 but I am not sure if its correct. Please help thank
I need help converting the formulas for H10, H11, H12, H13. I did H10 but I am not sure if its correct. Please help thank you. The Questions is what is being asked in the orange box and then you correlate those questions in H10, h11, h12,H13. Please help
1 Cost per Order Database of Grogtes LLC 2 3 Item Category 4 Nuts 5 Screws 6 Nuts 7 Screws 8 Screws 9 Nuts 10 Nuts 11 Nuts 12 Screws 13 Nails 14 Screws 15 Nuts 16 Nuts 17 Screwdriver 18 Nuts 19 Nuts 20 Nuts 21 Nuts 22 Bolts 23 Screws 24 Bolts 25 Screwdriver 26 Screws 27 Bolts 28 Screws 29 Nuts 30 Nuts 31 Nailgun pack 32 Bolts 33 Screwdriver 34 Screwdriver 35 Nails 36 Screws 37 Screwdriver 38 Bolts 39 Screws 40 Bolts 41 Screws 42 Screws 43 Bolts 44 Screws 45 Screws 46 Screws 47 48 Item ID N103 S102 N103 S102 S101 N101 N103 N103 S101 NG101 S102 N101 N101 SD104 N102 N102 N102 N101 B101 S103 B102 SD101 S102 B102 S103 N102 N102 NG101 B102 SD103 SD101 ING102 S103 SD102 B103 S103 B104 IS101 S101 B101 S104 S101 S101 Item Cost Units $1.74 $5.44 $1.74 $5.44 $2.44 $2.44 $1.74 $1.74 $20.44 $125.45 $5.44 $2.44 $2.44 $2.44 $5.44 $3.44 $5.44 $2.44 $16.44 $9.44 $5.44 $20.44 $5.44 $5.44 $9.44 $5.44 $5.44 $125.45 $5.44 $5.44 $20.44 $275.45 $9.44 $9.44 $12.94 $9.44 $24.40 $20.44 $20.44 $16.44 $15.45 $20.44 $20.44 6 3 13 10 28 31 52 66 6 1 27 65 74 75 34 55 35 94 15 27 49 14 59 61 45 89 89 4 95 95 26 2 59 63 54 79 41 49 56 73 86 80 93 Cost per Order $10.44 $16.32 $22.62 $54.40 $68.32 $75.64 $90.48 $114.84 $122.64 $125.45 $146.88 $158.60 $180.56 $183.00 $184.96 $189.20 $190.40 $229.36 $246.60 $254.88 $266.56 $286.16 $320.96 $331.84 $424.80 $484.16 $484.16 $501.80 $516.80 $516.80 $531.44 $550.90 $556.96 $594.72 $698.76 $745.76 $1,000.40 $1.001.56 $1,144.64 $1,200.12 $1,328.70 $1,635.20 $1,900.92 Percentile Rank (rounded): [Hint: use ROUND() to no digit after decimal point Value of the 1001.0264th observation: [Hint: use INDEX()] The corresponding "Item Category": [Hint: use INDEX()] Using PERCENTILE.INC() M 87 1001.026 -PERCENTILE.INC(Table1[Cost per Order],0.87) ? ? ? What is the 87th percentile of costs per order? You need to show your calculation on the spreadsheet as well. Label any cell added. 1. Sort "Cost per order" in ascending order 2. Calculate the rank of the 87th percentile (H10) 3. Find that specific Cost per Order (H11) either manually or using INDEX() 4. Find the corresponding "Item Category" (H12) either manually or using INDEX() 5. Alternately use function PERCENTILE.INC() to find the value (H13) (Make sure to use k/100 as parameter for the function)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
