##
9 posts tagged with median.

Displaying 1 through 9 of 9. Subscribe:

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

## road safety snafus

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]

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

## Mysterious islands in the street

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

## Meta-Median from other medians?

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

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

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

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

Page:
1