## Find standard deviation in Excel, but first develop a labor-saving trick

Help me with statistics and Excel. Especially help me if you know any labor saving methods. I want the median, mean and standard deviation for the average price of all items sold, but my spreadsheet-full-of-data doesn't tell me the price of each sale -- just the average price per store, and the number sold at that store. Something like this:
posted by croutonsupafreak on Jun 21, 2013 - 10 answers

I have been driving a lot more these days and have come across rather curious situations on the road, involving pedestrians and abandoned / malfunctioning vehicles. Wondering who would be at fault if something were to happen.
posted by ditto75 on Dec 7, 2012 - 22 answers

## How to solve a complex statistics problem with a script?

In this game, you roll a number of six-sided dice to get a total. The total is either the highest single die result, or the sum of any multiples rolled, whichever is higher. For example: If I roll three dice and get a 3, 4, and 6, my total is 6. But if I roll a 4, 4, and 6, my total is 8, the sum of the two 4s. What I want to find out is the mean, median, mode, and standard deviation of the possible totals given N dice. How might I create a simple script to compute this?
posted by j0hnpaul on Nov 30, 2012 - 24 answers

## In Excel, getting the MEDIAN of a set based on a text pattern match

In Excel, I have two columns. Column A has many rows of names (e.g., Mary, Maryjane, Maryanne, Anne, Jane) and in Column B I have their ages (e.g., 4, 20, 40, 10). I would like to find the MEDIAN age of all the "mary's"; i.e., both "mary" and "maryanne", etc. Is this possible? I have been getting errors on variations of {=MEDIAN(IF(A1:A4="*mary*",B1:B4))} constructions... I do not want to use VBA. thank you!
posted by noway on Oct 26, 2012 - 5 answers

## Mysterious islands in the street

What is the purpose of very small median strips close to the sidewalk near an intersection?

## Meta-Median from other medians?

[Statistics Filter]: What's the best way to calculate a meta-median?
posted by lord_yo on Feb 23, 2009 - 4 answers

## Let's base our new life together on unreasonable expectations and outrageous debt!

What's the median cost of a wedding these days? The average must be skewed high by the outrageous spending of the super-rich.
posted by croutonsupafreak on Jun 4, 2006 - 39 answers

## There's a good reason I went into music instead of engineering

Grading dilemma: Can the median be a fair measure of a set of quiz scores? Here's the situation ...
posted by imposster on May 8, 2006 - 24 answers

## Help me understand weighted averages.

Remedial weighted averages for the mathematically illiterate – or, can the 10% of you who understand math help the remaining 95% of us who don't? [mi].
posted by RavinDave on Jul 11, 2004 - 3 answers

Page: 1