Questions tagged [average]

Average most often refers to the arithmetic mean, but more generally to measures of central tendency that use most, or all, of the data values. Examples include trimmed mean, Winsorized mean, harmonic mean and geometric mean.

Filter by
Sorted by
Tagged with
0
votes
0answers
3 views

Weighted average based of incoming volume and AHT per case in seconds

I want o calculate the weighted average for the AHT column in the below data Date Volume AHT per case in sec 1/2/2019 7188 44 sec 2/2/2019 453 123 sec 3/2/2019 345 563 sec Like this i ...
0
votes
0answers
24 views

Can I average yearly data prior to regression? [on hold]

I have a simple problem where I suspect a linear relation between two variables. I have many years of observations. First i started to average my variables over the years and proceeded to the ...
0
votes
0answers
18 views

Survey Question Validity

I have a survey that asks the user to report their debt from their undergraduate education and their debt from their graduate education. I intend to add these two averages to measure their average ...
0
votes
0answers
6 views

Predict with average values of dependent features

I created linear regression model to predict story points by individual team member (in sprint). Since story points are relative by sprint team, I trained my model after scaling story points to 0 - 1 ...
1
vote
2answers
43 views

Expressing Confidence Intervals as a percentage for simplicity

I am running some stats on a feeding experiment where 6 rodents were given the choice between control seeds and treated seeds for 12 hours. seed count consumed was the response variable. I've analyzed ...
0
votes
0answers
19 views

How to combine multiple (facial recognition) feature vectors into one feature vector

I am writing a facial recognition library in C++ which performs inference to generate feature vectors. When I provide my machine learning model with image data, I receive a features vector of length ...
0
votes
1answer
19 views

Two formulas giving slightly different output

I am struggling to find a proper explanation why the two methods that I use for finding the difference in EXCEL are giving me two slightly different numbers. The idea behind the task is that we have ...
0
votes
0answers
27 views

Average of correlations over time

I currently work on my bachelor's thesis and analyse the correlation between 13 countries over a time period of 117 years. I built a correlation table and now want to say somethin about the average ...
0
votes
0answers
22 views

Choosing the best aggregation location measure

I'm trying to analyze a granular dataset that is composed as follows: ...
0
votes
1answer
24 views

Proof that covariance of RV and group average is less than variance of RV

I have a random variable $X_i$ and a group of $N_j$ other random variables that includes $X_i$. Let's just call this group $J$. There are no distributional assumptions made on these RVs (other than ...
14
votes
1answer
1k views

What is the name for the average of the largest and the smallest values in a given data set?

What do you call a statistical mean that is calculated from upper and lower extremes in any given dataset? For example, if you have a set: ...
0
votes
0answers
28 views

calculate the average visits and running days

What do I've got? I have received a huge data from a real estate portal. It contains more than 50 million rows and data for over 10 years. In addition to the rental prices and other parameters (...
0
votes
0answers
12 views

Average with ability to configure importance of peak values

