Weighted average problem with negative numbers | TigerDroppings.com

 Posted by Message iPadThai New Orleans Saints FanMember since Oct 2011743 posts Weighted average problem with negative numbers  (Posted on 11/29/12 at 11:47 pm)Let's say I have 4 values A, B, C and D. Let's say they each contribute 30%, 30%, 20% and 20% towards some final value. So my weighted average formula is: X = [0.3(A) + 0.3(B) + 0.2(C) + 0.2(D)] / [0.3+0.3+0.2+0.2] But what if the situation is such that values C and D contribute negatively to the over all value X? As a sports analogy using a hypothetical situation, let's say I am calculating a Quartback's rating using my own method as follows: A = Yards/Attempt (I want this to be high, so this is a positive value) - 30% weight B = Touchdown percentage (I want this to be high, so this is a positive value) - 30% weight C = Number of incomplete passes (I want this number to be low/minumum and it contributes negatively to the overall rating) - 20% weight D = Interception percentage (Needs to be minimized and contributes negatively to the overall rating) - 20% weight So for my overall weighted average QB rating can I use this formula? X = [0.3(A) + 0.3(B) - 0.2(C) - 0.2(D)] / [0.3+0.3+0.2+0.2] If this is wrong, how to I account of positive and negative numbers in the same weighted average formula? This post was edited on 11/29 at 11:51 pm Back to top Share: hg LSU FanMember since Jun 200971853 posts Online re: Weighted average problem with negative numbers  (Posted on 11/29/12 at 11:48 pm to iPadThai) Back to top Replies (0) John McClane New Orleans Saints FanMember since Apr 201024247 posts Online re: Weighted average problem with negative numbers  (Posted on 11/29/12 at 11:48 pm to iPadThai)288 Back to top Replies (0) TigerHam85 Hawaii Fan59-024 Kamehameha Highway, HaleiwaMember since Nov 200927499 posts re: Weighted average problem with negative numbers  (Posted on 11/29/12 at 11:48 pm to iPadThai)288 eta: damnit!This post was edited on 11/29 at 11:49 pm Back to top Replies (0) Joe LSU FanNorth JerseyMember since Jan 20055980 posts re: Weighted average problem with negative numbers  (Posted on 11/29/12 at 11:48 pm to iPadThai)The plane takes off. This post was edited on 11/29 at 11:49 pm Back to top Replies (0) Hazelnut LA-Lafayette FanThe FlattzMember since May 201111553 posts re: Weighted average problem with negative numbers  (Posted on 11/29/12 at 11:49 pm to iPadThai)TL,DR Too Late, didn't read Back to top Replies (0) KosmoCramerCornell FanMember since Dec 200744279 posts re: Weighted average problem with negative numbers  (Posted on 11/29/12 at 11:50 pm to iPadThai)288 Back to top Replies (0) Harry Caray USA FanAstros 2016 AL West ChampsMember since Aug 200913582 posts re: Weighted average problem with negative numbers  (Posted on 11/29/12 at 11:50 pm to iPadThai)quote:X = [0.3(A) + 0.3(B) - 0.2(C) - 0.2(D)] / [0.3+0.3+0.2+0.2] well, this leaves your maximum possible rating at 60% ETA: 288This post was edited on 11/29 at 11:51 pm Back to top iPadThai New Orleans Saints FanMember since Oct 2011743 posts re: Weighted average problem with negative numbers  (Posted on 11/29/12 at 11:52 pm to Harry Caray)quote:well, this leaves your maximum possible rating at 60% That is what I am afraid I am doing wrong. How can I account for the positive and negative weights at the same time while making sure they add up to 100%? Back to top lsu480 LSU FanDowntown ScottsdaleMember since Oct 200769571 posts Online re: Weighted average problem with negative numbers  (Posted on 11/29/12 at 11:54 pm to iPadThai)It's 2 Back to top Vicks Kennel Club USA FanLegenD ForeverMember since Dec 201019582 posts Online re: Weighted average problem with negative numbers  (Posted on 11/29/12 at 11:55 pm to iPadThai)Why do you keep writing the denominator? It is just one in your formula. Back to top Replies (0) Harry Caray USA FanAstros 2016 AL West ChampsMember since Aug 200913582 posts re: Weighted average problem with negative numbers  (Posted on 11/29/12 at 11:55 pm to iPadThai)quote:How can I account for the positive and negative weights at the same time while making sure they add up to 100%? idk, take a class. ETA: study the passer rating stat...even though it maxes out at 158.3 instead of 100, it'll give you an idea. This post was edited on 11/29 at 11:58 pm Back to top Replies (0) au21tigers Auburn Fanask your wifeMember since Nov 200912118 posts Online re: Weighted average problem with negative numbers  (Posted on 11/29/12 at 11:56 pm to iPadThai)LINK Back to top Replies (0) ConwayTwizzle Alabama FanLittle HavanaMember since Nov 20121887 posts re: Weighted average problem with negative numbers  (Posted on 11/29/12 at 11:56 pm to iPadThai)tl;dr but it's either 2 or 288 Back to top Replies (0) Vicks Kennel Club USA FanLegenD ForeverMember since Dec 201019582 posts Online re: Weighted average problem with negative numbers  (Posted on 11/29/12 at 11:56 pm to lsu480)quote:It's 2 I probably made some of my best arguments ever in that thread. Back to top lsu480 LSU FanDowntown ScottsdaleMember since Oct 200769571 posts Online re: Weighted average problem with negative numbers  (Posted on 11/29/12 at 11:57 pm to Vicks Kennel Club) Back to top Replies (0) Gator5220 Florida FanMember since Aug 2010855 posts Online re: Weighted average problem with negative numbers  (Posted on 11/29/12 at 11:57 pm to iPadThai)I'll take a whopper no onion please. Back to top Replies (0) Macintosh504 LSU FanMember since Sep 201123481 posts Online re: Weighted average problem with negative numbers  (Posted on 11/30/12 at 12:00 am to Harry Caray)288 yes, I'm a genius Back to top iPadThai New Orleans Saints FanMember since Oct 2011743 posts re: Weighted average problem with negative numbers  (Posted on 11/30/12 at 11:01 am to Macintosh504)Can somebody from the day crew weigh-in with their thoughts please? Thanks. Back to top Replies (0)

Back to top