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

Trigger or event to get average from another table

ratings_table ------------------------- id(PK) color(FK) rating ========================= 1 green 5 2 green 2 3 blue 4 4 yellow 4 5 blue 3 colors_table: --------------------- color(PK) …
TheFurgeurge
  • 23
  • 3
1
vote
1 answer

Why is there no average in latency stack traces?

When I open a .jfr file(Java Flight Record) with Java Mission Control, I can find 'Stack Trace', 'Longest' and 'Count' in Thread -> Latencies -> Latency Stack Traces tab. I care about the average but not the longest. There's average in Java…
lamplet
  • 103
  • 1
  • 1
  • 8
1
vote
0 answers

MDX Calculating 12 month average unit price and applying to forecast quantity

I have a requirement to show a report which calculates the average selling unit price of each product and then multiplies this average by the number of units forecasted to sell in the next year (for each product). At this point my main issue is…
Jon Hilton
  • 173
  • 2
  • 15
1
vote
1 answer

Calculating the average of specific numbers in a mixed text file?

I have a program that reads a file that has student names, IDs, majors, and GPAs in it. For example (there is much more to the file): OLIVER 8117411 English 2.09 OLIVIA 6478288 Law 3.11 HARRY 5520946 English 1.88 AMELIA 2440501 French 2.93 I have…
Marina
  • 13
  • 4
1
vote
2 answers

Produce an output that is the average letter in the string using charAt method and type-casting

I need to create a program that reads in a random word using a prompt. The program needs to produce an output that is the average letter in the string. If the average of the letters was 97.2 display a small a, but if the average of the letters was…
kali
  • 21
  • 4
1
vote
1 answer

Having trouble with averageifs exception on a dataframe

I have the dataframe successfully performing the equivalent of an averageifs statement in excel, but I don't know how to add this "exclude" syntax. I want the average of all Units_Ordered for that Customer_Number and Product, except on that…
Matt Cottrill
  • 152
  • 1
  • 1
  • 15
1
vote
1 answer

Day and night average per day in R

I have a data set from april to october with registered data every 5 minutes per day. I want to get the average temperature and RH of day and night for every day, considering "day" from 7:30 to 18:30 and "night" for the rest of hours, The table…
Miriam Hernández
  • 11
  • 2
1
vote
1 answer

Excel 2017 Formula - Average data by month, while being filterable

I'm not a VBA coder, and I would prefer an excel formula if possible, the easiest solution will be the best one. Test workbook screenshot As you can see, I have plenty of columns, which are filterable. I am attempting to retrieve an average of…
Alexander Rhodes
  • 25
  • 4
1
vote
2 answers

Aggregating data with NA values based on site

I am using the EPA NLA dataset to find the average temperature in the epiliminion for some lake data. The data set looks like this: SITE DEPTH METALIMNION TEMP FIELD 1 0.0 NA 25.6 1 0.5 NA 25.1 1 …
atosbar
  • 35
  • 6
1
vote
1 answer

Average of different layer and several netcdf files with R

I have 15 netCDF files (.nc) for each year from 2000 to 2014. In one nc file, I have hourly data of one variable in 8760 layers. The 3 dimensions are: time (size 8760), latitude (size 90) and longitude (size 180) (2° resolution). I want to compute…
virginie
  • 35
  • 7
1
vote
1 answer

How can I make a grade that doesn't fit the parameters not count towards the class average?

print('Hello, welcome to your grade calculator.') GradeCount=0 totalGrades=0.0 moreStudent='y' while moreStudent=='y' or moreStudent=='Y': grade=float(input('Enter a grade or a -1 to end: ')) while grade !=-1: if grade>100 or…
coco
  • 79
  • 3
1
vote
1 answer

Average ignoring NA values in excel

I have a column H of temperature values, and I want to create a new column T, with the average of the column A values with a step of 6. The command I used is this one: =AVERAGE(OFFSET($H$2;(ROW()-ROW($T$2))*6;;6;)) The problem is that even with…
Kon Ath
  • 183
  • 1
  • 2
  • 13
1
vote
2 answers

AVG interval length for table with purchases

I would appreciate help with a table that is looking like this: client_id | transaction_date | amount ------------------------------------- 123 | 2017-01-16 | 12 234 | 2017-01-11 | 25 345 | 2017-01-12…
Jak To
  • 13
  • 2
1
vote
1 answer

How to bin time point and average the data for several subjects?

Here is my file: time3 is going from around -3600 to +400-600ms. I need to bin this time3 in 20 seconds window with the 0 time point staying as 0 and not being in the middle of a window. Then I need to do a mean of reSYS for each 20 sec windows.…
Virginie
  • 67
  • 5
1
vote
1 answer

Javascript - Calculate HTML Table Column AVG Value In Javascript isn't working

Working in Laravel. I need to calculate the avg of "Cost" But this is not working. Here is my code:
yassine j
  • 495
  • 1
  • 11
  • 27
1 2 3
…
99 100