Questions tagged [median]
The median is the 'middle' value from a set of values. If the number of values is an even number, the median is the mean of the 'middle' values.
median
1,520
questions
2
votes
2
answers
58
views
Finding the subarray with the least median given a size K and an array of length N
I have been struggling the past month with this problem that was given to us on our course while I was upsolving it. The task is to find the window of size K with the least median in an array of ...
1
vote
2
answers
34
views
Is there a function that can return the median value of an image expression
There is a function to get the median from number expressions in DM. For example:
// number expression
number x=3, y=5, z=10;
number num = median(x, pi(), y,z);
OKDialog( "num = " + num);
...
0
votes
1
answer
58
views
Pivot median fails to be calculated because of column formatting
I am very new to the macro world (first post here) so I apologize if there is an obvious solution that I'm missing. I've also been using the record macro feature so the script below might be a bit ...
2
votes
1
answer
102
views
Median of two sorted-arrays algorithm for O(log(m+n))
Median of two sorted-arrays is a quite well known problem in leetcode. Real implementation of O(log(min(m,n))) solution is quite straight forward but not of O(log(m•n)).
The basic idea is removing ...
0
votes
0
answers
35
views
0 being added at beginning of array in Assembly RISC32
I'm coding my very first project in Assembly using RISC V 32 architecture and the RARS simulator and I'm having some issues with my code.
The code needs to prompt the user for an array size and ask ...
-2
votes
1
answer
77
views
Excel: how to calculate average and median for data from each quartile, where data should match specific criteria
Question seems simple but I can not get working formula, already desperate.
I have to calculate gender pay gap. And for it need following:
Imagine column B =gender of employees (male/female), colum C -...
0
votes
0
answers
22
views
How do i get a useful median for 3D positions?
I have made a useful median for 2D positions by taking the average median of the x positions of the positions rotated in every 360° direction. The angleDiffs are the degrees of freedom, that the ...
1
vote
2
answers
57
views
Create interval of data from dataframe with given median
I have a large data frame of subjects. For simplcity's sake I have posted a smaller modified version of my data frame below.
subject age sex
A 5.35 Female
B 5.70 Male
C ...
1
vote
2
answers
193
views
Find a median of two sorted arrays using divide and conquer and recursion
I'm trying to find a median of two sorted arrays, of different sizes, using recursion on a divide and conquer manner. The entry are two sorted arrays and the output is the median of these two sorted ...
0
votes
1
answer
101
views
How to find mean and median of frequency table using python
I am new to python data analysis and I am working on census data, here is an example of the data,
| geo_area |Total | 2-5km|5-10km|
|------------|------| ----| -----|
| E02000001 | 5378 | 385 | ...
0
votes
0
answers
23
views
Have a problem to get median in DAX power bi, can anyone please have a look?
The following code gives the total sum, not the median
Median CW =
var StartDate = MAX('Date'[dt])
var Result = CALCULATE(
CALCULATE( MEDIANX( 'ogd',
SUMX(...
0
votes
1
answer
59
views
Getting wrong answer in Binary Search solution
Problem statement
You are given a row-wise sorted matrix mat of size m * n where m and n are the numbers of rows and columns of the matrix, respectively.
Your task is to find and return the median of ...
0
votes
1
answer
95
views
Find median in constant time O(1)
I have a stream of operations. Each operation is one of:
Set a number value V at key K
Remove key K
Only one operation can be executed at a time. I need to keep track of the median of all set values ...
0
votes
1
answer
21
views
Plotting medians between nested boxplots with ggplot2
I have some data where every person is either "satisfied" or "dissatisfied". Then, every person also has two types of calculated distances. I have no issues plotting the boxplot. ...
0
votes
0
answers
41
views
Finding the median of an unsorted array without sorting [duplicate]
As shown in the title, given an unsorted array (arr) and it's size (size) I'm asked to find the median of it without sorting.
My thought:
If the length of the array is odd then It would be easy to ...