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]
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]
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?
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? [more inside]
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 and uninteresting. What can I do to remedy this situation? [more inside]
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]
How do I, using Excel, determine the frequency of orders, the minimum/maximum amount per customer and the average order size? [more inside]
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]
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? [more inside]
In what popular magazine did I first read about the 1990 study "Attractive faces are only average" (I think that was it)? [more inside]
Please provide me with an *effective*, and statistically sound, table/chart listing suggested sample size guidance for associated population size [more inside]
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]
When is it actually worth it to attempt to do any better than average? [more inside]
Trying to get some modified AVERAGE results in Excel. [more inside]
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]
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]
[Statistics Filter]: What's the best way to calculate a meta-median? [more inside]
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]
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]
What is the average price of a pint of beer in the U.S. in 2008? What was it 10 years ago? [more inside]
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.
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]
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?
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]
Excel Filter: How do I calculate average speed with a start and end time? [more inside]
Do concerts generally sell out? [more inside]
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]
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]
Grading dilemma: Can the median be a fair measure of a set of quiz scores? Here's the situation ... [more inside]
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 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]
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]