## What can a rolling average show?

Accounting filter: What can a rolling average reveal?
posted by LonnieK on May 21, 2016 - 6 answers

## Basic statistics question

I have the results of a survey, along with a couple of basic descriptive statistics. I'm trying to determine how they were calculated and my one semester of stats isn't holding up. Could you help? Details inside.
posted by Think_Long on Dec 4, 2015 - 14 answers

## On average, how many people live in a city block in New York City?

I am looking to find out the average # of residents on a block within the 5 boroughs. The hard part is finding out how many blocks are in a square mile. The estimates of how many blocks are in a square mile varies a lot. Do you have any idea of how many people on average live in a city block within the 5 boroughs? Thank you for your help!
posted by rageagainsttherobots on Sep 5, 2015 - 11 answers

## 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

## 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?
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?
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?
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?
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?
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?
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.
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.
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?
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)?
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
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?
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?
posted by jnnla on Oct 21, 2009 - 18 answers

## Excel AVERAGE questions.

Trying to get some modified AVERAGE results in Excel.
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)?
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?
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?
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?
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.
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?
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

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?
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.
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?
posted by bytewrite on Jun 6, 2007 - 7 answers

## Thank you and Good Night, Cleveland!

Do concerts generally sell out?
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?
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.
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

## 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.
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].
posted by RavinDave on Jul 11, 2004 - 3 answers

Page: 1