average

Averaging large amounts of data in SQL Server

It is desired to perform averaging calculations on a large set of data. Data is captured from the devices rather often and we want to get the last day's average, the last week's average, the last month's average and the last year's average. Unfortunately, taking the average of the last year's data takes several minutes to complete. I on...

Average function Excel 2000.

Hi all, I have a huge set of data which gets updated every month. I would like to check if the new data differs from previous months in %. It look like this: month name data jan 551 2 jan 552 20 dec 553 12 jan 553 13 dec 554 9 okt 555 2 nov 555 2 dec 555 2,5 So 5 names, up...

MySQL or PHP date averages

Hey, I am trying to figure out how to find the average of a number of different time values, the time values are time differences from 2 dates so they will be in the format of "hh:mm:ss". So if I had 4 time values of: 00:11:05 00:01:30 00:04:25 00:09:50 I am having trouble figuring this out. I am thinking that these time values woul...

SQLServer Calculate Average of Multiple Columns

Hi, I have generated a table using PIVOT and the ouput of columns are dynamic. One of the output is as given below: user test1 test2 test3 -------------------------------- A1 10 20 30 A2 90 87 75 A3 78 12 34 The output of above table represents a list of users ...

Simple Math Issue in C#

So i have this program that takes 3 scores out of a possible 200 each then is supposed to get the average and display the percentage. but when i input numbers i get 00.0 as an answer. What could i be doing wrong? using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace ConsoleApplication1 { c...

SQL averaging multiple time periods of the same dataset

I have the following query: SELECT AVG(val) from floatTable WHERE tagindex IN(1,2,3,4) AND DateAndTime > '$first_of_year' It returns the average value for all the values measured for those four tags for the year to date. Since I'm already retrieving this data, how can I get the data since the first of the month, since the first of the...

Fastest way to perform time average of multiple calculations in SQL?

I have a question about the fastest way to perform a SQL Server query on a table, TheTable, that has the following fields: TimeStamp, Col1, Col2, Col3, Col4 I don't maintain the database, I just can access it. I need to perform 10 calculations that are similar to: Col2*Col3 + 5 5*POWER(Col3,7) + 4*POWER(Col2,6) + 3*POWER(...

Python - Fastest way to find the average value over entire dict each time it gets modified?

I'm trying to find the fastest/most efficient way to extract the average value from a dict. The task I'm working on requires that it do this thousands of times, so simply iterating over all the values in the dict each time to find the average would be entirely inefficient. Hundreds and hundreds of new key,value pairs get added to the dic...

MySQL - working out the AVG for a subset of MAX values

Hi all, I have a table with columns 'Date, Name, Score'. I wish to get the MAX(Score) for rows which share a common value (for e.g. the same date or even name), before averaging them to give me a figure, for example: ---- Date -----| -- Name -- | Score 2010-10-10 | John Smith | 86 2010-06-05 | Tedi Jones | 71 2010-10-10 | John Smith |...

Calculate average without being thrown by strays

I am trying to calculate an average without being thrown off by a small set of far off numbers (ie, 1,2,1,2,3,4,50) the single 50 will throw off the entire average. If I have a list of numbers like so: 19,20,21,21,22,30,60,60 The average is 31 The median is 30 The mode is 21 & 60 (averaged to 40.5) But anyone can see that the ...

Easy way to compute Queries Per Second value, based on log, with shell

We're able to tail the traffic on a server that we host : ... +1287737841.266952 ... +1287737841.267117 ... +1287737841.267136 ... +1287737841.278288 ... +1287737841.278310 ... +1287737841.278321 ... +1287737841.278331 ... +1287737841.278341 ... ... As you can see they include timestamps, down to the micro-second! I just want to be ab...

General - Is there a way to calculate an average based off of an existing average and given new parameters for the resulting average?

Lets say, we're calculating averages of test scores: Starting Test Scores: 75, 80, 92, 64, 83, 99, 79 Average = 572 / 7 = 81.714... Now given 81.714, is there a way to add a new set of test scores to "extend" this average if you don't know the initial test scores? New Test Scores: 66, 89, 71 Average = 226 / 3 = 75.333... Normal ...

averaging event values associated with date values by hour, day, etc..

I have a bunch of events with values (how many people went through a doorway). Each event is associated with a Date. There is no fixed period to the events .If no one comes through the door, no event is generated, but often multiple people can go through at once, so the value can be greater than one. Sometimes events are minutes apart f...