I have list of numbers (about 200 numbers), where almost all numbers are in range of 100 - 10000, but some numbers (very few, ...
0
votes
2answers
32 views

two ways to compute average prices

I am doing some simple math computation. I have three variables: Goods, total price, and total unit (See below). All I wanted to do is to compute the average price per unit. Method 1 I computed ...
4
votes
1answer
58 views

Minimum number of observations in order to trust a difference?

I'm doing an experiment to measure a very small number. For example, first I expect a measurement to be 10.0005 and then after introducing a variable, I expect the next measurement to be 10.0007 ...
0
votes
1answer
20 views

Calculating Average trend with possible missing data

I am conducting a research on a group of subjects with population about 90. For each of them I have a time-serial datapoints such as: ...
0
votes
1answer
10 views

Determining which methods to use to find how close a day is from the average pattern

Would anyone have advice on how to determine how close a day is to matching the average pattern of all days? I would like to take each day of the year and evaluate how close that day is from the ...
1
vote
0answers
29 views

Is the weighted average of growth rates equal to the growth rate of a weighted average?

More formally, is the following statement true? Let $\alpha$ be between 0 and 1. \begin{equation} \alpha\frac{(A_t - A_{t-1})}{A_{t-1}}\ + (1-\alpha)\frac{(B_t - B_{t-1})}{B_{t-1}}= \frac{(\alpha ...
0
votes
1answer
35 views

How to calculate weighted average of hourly sales in a day

I have hourly sales data & want to aggregate it to a day level. Out of 24 hours, we are classifying 6 hrs as peak hours and 18 hrs as non-peak. Assume peak hr sales for a day as: $X_1,X_2,\ldots,...
-1
votes
1answer
26 views

Calculating an average

Hi I’ve got a quick question. On statistics. I ran a survey in which I asked respondents how many hours of quality time they spend with their family per week . I also asked them what percentage of ...
1
vote
0answers
33 views

PCA as scaled average of original variables

Let $X_i=(x_{i1},...,x_{ip})$ be a vector of $p$-dimensional $n$ observations. Suppose that we apply principal component analysis and find the $p$ principal components. Also, suppose that the $p$ ...
0
votes
1answer
32 views

Average of marks in examinations

Is it statistically correct to find out final marks of a student in a paper by taking arithmetic mean only of 4 valuations of a single paper without an answer key, or any rectification measures for ...
1
vote
1answer
76 views

Estimating the population median from a kernel density estimator

I have a 1-d kernel density estimate in the form of two vectors: x_grid is a vector of x-values at which the density function was sampled ...
0
votes
0answers
14 views

How to penalize for empty fields in DataFrame?

I have to calculate the consistency of racing car drivers during the whole season. My DataFrame consists of 10 columns (10 circuit names) and for each of those columns I have the standard deviation in ...
1
vote
0answers
21 views

Statistical methods for assigning weights based on rank differences?

I have encountered methodological problem in my pursuit of my master's degree, and I hope you can help! I know exactly what I want to do, but I do not know which statistical area this is related to. I ...
2
votes
0answers
18 views

Assumption testing for a large amount of individual regression models and averaging R-squared?

I am running the following model for my thesis, a simple regression: \begin{equation} y_{i,t} = \alpha_t+\beta_tx_{p,t}+\varepsilon_{i,t} \end{equation} where Y is an observed variable (...
1
vote
1answer
38 views

Statistical uncertainty in average of continuous variable, where values are not expected to be the same

I have been trying to understand statistical uncertainties on measurements made, I have found many partial sources, but they seem to either deal with simply counting whether something happened or not ...
0
votes
0answers
11 views

How to weight values for a weighted average

I have 100 answers regarding production times in minutes of a certain product from 100 manufacturers around the country. I also know if these companies have met any of the 3 quality standards relating ...
2
votes
0answers
79 views

Weighted average of averages or average of weighted samples?

I have to estimate the average amount of goods that will be produced by machines per resource unit. Each machine will be working in one of two modes (A or B) and I know their proportions ($p_A$ and $...
1
vote
2answers
71 views

The correct formula for weighted average

The formula for a weighted average is: sum of values, multiplied by respective weights, divided by count of values. Right? That’s what I thought it was until I saw other variations, which are ...
0
votes
0answers
21 views

Given an average and a maximum, how determine the minimum range

Suppose that we have $k$ non-negative values. We know the average $A \in \mathbb{N}$ of these values and we know that the maximum value is $M$ (not necessarily $\in \mathbb{N}$) we don't know the ...
0
votes
0answers
15 views

Retrieving instantaneous information from average quantities

I have a very large vector containing instantaneous information on a quantity on the timescale of microseconds. I also have another vector of the same quantity containing the 10 minute max, 10 minute ...
0
votes
1answer
12 views

Best Way to Aggregate further and Analyze a Data Point that is Already an Average

I want to understand how much time (on average) each Customer Service Agent (CSA) is taking to reply to messages that are sent by a Customer on a single chat. E.g., "Charles took on average, 22s to ...
0
votes
1answer
46 views

What happens with my variance if I multiply observations by 5?

Suppose a dataset with observation values: 2 3 4 4 2 Variance of this observation, assuming this is the entire population, would be: Where the average is: 3. ...
0
votes
0answers
35 views

Given a list of standard deviation values, how do I find the overall standard deviation of the whole set?

I have a program which takes a set of images and collects various types of information about the colours within each image. One of the things it collects is the mean of each RGB colour value (in a ...
0
votes
1answer
31 views

Comparing Likert Data

I have several 5-item likert scales and would like to compare the results between different surveys. Is there any logical way to score the likert results and compare? Averages don't seem to capture ...
4
votes
1answer
264 views

Can I use averages to improve the forecast of a multiple regression?

I have a cross-sectional multiple regression that I have estimated and now I would like to apply it to make a simple forecast of the dependent variable. Take the data generating process $$y_i =\...
1
vote
0answers
22 views

Can I compare daily averages using a T test?

Pretend you had a sales group that was required to perform a bunch of administrative work for every prospect they contacted. E.g., entering the prospect's contact info into a CRM, researching the ...
1
vote
0answers
24 views

Most “statistically sound” method for finding the average of multiple different metrics [duplicate]

If I have 3 different metrics and I wanted to find an "average" (not necessarily arithmetic mean) of the 3 metrics so that observations can be ranked, what would be the most "statistically sound" ...
0
votes
0answers
16 views

Correlating with average of independent but values of dependent variable?

I want to correlate reef health (independent variable) with fish biomass (dependent variable). I have six location and at each location I determined reef health only once, but fish biomass was ...
1
vote
0answers
24 views

From unsupervised clustering to a weighted average?

I am in the process of writing my master's thesis, and have stumbled (as one often do..) upon an area of statistics that I am not familiar with. My setup is, that I initially have 2 features which I ...
1
vote
1answer
173 views

On average of percents

I have read some pages about how to calculate the average of percents. However, still I don't understand something... Assume data points are organized in the following manner: We have two categories ...
2
votes
0answers
35 views

Which test applicable to compare means across time series?

I am currently writing my Master thesis and seek some advise how to best analyse my data and what the appropriate test for significance would be. To give you some background: I want to analyse ...
4
votes
2answers
186 views

Calculating the variance of sample, knowing the mean of population

Suppose that I somehow know the mean of the population. And I want to calculate the variance of a sample. Should I subtract population mean or sample mean? Is there any situation in which I should use ...
0
votes
0answers
23 views

Which mean to use to find the average of measurements given in the form of “per period”

Let's say I made several measurements on my gas consumption. 2m^3 per day 1m^3 per day 1.5m^2 per day 2m^3 per day What is the average daily consumption of gas? I can take arithmetic mean and it ...
0
votes
1answer
727 views

Calculate Median Value of Likert Scale data

I have a dataset in a Likert Scale: strongly agree, agree, neutral, disagree, strongly disagree (see attached). (i) Is there an online calculator that can used to calculate the Median for each item ...
0
votes
1answer
28 views

how to calculate average tenure of a worker in any factory

I have tenure data for workers who have left the factory and also who are still working in the factory. I need to calculate average time spent by worker in the factory?. what data should i consider ...
2
votes
2answers
80 views

Interpretation of the ratio of two estimated population means

I have two datasets. Lets say average of 1st dataset is 10, and average of second dataset is 12. Is it acceptable to divide 12/10 and say that the relationship between both datasets is 1.2? I am ...
1
vote
1answer
62 views

How to calculate the standard average of a set excluding outliers? [closed]

I have a set of numbers, and I need to calculate their average excluding outlier values (which I don't know a priori). It came to mind that many years ago I studied Standard Deviation. Could I apply ...
2
votes
0answers
36 views

Median versus Harmonic Mean As Log Normal Data Summary

I have a set of data that follows a lognormal distribution (it is fixed-distance, variable-speed situation https://stats.stackexchange.com/a/23130/55305). I am trying to summarize the data in a single ...