Questions tagged [average]
The average tag has no usage guidance.
31
questions
3
votes
2
answers
306
views
Find the AVERAGE amount that an employee stays with company
I'm trying to find the average time that an employee is employed with my company. Right now I have calculated the time for each terminated person individually and have it displayed as years, months, ...
2
votes
3
answers
928
views
Average of rows averages does not equal average of whole table
I am averaging a group of numbers in Excel 2007 that have 21 columns & 42 rows. When I average all the cells at once I get one result, 59.25183, but when I average each row & then average ...
- 21
2
votes
0
answers
964
views
How to calculate average number of days, hours and minutes in excel
Can anyone help me please to calculate the average number of days, hours and minutes in excel? It is to calculate the average time taken to complete maintenance jobs.
To start I merged the date and ...
1
vote
1
answer
4k
views
How can I stop AVERAGEIF formula returning #DIV/0
I have the following formula returning #DIV/0! when all 5 cells are blank:
=AVERAGEIF(CV17:CV21,">0")
Spreadsheet image
This is being used to average call time over the period of a 5 day working ...
- 15
1
vote
2
answers
3k
views
How to find the average time from an array in PowerShell
I am referencing a list which has a lot of data in the form of the elapsed time of a process and I'm trying to convert it to a format where I can find the average amount of elapsed time.
The data ...
- 853
1
vote
1
answer
46
views
Excel/Sheets: Average only the input data in a range of data?
I've got an annual budgeting spreadsheet in which each month is listed along with given categories of items. I'm trying to find my average monthly expenditure on any given category, but don't know the ...
1
vote
1
answer
1k
views
Excel formula to average out numbers based on repetitive values
I have been trying to average out values in column 1 into the values as mentioned in column 2. For example if:
there are 10 12100 values, so individual average is 1210
There are 5 4550 values, so ...
- 11
0
votes
2
answers
67
views
Calculate a moving average in excel where the lookback (window) duration is a variable that changes based on another cell's changing values
I am trying to calculate a moving average of a dataset where the moving window time duration is not fixed, but changes over time based on numbers in a different column. Using the screenshot I have ...
- 15
0
votes
2
answers
183
views
How to find average with my condition in Excel?
Let's say that this is my bank statement for July 2020:
Sl. No.
Tran Date
Withdrawal
Deposit
Balance Amount
1
01-07-2020
100
100
2
02-07-2020
5
95
3
03-07-2020
500
595
4
06-07-2020
50
545
5
...
- 515
0
votes
1
answer
36
views
Windows Microsoft Excel : How to average over the columns
I know there are already a few questions about averaging in excel on the SE, but I looked at them and didn't really understand what to do (I'm just starting using excel)...
I have a file with columns ...
- 105
0
votes
2
answers
9k
views
Excel: How to calculate average difference between values in a row?
I have a row of numbers, say, 1 2 3 (each number is in separate column, of course). I want to calculate the average difference between all values. This means that I would calculate all the differences:...
0
votes
3
answers
54
views
Problems with average in Excel
My problem is the following:
I have a list of 12 numbers and I want to do the average of the 10 biggest numbers. I thought about using the MIN function, but I don't know how to use it.
Someone can ...
- 101
0
votes
2
answers
1k
views
Excel, AVERAGE, SUBTRACT
In Excel;
I want to calculate an average of three values and to find a difference between result and a value in another column. I want the difference represented as a positive number.
R25 is -2.00;
...
- 1
0
votes
2
answers
797
views
Excel: How can I get the most recent 3-month average, but not use blank months?
Hi people better at Excel than me! I appreciate any help you can offer. I’ll try to be brief:
I have a 3-column table. Month (as 1,2,3,etc…), Salesperson Name, and Sales. Each row is how many $ in ...
- 3
0
votes
1
answer
327
views
Finding average between two dynamic range
I have to find the average of a column B by giving a dynamic range for column A.
I want to calculate the average by changing ranges from D2 & E2.
Is there any way of achieving this?
0
votes
2
answers
2k
views
Average calculation for multiple non adjacent columns with criteria
I am trying to build a quarterly report with avg numbers for each physician and avg for specialty. i wanted to use the avgs to compare to compare how the physician performance on these metrics ...
- 1
0
votes
2
answers
688
views
Grouping function in excel
I'm fairly new to Excel and can't find how to formulate my question, so sorry if this has been asked before.
The data I have contains information on literacy, employment and income per hour for ...
- 133
0
votes
2
answers
737
views
Average of multiple numbers - Shell script
I have created a script which views a logfile and greps for a specific amount of milliseconds / seconds. I have created something which views the minimum and maximum value however I need to find the ...
- 1
0
votes
1
answer
461
views
Ignore blank/0 values in AVERAGEIF with two ranges
Trying to calculate average waiting time but, need to ignore blank or 0 value cells.
For example, here i'm calculating time difference between H column and G column and getting the average. However, ...
0
votes
0
answers
119
views
Averaging film transfer from 59.94fps to 24fps using ffmpeg?
I have some video files which were transferred from black-and-white film to 29.97 fps interlaced. The film was transferred too darkly (meaning that it requires some brightening), and it also has some ...
0
votes
1
answer
158
views
Excel formula for calculating average of 52 cells out of possible 104 where blank cells exist
I have a significant amount of rows of data showing earnings per week for over 104 weeks with various blank cells.
I am looking for a formula that would average only the latest 52 cells that have ...
0
votes
1
answer
32
views
How can I complete a column with a function with a key of another column
I'm trying to calculate a weighted average for thousands of students.
I can do this for individual learners in turn (SUM PRODUCTS).
The problem is I don't know how to do this for thousands of students ...
- 1
0
votes
1
answer
161
views
How to Calculate the Average after a certain date
Im trying to get the average of days taken to send to college but i only want it to take in to consideration dates received after 17/05/2021.
can anyone help
0
votes
1
answer
327
views
Pivot table averge by total number of months
I have an excel data table which have these colomns,
Purchae date
Item name
Quantity
Sipplier name
Now i want to get average of quantity by total number of months.
I.e quanty sum is 50 and this is ...
- 1
0
votes
1
answer
5k
views
Excel: Averaging 2 columns with a PivotTable
Data example:
Year
Activity
L
H
2019
x
5
9
2015
z
1
0
2015
x
5
4
2020
z
4
5
2020
y
7
3
Using a pivot table, I can average L by "Activity" and average by "Activity" looks ...
- 143
0
votes
1
answer
164
views
Excel: How to change column to average based upon unique identifier
I have a situation where for a certain daily date range I have 5 different columns of data which are for 5 different pieces of equipment. I'm trying to set up a calculator where I can select the piece ...
0
votes
1
answer
25
views
Averaging time after converting to Seconds
I have a list of times it takes to review reports
I am averaging time by this method:
Multiply the individual times by 86400 to convert to seconds (example, 00:11:36*86400=696)
Then, divide the total ...
- 1
0
votes
1
answer
136
views
How to get the average with intervals?
So I have a dataset of monthly stock returns from January 2000 until today for six different stock indices. At the bottom of the page, I want to show the return across the year as a percentage. When I ...
- 11
0
votes
2
answers
2k
views
Excel formula for calculating average of duplicates
I have certain repeated values in the first column. I want to average out those values based on the number of times they are repeating themselves. I want the results in the adjacent columns.
...
- 11
0
votes
1
answer
631
views
How to plot longitudinal data in R
I am trying to plot longitudinal data in R. My data frame has this form:
participant_ID group S1 S2 S3 S4 S5 S6 S7 S8
1 ctrl 14.00 14.00 13.00 13.00 7.00 8.00 4.00 1.00
2 ...
- 3
0
votes
4
answers
4k
views
Easier way to calcuate average change?
I have a product that is getting sent out to the field as it is manufactured and used daily, the use rate changes from day to day based on how the job is going.
I am trying to calculate the average ...
