Apply the location method to calculate the 80th percentile manually of net sales

Question

Apply the location method to calculate the 80th percentile manually of net sales for each method (card) of payment. Please indicate which card has the highest 80th percentile and show the process.

Customer customer Items Net Sales Payment Gender status Age l Regular 1 39.50 Discover Male Married 32 2 Promotional 102.40 Proprietary Card Female Married 36 4 Promotional 5 100.40 Proprietary Card Female Married 28 5 Regular 2 54.00 MasterCard Female Married 34 6 Regular 44.50 MasterCard Female Married 44 7 Promotional 2 78.00 Proprietary Card Female Married 30 22.50 Visa 9 Promotional 2 56.32 Proprietary Card Female Married 46 10 Regular 44.50 Proprietary Card Female Married 36 11 Regular 29.50 Proprietary Card Female Married 48 12 Promotional 31.60 Proprietary Card Female Married 40 13 Promotional 9 160.40 Visa Female Married 40 14 Promotional 2 64.50 Visa Female Married 46 15 Regular 49.30 Visa Male Single 24 16 Promotional 2 71.400 Proprietary Card Male Single 36 17 Promotional 3 94.00 Proprietary Card Female Single 22 18 Regular 3 54.50 Discover Female Married 40 19 Promotional 2 38.30 MasterCard Female Married 32 20 Promotional 6 44.80 Proprietary Card Female Married 56 21 Promotional 31.60 Proprietary Card Female Single 28 4 70.82 Proprietary Card Female Married 24 Regular 2 74.00 Proprietary Card Female Married 42 25 Promotional 2 39.50 Visa Male Married 48 26 Promotional l 30.02 Proprietary Card Female Married 60 22 Regular l 44.50 Proprietary Card Female Married 54 28 Promotional 5 192.80 Proprietary Card Female Single 42 3 71.20 Proprietary Card Female Married 30 Promotional 18.00 Proprietary Card Female Married 70 31 Promotional 2 63.20 MasterCard Female Married 28 32 Regular 75.00 Proprietary Card Female Married 52 33 Promotional 3 63.20 Proprietary Card Female Married 44 34 Regular 40.00 Proprietary Card Female Married 34 35 Promotional 50 MasterCard Female TMarried S6

Explanation / Answer

There are 100 customers categorized as Discover, Proprietary card, American Express, Master card, Visa on basis of their methods of payment.

Now, in order to cocmpute 80th percentile, sort the net sales in ascending order for each categories. Then multiply 0.80 with number of payment type in each categories. The resulting number (rounded off) is the index number. Count from smallest till the index number. That number is the corresponding percentile.

Discover: counts-3, Proprietary-69, Master card-14, American Express-2, Visa-11.

Multiply 0.80 with each of the 5 counts.

Discover: 2.4~2, Proprietary: 55.2~55, Master Card: 11.2~11, American Express: 1.6~2, Visa: 8.8~9.

Count the number in sorted list [note, sorting has been done with help of technology].

The 80th percentile for Discover: 58, Proprietary: 113, Master card: 78, American Express: 266, Visa: 74 respectively.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.