Weighted Average

  

Categories: Metrics, Investing

An average that has eaten waaaaaaay too many Tootie Bars, Cheesy Poofs, and Snacky Cakes.

A weighted average is an average that doesn’t allow each number in the average to count equally towards the average. Instead, each data point is weighted according to its overall contribution. Normally, in a regular average, we just add up the numbers and divide by the total number of data points. This “spreads” the average value equally across all the data points.

A weighted average first multiplies the data point by its weight then divides the sum of all the weighted values by the total amount of weights. Your school GPA is a classic weighted average, because classes that are for more credits, like a five-credit course compared to a three-credit course, count more toward your GPA.

Let’s say you took a three-credit math class and got a 3.0, a four-credit psych class and got a 2.5, and a five-credit social science course and got a 4.0. Your regular average would be a Shmoop-pleasing (3.0 + 2.5 + 4.0)3 = 9.533.17. Your actual GPA as a weighted average would be an even more Shmoop-pleasing (3.03 + 2.54 + 4.05)(3 + 4 + 5) = (9 + 10 + 20)(12) = 3912 = 3.25. Since the five-credit course counted more heavily in the weighted average, that 4.0 helped bump the weighted average up above the regular average.

The wrong way to manage this process? Here's a clue: Don't just add up all your grades and divide by, uh… how many grades you have. You're creating a weighted average, which admittedly sounds like an average that needs Jenny Craig...but is just an average that gives each value a different weight rather than the same weight.

Want to know how casinos are quite literally designed to make money, or rather to take your money and make it their money? It's because they understand how the probabilities of winning or losing a game all merge together to tell them what the likely results of playing that game a jillion times are. This long-term, cumulative result is the expected value of the game.

Like most colleges, Whassamatta U determines your GPA as a weighted average. Classes that are for more credits count more towards your GPA. Classes for fewer credits count less towards your GPA. Each letter grade in a course is converted to a number, which is then multiplied by the number of credits. The results are called grade points. 'Cause they're gonna get averaged together to create a grade point average. Clever, right? A regular average would just add up the four grades and divide by four. This way, each course weighs equally in the average. A weighted average takes those grade points that are weighted by the number of credits and divides by the total number of credits attempted, which is 14. And each course weighs a different amount in the final average. It's pretty cruel, but at least they have wicked fast WiFi in all the dorms.

Teachers also typically use weighted averages to determine your grade in a course. To determine your grade, you just need to multiply your score in a category by its percentage weight and add up all the answers. Boom! Instant weighted average grade.

It's usually easiest to leave scores in percent form, and convert the weights to decimals or fractions before multiplying. Poor Smelly McNeedsashower. He only managed a 67.06%, even with decent test and quiz scores. 25% for Personal Hygiene does seem kinda harsh, though.

Abigail D. Moneybags is a huge fan of making money in the stock market. She tends to buy more and more stock in a company if its value continues to increase over the years. She has been in on the stock for the makers of the Squatty Potty since day one. Those stocks have made her, um...flush with cash. Abigail bought 20 shares for $5 a share in 2000. Then 30 shares for $11 a share in 2005. Then another 15 shares for $18 a share in 2008. And finally, another 25 shares for $27 a share in 2015. She'd like to know the average price she paid per share.

A regular average, where we add up the four prices and divide by four, doesn’t take into account that she bought different numbers of shares at the four different prices. Abby needs a weighted average.

It turns out that Abby paid about $15.28 per share over the years, when we rightly account for the prices of the groups and the sizes of the groups. Mrs. Moneybags expects her information about her stocks to be A number 1...not number 2.

At the casino, the roulette wheel has 38 equally sized spaces. 18 are red. 18 are black. 2 are green. Sadly, none are rainbow-colored. Many gamblers believe betting on a color like red or black is the best way to make money in the casino. We can figure out how clever of a strategy this is by finding the expected value. The expected value is the average outcome we expect after many, many trials of spinning that wheel and seeing how much we lose, or occasionally...win. To find an expected value, we need to know all the possible outcomes and their associated probabilities. We can win or…lose. We also need to know the probability of each of those outcomes if there are 18 reds out of 38 spaces total.

We'll drop a fiver as a bet on red, and if we win, we get our fiver back plus another five. If we lose, they keep the five. To find the expected value, we just calculate another weighted average. We multiply the outcome by the probability, and add up the results, just like getting a grade from the breakdown in a syllabus.

Yeah, that's negative 0.263 dollars...or negative 26 cents. We expect to lose 26 cents if we keep dropping $5 on red (or black) over and over, all night long. We clearly can’t lose 26 cents on any one game.

We should, however, expect to walk out with less money than we walked in with if we play the one-color bets all night. Another spoiler alert: every single casino game has a negative expected value. Every. Single. One. Meaning that, over millions of plays, people lose…a lot.

It ain't just the casino games that sport negative expected values. Yup, lottery tickets, too. We know. We know. We're really tossing a wet blanket on stuff. We're gonna take the probability distribution that has to be printed on the back of each ticket and pair that up with the possible outcomes, or winnings, if we drop $2 on the ticket. When we find an expected value, otherwise known as a weighted average, we find that we should stop buying lottery tickets. We spend $2 buying this ticket over and over a whole mess of times, and expect by the end to be about $1.23 poorer than when we started.

Why is math such a buzzkill sometimes?

Not all expected values are negative. Black Fortress, a new fast food joint, has done a careful study of the number of cars in the drive-thru, and created a probability distribution showing how likely it is for there to be anything from 0 to the max of 6 cars in line.

The expected value can be found like every other one we've done. We multiply the number of cars by the corresponding probability and add up the answers. This story tells the Dark Lords in the Black Fortress that, over many, many counts of the number of cars in line, they can expect 2.33 cars to be in line.

