##
37 posts tagged with average.

Displaying 1 through 37 of 37. Subscribe:

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

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

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

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

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

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

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

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

## I Feel So Average

I feel so average and uninteresting. What can I do to remedy this situation? [more inside]

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

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

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

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

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

How can I generate an "average image" from 200 photographs? [more inside]

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

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

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

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

When is it actually worth it to attempt to do any better than average? [more inside]

## Excel AVERAGE questions.

Trying to get some modified AVERAGE results in Excel. [more inside]

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

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

## Meta-Median from other medians?

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

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

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

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

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

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

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

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

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

## Thank you and Good Night, Cleveland!

Do concerts generally sell out? [more inside]

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

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

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

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