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.
average
5,830
questions
0
votes
0
answers
30
views
Adding Average at the very last part of the row and column in a dataset
I have a sample dataset of total outbound calls, it comprises rows (dates) and columns (hourly), my goal is to show totals and average of outbound calls per day (rows), and the totals and average of ...
0
votes
0
answers
6
views
Wireshark IP Source & Destination.txt file each column meaning? [closed]
May I know the meaning of each column in Wireshark "IP Source & Destination.txt" file?
Sorry I am quite new to IT. Thanks in advance.
IPv4 Statistics/Source and Destination Addresses:
...
0
votes
0
answers
14
views
Comparing an individual's performance to group average in DAX
I need to be able to compare an individual’s measure (e.g. Number of assigned cases, Average age of case) against the larger group average (e.g., for a management team, program, all investigators).
...
0
votes
1
answer
15
views
MS access average of four values linked to a date and time
How can I combine the temperature values that has been measured every quarter in an hour to just one average value per hour? I want to make a query in MS Access. Can you provide a SQL to do this?
...
1
vote
2
answers
41
views
How do I get a daily average for data points generated every 15 minutes?
This is my first question and I'm also a very new learner to r so please bear with me. I am working on some gauge data from about 4 months and it took temperature readings every 15 minutes. I am ...
2
votes
1
answer
70
views
Calculation of Average Queue Length in a Simple Queueing Model [closed]
Why does the average queue length in a single-queue system tend to infinity when the average number of arrivals equals the average number of departures?
Define the queue model parameters:
λ: Average ...
1
vote
0
answers
41
views
Implementing Continuous Averaging Memory for White Noise Signal in Simulink
I'm currently working on a project where I need to develop a continuous averaging memory to compute the average frequency spectrum of a white noise signal. The goal is to achieve a Degree of Freedom (...
1
vote
3
answers
57
views
How to find the average of two columns but if one value is null, then only show me the other value?
I have a table where I want to find the average value of column1 and column2, but in some cases there may be null values in either columns. In that case, I just want to be shown the value that is NOT ...
0
votes
0
answers
60
views
Keep a running average of upload/download speeds in python
I'm currently trying to adapt a script that shows network stats like upload and download speeds for each process we can detect using a network; the original script is described here (https://...
1
vote
2
answers
70
views
How to aggregate multiple transactions to show complete trades in one row in Google Sheets? [duplicate]
I have a table in Google Sheets that logs individual transactions for various stock symbols, structured as follows:
I want to aggregate these transactions to show complete trades in a summarized ...
0
votes
0
answers
30
views
PowerBI measure with filter logic over date does not work
I have the following tables TradingKPIs and TradingKPIs_Prices, which are linked to each other via the table TradingKPIs_Dates with the column colValToday.
The table TradingKPIs_Prices contains ...
1
vote
1
answer
72
views
Can I use CTE in SQL Server to calculate average utilization rate for months in which customer utilization activities were conducted
I have an exam about creating a list of a company's customers whose utilization rate is low (meaning company needs provide customer services), in SQL Server. I tried many times, but it never worked. ...
2
votes
1
answer
63
views
create an average distance matrix based on matching prefix column and row names in R
I want to create a new distance matrix from an array of hundreds of distance matrices. This new matrix will be the average distances given a set of pairwise distances. The values to be averaged is ...
0
votes
1
answer
57
views
Calculate the average of multiple columns within a collection - powerapps
I have a collection within a powerapps canvas, where I am trying to calculate the average of any entries within multiple columns.
Specifically, I want to find the average of the values within the 2nd ...
1
vote
1
answer
43
views
How to spread a narrow range of values into a wider "score range"?
I have generated a series of percentages to summarize the performance of various counties across the country based on a few metrics. I'd like to use these "County Percentage" values to give ...