Join 3,421 readers in helping fund MetaFilter (Hide)

35 posts tagged with average. (View popular tags)
Displaying 1 through 35 of 35. Subscribe:

Related tags:
+ (7)
+ (6)
+ (5)
+ (5)
+ (5)
+ (4)


Users that often use this tag:
Anonymous (2)
croutonsupafreak (2)

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]
posted by croutonsupafreak on Jun 21, 2013 - 10 answers

WWF average word score of 503.5

Perusing the new leaderboard feature on Word With Friends, I see that in Global > All Time, a user with the name Polska91… [truncated] has an average word point score of 503.5. How is that possible? [more inside]
posted by unliteral on Jun 17, 2013 - 11 answers

virtunotso

Who are some really good contemporary singer-songwriters that perform often or mostly on guitar, but are not particularly better than average when it comes to technical skill at the instrument itself?
posted by threeants on Apr 25, 2013 - 14 answers

How much is too much sleep - for people who don't sleep much?

No work today. Last night I went to bed at 12:30. I woke up this morning (around 7) feeling fantabulous, and decided "Meh, I'm still below the 7-9 hour mark. Let's get a few more hours of beauty sleep in." I slept for two and a half extra hours, and woke up at about 9:30 feeling like donkey dung. I also had a nightmare. This has happened before (having nightmares when oversleeping). I would like to know if anyone has had any similar experiences. I would also like to ask if anyone gets below the 'average' amount of sleep and wakes up feeling great, but then goes back to sleep and wakes up feeling cruddy - even if they are not technically 'oversleeping'.
posted by Thanquol180 on Mar 3, 2013 - 22 answers

How many people does an average person encounter in a given day?

How many people does an average person encounter in a given day? [more inside]
posted by daboo on Jan 15, 2013 - 13 answers

How to Find The Average Commenter?

Harmonic or Arithmetic Mean?: I'm trying to settle an argument with my wife - is using the arithmetic mean or harmonic mean more appropriate when finding the "average" number of, say, online comments made by a large number of people, where a significant portion of them make only one comment and a few people make the bulk of the comments? [more inside]
posted by salsamander on Jun 2, 2012 - 13 answers

I Feel So Average

I feel so average and uninteresting. What can I do to remedy this situation? [more inside]
posted by anonymous on Sep 18, 2011 - 22 answers

Does Splitting Your Monthly Payment into Two Save, And If So, How Much?

A website I came across recommended paying half your minimum payment on a credit card every two weeks (instead of one monthly payment) in order to reduce your average daily balance. Does this work, and what kind of savings would this yield? [more inside]
posted by WCityMike on Jul 10, 2011 - 11 answers

I got 99 problems and Excel isn't one of them.

How do I, using Excel, determine the frequency of orders, the minimum/maximum amount per customer and the average order size? [more inside]
posted by hecho de la basura on May 21, 2011 - 11 answers

Searching for average man protagonist who repairs aqueducts

Trying to find a fiction fantasy book that has an average protagonist that loses his gold and ends up traveling to another city to avoid issues with the lost gold. The book is apart of a series and features aqueducts, the antagonists as vampires, and the book title looks like some kind of deviation on the word Aqueduct, like Aquadia or such. [more inside]
posted by LittleNami on Jan 14, 2011 - 2 answers

Is there circularity in the methodology used to establish my students' educational goals?

I have some questions about the use of normalized testing data to establish goals for struggling students. [more inside]
posted by alphanerd on Sep 16, 2010 - 6 answers

How can I generate an "average image" from 200 photographs?

How can I generate an "average image" from 200 photographs? [more inside]
posted by so_necessary on Sep 7, 2010 - 17 answers

The more "average" you are, the more attractive?

In what popular magazine did I first read about the 1990 study "Attractive faces are only average" (I think that was it)? [more inside]
posted by Ky on Mar 22, 2010 - 9 answers

Help me sample accurately!

Please provide me with an *effective*, and statistically sound, table/chart listing suggested sample size guidance for associated population size [more inside]
posted by thankyoumuchly on Jan 14, 2010 - 11 answers

He's a special snowflake and I'm gray sludge

My partner is way, way smarter than me and basically never had to put in any effort to learn difficult material. I admire him for this, but I'm also incredibly jealous. I want to be a genius too. How do I deal? [more inside]
posted by anonymous on Dec 11, 2009 - 40 answers

