If (profit% is for real) then (Sales$ * Profit%) = (Profit$) See below. RRR
----- Original Message ----- From: "tellef" <[EMAIL PROTECTED]> To: "All" <[EMAIL PROTECTED]> Sent: Thursday, November 07, 2002 6:36 AM Subject: Statistics experts needed > > I guess I was sleeping when they taught this... I want to > know if there is an established business statistics theory > for what I want to do. A client has a simple salesperson's > profitability report, and he wants it sorted from highest > profit margin to lowest. We have an RBase report to do this, > and the report looks like this: > > #Sales Sales$ Avg$ Profit% Profit$ > Salesman1 1 150 150 30 45 > Salesman2 50 10000 200 25 2500 > Salesman3 40 15000 375 20 3000 > > Obviously sorting by Profit% is misleading. Salesman1 isn't > exactly their 'best' salesman! Salesman2 had the highest > number of sales and the highest profit% (after the loafer #1). > But Salesman3 had highest total sales$ and average$! > > Is there a way to WEIGHT the profit%? And what's the best > indicator of the 'best' salesman? Is it the Total Sales$, > the Average$, the number of items sold? I guess if there's > a formula to weight the profit% then I could ask my client > what other parameter is the most important to them. > > > > Karen > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
