Stack Overflow
Stack Overflow

Questions tagged [average]

In mathematics, an average is a measure of the "middle" or "typical" value of a data set. Different types of averages include the arithmetic mean, the median, and the mode.

In the most common case, the data set is a list of numbers. The average of a list of numbers is a single number intended to typify the numbers in the list. If all the numbers in the list are the same, then this number should be used. If the numbers are not the same, the average is calculated by combining the numbers from the list in a specific way and computing a single number as being the average of the list.

Many different descriptive statistics can be chosen as a measure of the central tendency of the data items. These include the arithmetic mean, the median, and the mode. Other statistics, such as the standard deviation and the range, are called measures of spread and describe how spread out the data is.

See also: , ,

5780 questions
1
vote
1 answer

dplyr. Spectral (reflectance) dataframe. Average all spectral values based on a single attribute . R

I have a dataframe which is made of 5 attributes (e.g. Plot, weight, date etc) plus 2000 spectral values (different wavelengths). Thus, there around 2005 columns. For these columns, there are 120 measurements (24 objects * measured 5 times). I am…
Gustavo TA
  • 27
  • 3
1
vote
2 answers

How to take an average of cells that are split apart consistently in excel?

I would like to take an average of the cell every 7 cells. For example, I want to take the average of Cell A1, A8, A15, A22 etc. Then another average of A2, A9, A16, A23 etc. How can I do this quickly as I have a large data set. Thanks
Rezzy
  • 111
  • 1
  • 2
  • 10
1
vote
0 answers

Calculating an average time value between 2 timestamps across an entire table of data

I have a table, that has a unix timestamp field for start and end of a process. I have seen a number of suggestions that appear to calculate averages unsing Datediff, but as I am using unix timestamps, this isn't necessary, is it? I can calculate…
Sean in NZ
  • 11
  • 2
1
vote
2 answers

How to get 2nd AVERAGEIFS formula to takeover if 1st AVERAGEIFS formula doesn't work (Google Sheets)? (Use IFERROR or SUMPRODUCT??)

I'm trying to get an AVERAGEIF a few conditions are met (from another sheet: SHEET1). If the conditions aren't met, then I want a different AVERAGEIFS formula to go into effect. Not sure how to combine these two arguments. They work fine on their…
que syrah sarah
  • 231
  • 1
  • 4
  • 14
1
vote
1 answer

Average Based on Column Headers between certain numbers

So this has been a challenging problem for me. I am trying to get Excel to do an average over a period of time based on what is in the column header. So here's the column header that I'm talking about: This is where the (Result) should go. And…
resonance1
  • 97
  • 14
1
vote
3 answers

Correct query to get average from top 5 of 7 days?

I'm tracking number of steps/day. I want to get the average steps/day using the 5 best days out of a 7 day period. My end goal is going to be to get an average for the best 5 out of 7 days for a total of 16 weeks. Here's my sqlfiddle -…
Tim M
  • 306
  • 3
  • 18
1
vote
2 answers

how to calculate the percentage of match / absolute value

hard to explain...let me try: I built a script that compare two users' interests (hobbies) let's assume userA have 44 hobbies, and 13 in common with userB (who has 19 hobbies) so in pseudo code (where % is my formula): func %(userA,userB) =…
Francesco
  • 24,839
  • 29
  • 105
  • 152
1
vote
2 answers

SQL AverageIFS Equivalent for Query

So I'm extremely new to using SQL. This syntax formatting is offensive but I am editing it in notepad and can't figure out a better alternative. I want it in the .dqy format but I don't know how else to edit. So if you have a suggestion please…
Matt Cottrill
  • 152
  • 1
  • 1
  • 15
1
vote
1 answer

Find the value in an array that is closest to the average ~ with given JUNIT test

Here is a problem given to me. The challenge for me is knowing how to find the AVERAGE from an array list and the value in the array that is closest to that average. All by writing code that can execute this with any array given in the test. Here's…
KomputerSci
  • 15
  • 4
1
vote
2 answers

SQL query yielding count and average

I have two queries. One yields the total number of records for a specific procedure type. The other yields the number of records for that specific procedure by the species I am trying to figure out how I can take and get both the number of counts…
Daniël Cronk
  • 65
  • 5
1
vote
1 answer

Earth engine; SST by month and by year

I'm trying to plot a chart and get data from Google Earth Engine. I'm using MODIS-Aqua/L3SMI data in Earth Engine. I have used Earth Engines in built functions to compare average sea surface temperatures by day of year per year. However, it's pretty…
mikejwilliamson
  • 405
  • 1
  • 7
  • 17
1
vote
2 answers

how to find average for consecutive four months for preceding 12 months in oracle 12c

I need to find 4 consecutive months for preceding 12 months using Oracle 12c Original Output: Month Consumption 01/04/17 10000 01/05/17 10000 01/06/17 10000 01/07/17 13000 01/08/17 11000 01/09/17 12000 01/10/17 10000 01/11/17 12000…
Poovendan
  • 25
  • 1
  • 5
1
vote
3 answers

In MySQL is there some way to calculate average with a list of numbers?

I would like to do something like the following: SELECT AVG([1,2,3]); This would of course return 2. The closest I've got is the following which is less than ideal but can be put in one line: drop table nums; create temporary table nums (num…
loco.loop
  • 1,441
  • 1
  • 15
  • 27
1
vote
1 answer

Average Formula error

I am trying to work with an average formula, that includes a few other average formulas within. The results of my formula are either a numerical value, or 'FALSE'. When I highlight the 8 values I get the correct average calculationin the example…
ConorCK
  • 11
  • 3
1
vote
2 answers

Average the sum of rows without a creating new column in Excel

Here's a sample of my matrix: A B C D E 1 0 0 1 1 0 0 0 0 0 0 0 1 1 0 0 2 1 You can think of each row as a respondent and each column as an item on a questionnaire. My goal is to take an average of the…
PyjamaNinja
  • 293
  • 2
  • 8
1 2 3
…
99
100