Doing "enough to get by" vs. "hard work"

When is it actually worth it to attempt to do any better than average? [more inside]
posted by jnnla on Oct 21, 2009 - 18 answers

Excel AVERAGE questions.

Trying to get some modified AVERAGE results in Excel. [more inside]
posted by FatherDagon on Aug 5, 2009 - 5 answers

How do I work out an average spend?

ExcelFilter: I want to calculate an average food spend, but the days I buy food are irregular throughout the month. How can I draw up a table/graph that gives an average based on a date and amount (for OpenOfficeCalc)? [more inside]
posted by Gisela on May 21, 2009 - 11 answers

An average question, just don't be mean.

How much tap-temperature water (say 15 C) would you need to add to 1 litre of water to make a mass of water 80 C? [more inside]
posted by doozer_ex_machina on May 15, 2009 - 4 answers

Meta-Median from other medians?

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

I know there's some sort of Law of Why This Shit Works

MathFilter: When you take the average of a series of ratios expressed as fractions, you get the same result whether you add together all of the fractions, then divide them by the size of the series or divide the sum of all of the numerators by the sum or all of the denominators. What's this called, and what's the formal proof for this look like? [more inside]
posted by ignignokt on Oct 29, 2008 - 14 answers

Help with Money

Two years ago, when the DJIA was at 11,200, I thought the market was approaching its peak, and I moved money from an index stock fund to government bonds. For the next two years, I kicked myself as the market hit 14,000. [more inside]
posted by CollectiveMind on Oct 12, 2008 - 15 answers

Average price of a pint of U.S. beer?

What is the average price of a pint of beer in the U.S. in 2008? What was it 10 years ago? [more inside]
posted by Gagglehack on May 7, 2008 - 13 answers

Average Salary for French Cities

I am looking for some information on average salaries for french cities. I read an article in a french magazine about a year ago but I can't find any reference to it online. Anyone know of a resource in French or English that will give me average salaries for French cities.
posted by tirebouchon on Jan 18, 2008 - 2 answers

Spreadsheet average help

I'd like a spreadsheet (OpenOffice Calc) to give me the average of the numbers in a certain row that will be filled over a period of months, and I'd like the formula for the average to remain valid even as I fill it, cell by cell. How? [more inside]
posted by regicide is good for you on Jan 14, 2008 - 7 answers

How do I clearly explain the benefits of a rolling or moving average compared to straight data?

I report on weekly sales and pricing information, and weekly data points are often skewed by one-time promotions, seasonality, and other random effects. When I create a 52-week rolling average of the data, it shows trends much more smoothly -- and accurately, I believe. My coworkers are not accustomed to seeing data as a rolling average, and I'm concerned that they won't understand it. What is a clear way to explain to them 1) how a rolling average works, 2) why it is useful for visualizing trends, and 3) any other benefits?
posted by scottso17 on Aug 2, 2007 - 10 answers

excel macro n00b

I need help writing a macro that will divide a 5000 row table into groups of 30 rows, and find the average of certain columns in each group. [more inside]
posted by beammeup4 on Jul 2, 2007 - 10 answers

calculate average speed with a start and end time

Excel Filter: How do I calculate average speed with a start and end time? [more inside]
posted by bytewrite on Jun 6, 2007 - 7 answers

Thank you and Good Night, Cleveland!

Do concerts generally sell out? [more inside]
posted by Julnyes on May 1, 2007 - 8 answers

Selecting the MODE of a group of data in Microsoft Access

Microsoft Access. An SQL "GROUP BY" query. How do I generate the mode of the values that it's grouping, when I want averages in other multiple fields? [more inside]
posted by Jimbob on Dec 13, 2006 - 3 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. [more inside]
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 ... [more inside]
posted by imposster on May 8, 2006 - 24 answers

National Car Repair Average

Is there a website that provides a National average for various car repairs. As an example what can I expect to pay to replace an alternator? What can I expect to pay to replace a fuel pump, ect? Thank you in advance!
posted by Mckoan1 on Dec 31, 2005 - 8 answers

Excel: Help give my students higher grades.

Excel Wizards (or Apprentices, Probably) Grading is upon me again and there's something I've always wanted to do in Excel automatically -- from a range of values, drop the lowest N values and average the rest. [more inside]
posted by ontic on Dec 19, 2005 - 7 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]. [more inside]
posted by RavinDave on Jul 11, 2004 - 3 answers

Page: 1