9 posts tagged with median. (View popular tags)

Displaying 1 through 9 of 9. Subscribe:

average + (5)

statistics + (4)

mean + (4)

math + (4)

croutonsupafreak (2)

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: [more inside]

posted by croutonsupafreak on Jun 21, 2013 - 10 answers

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. [more inside]

posted by ditto75 on Dec 7, 2012 - 22 answers

posted by ditto75 on Dec 7, 2012 - 22 answers

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? [more inside]

posted by j0hnpaul on Nov 30, 2012 - 24 answers

posted by j0hnpaul on Nov 30, 2012 - 24 answers

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

posted by noway on Oct 26, 2012 - 5 answers

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

posted by bad grammar on May 17, 2012 - 15 answers

posted by bad grammar on May 17, 2012 - 15 answers

[Statistics Filter]: What's the best way to calculate a meta-median? [more inside]

posted by lord_yo on Feb 23, 2009 - 4 answers

posted by lord_yo on Feb 23, 2009 - 4 answers

What's the median cost of a wedding these days? The average must be skewed high by the outrageous spending of the super-rich. [more inside]

posted by croutonsupafreak on Jun 4, 2006 - 39 answers

posted by croutonsupafreak on Jun 4, 2006 - 39 answers

Grading dilemma: Can the median be a fair measure of a set of quiz scores? Here's the situation ... [more inside]

posted by imposster on May 8, 2006 - 24 answers

posted by imposster on May 8, 2006 - 24 answers

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]. [more inside]

posted by RavinDave on Jul 11, 2004 - 3 answers

posted by RavinDave on Jul 11, 2004 - 3 answers

Page:
1