Or that they can expect 2 or 3 cars to be in line since, uh...0.33 of a car isn't a thing. Unless you drive a Smart Car.

Related or Semi-related Video

Cost Accounting: What is Weighted Averag...2 Views

00:00

and finance Allah shmoop weighted average contribution margin in multi

00:06

product companies Well you want a company that makes salad

00:11

dressings When you started out you had one product a

00:13

meat flavored salad dressing for people who want to be

00:16

vegan but missed the taste of meat and don't miss

00:19

the guilt At that point it was relatively easy to

00:21

attribute costs and margins He only had one product to

00:24

worry about Eventually though you expanded You launched a second

00:28

product a salad dressing that tastes like meat from endangered

00:31

species black rhino twist and giant panda barbecue Mostly Well

00:36

don't worry The flavors are all simulated with chemicals No

00:39

animals were actually harmed in the making of this video

00:42

Okay so figuring out contribution margin becomes more complicated Here

00:46

You use a weighted average contribution margin to let you

00:49

know which product has the higher margin or contribution to

00:52

your profits In any company you have two basic types

00:55

of expenses There are expenses that relate directly to your

00:57

product You're trying to make light these expenses air known

01:00

as cog zor costs of goods sold There are also

01:03

expenses that don't apply to a specific product but to

01:06

the cost of running the company as a whole Regular

01:09

people would call these expenses overhead But just like rappers

01:13

and private detectives and old movies accountants have you know

01:16

their own lingo They call these expenses S G N

01:19

A or sales general and administrative expenses Imagine for a

01:23

second that we're back when your company had only one

01:26

product You want to figure out how many bottles of

01:28

cell addressing you had to sell to reach break even

01:30

the cause for the salad dressings A buck fifty per

01:33

bottle that covers chemicals that make the meat flavor in

01:35

the herbs and spices and the things like the plastic

01:38

for the bottle and the printing of the labels and

01:40

all That stuff also covers the direct labor that goes

01:43

into making the bottles of dressing But you've got all

01:45

the overhead stuff you have to cover as well The

01:48

rent on your headquarters the advertising budget the CEO's salary

01:52

all that stuff All that overhead is DNA in accounting

01:55

slang and it adds up to three million bucks a

01:58

month You Sela Sela dressing for three dollars a bottle

02:00

to retailers so your gross profit or gross contribution per

02:04

bottle of dressing is a buck fifty right It cost

02:06

you a buck Fifty in *** to make it yourself

02:08

for three dollars And you got a buck fifty leftover

02:10

Well that buck fifty is known as contribution and its

02:13

margin here is fifty percent the amount each bottle contributes

02:17

Either too well paying the overhead costs or the bottom

02:19

line depending on how many items you're selling here right

02:22

So you want to know how many bottles you need

02:24

to sell to cover that three million dollars a month

02:27

Take three million divided by the buck fifty and that

02:29

gets you two million bottles Once you sell two million

02:32

bottles you've covered your overhead nut and the gross profit

02:35

then start to all fall to the bottom line Okay

02:37

simple enough But how about when you move on to

02:39

multiple products Those unattached overhead costs then get spread over

02:44

additional products so the math gets a lot more complicated

02:47

when you try to assign the amounts of overhead So

02:49

we enter the weighted average contribution margin Well basically you're

02:53

taking multiple products and splitting the overhead across him The

02:56

weighted average comes in well because you need to split

02:58

the overhead fairly You do so by looking at the

03:01

contribution margin for each product and putting it in context

03:04

for the sales mix So you launch your second product

03:07

You know that salad dressing that tastes like meat from

03:09

endangered animals Endangered species flavor sells for four dollars two

03:13

customers but cost to twenty five to make So the

03:15

contribution It's a buck seventy five It's a more specialized

03:18

flavor so you only sell half the volume of the

03:21

original flavor If you sell two million bottles of original

03:24

flavor to cover you're not well You can expect to

03:26

sell only one million bottles of the endangered species New

03:30

flavor You'LL earn contribution margin of a dollar fifty per

03:33

bottle for the original or three million dollars total Meanwhile

03:36

one million bottles of the new flavor will get you

03:39

one point seven five million right They sold three million

03:42

total bottles of dressing two million of the original self

03:45

and one million in the new stuff and you got

03:46

four Seventy five or four point seven five million to

03:50

apply to the overhead and or to the bottom line

03:52

Well four point seven five million divided by three million

03:54

bottles gives you a weighted average of approximately a dollar

03:58

fifty eight per bottle So how many total bottles and

04:01

then need to be He sold the break even including

04:02

both the old stuff and the new stuff Well you

04:04

still have the three million dollars in overhead The overhead

04:06

didn't change weighted average contribution margin of a buck fifty

04:09

eight there so you get three million divided by the

04:11

dollar Fifty eight gives you about one point eight nine

04:13

nine million bottles total to break even And if you're

04:16

two to one product mix hold well then you'Ll likely

04:18

sell about six hundred thirty three thousand bottles of the

04:21

new stuff and about one point two six six million

04:24

of the old stuff And that's the target you need

04:25

to hit to make up your overhead cough some more

04:29

than that number and you start working on product three

04:31

A salad dressing that tastes like already extinct animals You

04:34

know mammoths and dodos and there's really no accounting for

04:38

taste But that's very different video

Up Next

Finance: What are Weighted Averages and Expected Values?
13 Views

What are Weighted Averages and Expected Values? Weighted averages are averages calculated to account for the number of changes that a variable, suc...

Finance: What are Time-Weighted Rate Of Return and Present Value?
1 Views

What are Time-Weighted Rate Of Return and Present Value? The Time Weighted Rate of Return is a calculation for the compounded growth rate within an...

Find other enlightening terms in Shmoop Finance Genius Bar(f)