Questions tagged [average]

Averages summarise a set of values in one way or another. Without further qualification it most commonly refers to the arithmetic mean, but other averages such as root-mean-square exist.

In its most general definition, an average is a summary of a set of values. Normally it refers to the arithmetic mean, but other means may be employed (geometric, harmonic, etc.) or a transformation may be applied before and after taking a mean (e.g. root-mean-square).

1629 questions
0
votes
0 answers

Add a point to shift the average position without knowing the current average

I have a set of 3D points. I can get the position of any 1 point, but there's too many for me to calculate the average by hand. I'm only able to get the average when the average coordinates are all a multiple of 500 (I'm using a visualizer program…
0
votes
1 answer

How to calculate average rate from a dataset

I have a large dataset of "trips", each row is a different trip. I want to know the average number of miles per day for a group of trips. Example data: Trip 1: 500 miles in 30 days (16.7mi/day) Trip 2: 200 miles in 10 days (20mi/day) Trip 3: 30…
Anna
  • 1
0
votes
1 answer

Average amount needed for x number of months remaining

I'm trying to calculate the average amount of profit needed to hit a milestone based on the number of months remaining. So let's say the goal is £1,000 and there are 5 months left. If I have £400 currently how can I calculate how much needs to be…
user90311
  • 3
  • 1
0
votes
1 answer

Is there a way to calculate average for a timeframe, given the avg at the beginning and at the end of it

So, I am keeping an average value using the incremental averaging approach. I have some "saves" of this average value, along with its samples count. Is there a way to calculate the avg for a timeframe between two of those "saves"? E.g. let's say I…
Kiramm
  • 101
  • 3
0
votes
2 answers

Is it possible for the average of 2 sets of numbers to be higher than the average of the combined set?

Say I have 2 sets of numbers with an equal number of values: a,b,c d,e,f Is it possible for mean(a,b,c,d,e,f) to be significantly lower than mean(mean(a,b,c),mean(d,e,f))? I have 2 large data sets where this is happening and I need to know whether…
0
votes
0 answers

Choose between simple average vs. average of averages to calculate average open rate of mails?

Not sure if this is the right place to ask, but I'll try: What's the right way to calculate the average open rate of mails: simple average? average of averages? For example, if we have: First mail, that was sent to 100 contacts, and opened by 10…
HeyJude
  • 262
0
votes
0 answers

find average speed of a journey

The question in the pic is askin for average speed of the journey. Should the speed be calculated as (speed1+speed2+speed3)/3 or total distance /total time? Why?
0
votes
1 answer

Generate a distributed set of N numbers between a given min and max, with a given mean.

Is it possible to generate a set of N numbers between a given min and max that will average to a given mean. eg-1. Generate a set of 30 numbers from 20 to 650 with an average (mean) of 260. eg-2. Generate a set of 51 numbers from 360 to 8746 with an…
0
votes
1 answer

Find the number of people, average of age

The average age of a group of persons going for a picnic is $16.75$ years. $20$ new persons with an average age of $13.25$ years join the group on the spot due to which the average of the group becomes $15$ years. Find the number of persons…
Joypal
  • 170
0
votes
1 answer

Is my average of averages correct in this particular case?

I read many times that averaging averages leads to errors, but here is my problem : I'm trying to make a game simulation where a player is delving into a dungeon fighting monster—one monster per level. The player can resurrect two times, restarting…
0
votes
1 answer

Calculating the weighted average with a minimum

I'm looking for a way to calculate the weighted average of a range of numbers, but where the lowest need to be 5% (and thus the total still needs to be 100%). Let me try to explain: [ 0.98077, 0.99038, 0.99279, 0.99279, 0.99519 ] Weighted average…
0
votes
1 answer

Calculate Sarah's Minimum Score

Question: In order to graduate, Sarah has to make an average score of at least 90. If he made 95 and 94 on his first two tests. What should his minimum score be on her final test in order to graduate?
0
votes
0 answers

Is it possible to calculate the total average between two sets of numbers, without just using the sum of each set of numbers?

I'm working with some really frustrating reporting software that doesn't let me calculate the average by dividing two sums. To get around this, I need to find a way to get the same result by calculating the average of each value that makes up the…
0
votes
1 answer

average/weighted average within Excel

5 star 128 4 star 17 3 star 10 2 star 2 1 star 14 Average stars 4.42 How many more 5 stars would I need to get Average Stars to 4.45 or 4.47 etc. So what I tried was using SUMPRODUCT in Excel but I am approaching this wrong. First…
CQM
  • 103
0
votes
1 answer

Given the mean of three numbers and the value of one of the numbers, is it possible to determine the values of the other two numbers?

Given the mean (average) of three numbers and the value of one of the three numbers, is it possible to determine the values of the other two numbers? For example, given the average of numbers x, y, and 21 is 23, is it possible to find the values of…