100 questions
1
vote
0
answers
87
views
Pine script: how can I add a "Standard deviation channel" to a polynomial regression?
I have found a script for generating a polynomial regression, which I have adapted to my needs and which basically works.
However, in order to be able to use the script the way I want to, I need a ...
- 11
0
votes
0
answers
259
views
Calculate standard deviation within a certain range in excel
I first checked the answers this question:
Is there a way to calculate standard deviation on a range of cells only for cells where the value is greater than 0 in Excel?
I tried to use this info for a ...
- 1
-1
votes
2
answers
89
views
what is the R code to calculated a mean and standard deviation of multiple mean and standard deviations?
what is the R code to calculated a mean and standard deviation of multiple mean and standard deviations? each has its own number of items...
I tried to search online and in this forum but there was no ...
1
vote
1
answer
99
views
.NET / C# arithmetic deviation (addition)
Summation of these numbers give different results in .NET Core / C# and on other compilers.
3987908.698692091 + 92933945.11382028 + 208218.11919727124 + 61185833.06829034
.NET Core / C# : 158315904....
- 420
1
vote
1
answer
44
views
Cumulative Deviation of 2 Columns in Pandas DF
I have a rather simple request and have not found a suitable solution online. I have a DF that looks like this below and I need to find the cumulative deviation as shown in a new column to the DF. My ...
- 1,366
0
votes
1
answer
48
views
Deviations from type average
I have a df like this:
structure(list(Date = structure(c(18605, 18604, 18598, 18597,
18590, 18584, 18583, 18578, 18570, 18569, 18563, 18562, 18557,
18549, 18548, 18542, 18541, 18536, 18534, 18529, ...
- 762
0
votes
1
answer
254
views
Find the variance based on a threshold in R
This datasets contains 42 IDs with 1440 observations per ID. This means that the dataset got 60480 observations in total. The values of the columns AI_1..., to AI_7 got values that range from 0.00 to ...
- 119
0
votes
1
answer
189
views
How do I aggregate using standard deviation using raster::aggregate?
For my model I need to aggregate my raster datasets using standard deviation. Is there a 'fun' abbreviation for this purpose? I am currently using mean but wish to use standard deviation instead. This ...
- 1
0
votes
1
answer
51
views
Standard Deviation of certain cells in excel
for eg I have 5 numbers in excel, in A1,A2 etc numbers could be 95 99 98 96 97, (not sorted). How do I get the standard deviation for the top 4 numbers only (ie: dropping the lowest number)
...
0
votes
1
answer
660
views
Query on yang deviation
I am new to yang deviations. I wrote a deviation like below but I am not sure if the deviation is effective. Is it possible to print a text(value of xpath) in must statement for debugging purposes? ...
- 73
0
votes
0
answers
47
views
Figure out how a formula works
I am using that site: http://167.71.255.125/#/dashboard/football/game/5359832 and i can't figure how it calculates the 'deviation' column whenever handicap home and away columns change. It probably ...
1
vote
1
answer
185
views
Mean and Standard deviation of interpolated datasets (R)
I have 8 data sets that I have interpolated so the x axis spacing is the same but they are different lengths ranging from 800-1200 points.
What I would like to do is then calculate the mean of each y ...
2
votes
3
answers
2k
views
How to implement a loop over all columns within a calculation in pandas?
I'm new to pandas and python and I'm struggling with the implementation of loops in my code. I hope that someone can help me.
I have the following Dataframe:
import pandas as pd
from pandas import ...
- 71
-1
votes
1
answer
69
views
Finding the average and standard deviation of a data set
I have a laser that is sent through a signal splitter. 90% of the light goes into a diffuser and that is detected by a Photomultiplier tube (PMT). The other 10% of the signal goes to a separate ...
-2
votes
1
answer
94
views
Is there a way to find a deviation between a1=[] and a2=[] in Python?
We have these arrays in python:
a1 = [0, 1, 2, 3]
a2 = [0, 1.1, 2.2, 3.1]
and want to find the deviation between a1 and a2. And sorry, we do not know what's such a type of deviation is named, but ...
3
votes
2
answers
250
views
How to give a warning when a moving object deviates from a path by a specific margin?
In my pygame-code, I have a drone that is supposed to follow a flight path.
I used pygame.draw.lines to draw lines between specified points. Now, I have a flight path with 10 points where after each ...
- 37
0
votes
1
answer
318
views
4 numbers max variance calculation
I have an array of four numbers, something like [597103978, 564784412, 590236070, 170889704] and I need to make sure that the variance is no more than 10%, for example for the array above, the check ...
0
votes
1
answer
804
views
How to split a Series into time intervals? (python)
I have this dataframe:
And I should split the rows of the ''Time.s'' column into intervals, calculate the average of each interval, and finally the deviation of each average.
I can't split the lines ...
- 27
0
votes
4
answers
9k
views
Calculate root mean square deviation (RMSD) with numpy of Python
I transformed the coordinates of two atoms into an array: coord
And I must calculate the root mean squared deviation (RMSD) between the two sets of these coordinates.
For this I have:
def ...
-1
votes
1
answer
683
views
Remove rows on quartile deviation low or high
Wrote a code
df=data.copy()
for column in data.columns:
Q1= np.quantile(data[column],0.25)
Q3= np.quantile(data[column],0.75)
IQR = Q3-Q1
Low = Q1 - 3*(IQR)
High = Q3 + 3*(IQR)
...
0
votes
1
answer
200
views
Returning Error: `n()` must only be used inside dplyr verbs
I'm struggling to get the following code working.
The data I have is a data.frame of a physical test. Athletes who did the test are classified based on a 'Sport Specific' paramater.
wingate_benchmarks ...
- 3
0
votes
2
answers
197
views
how to calculate standard deviation of values in 10 intervals?
I want to calculate a standard deviation step by 10 in R; for example
For a large number of values, I want to calculate the SD of the values in 10 intervals. 0-10, 10-20, 20-30 ...
Example: I have a ...
- 19
0
votes
1
answer
99
views
Find Variability Monthly Data by Year of Long-Term Monthly Average
I need to find the variability from the long-term mean for monthly data from 1991 to 2021. I have data that looks like this that is a 204,3 size:
dfavgs =
plant_name month power_kwh
0 ...
- 1,366
0
votes
0
answers
117
views
calculate weighted s.d in r
I want to calculate in r weighted mean and weighted standard deviation (the weights are sample weights, for a survey sample. It is suppose to show how many units in the population represent each unit ...
- 3
0
votes
3
answers
685
views
How to calculate mean of multiple standard deviation in R
i have a little problem i have 10 standard deviation and 10 mean with normal distribution like this
N(5,1) , N(10,3), N(8,2) N(6,1), N(10,3), N(7,2), N(4,1), N(10,3), N(9,2), N(8,1).
if i search the ...
-1
votes
1
answer
79
views
Need to display a positive and a negative message in a column when a number deviates from the average
Basically, I need to create a table that will show the avg users per day of the week and if there is a 20% positive or negative deviation in the numbers from the average I need it to say 'Positive ...
-1
votes
1
answer
290
views
Absolute Deviation Formula in R
I have a little problem i wanna make this formula to my code in R studio for iris (data-mean of colum)/absolute deviation. and this is my code
y=iris[,1:4]
for(i in 1:4){y[, i] = (iris[,i] - mean(iris[...
- 19
1
vote
2
answers
209
views
Place different items evenly in array
I'm wondering if it is possible to somehow "sort" items in an array to place them in "equal" spacings.
An example is more than hundreds of words so:
Apple - 1
Banana - 2
Pineapple -...
- 23
0
votes
1
answer
1k
views
calculate variance and standar deviation of each 15 rows in python
I have a dataframe which contains 300 value of height and I want to calculate the standard deviation and also variance of each 15 rows. I supposed to have 20 var and st.deviation. So far I have done ...
- 33
2
votes
2
answers
2k
views
Python Matplot Y Axis Negative to Positive Label Range
I'm trying to create y axis labels in a sequence of -20 to + 20 with 5 integer increments. I've tried this below with my plot axis = ax2:
ax2.set_yticks(list(range(-20, 25, 5)))
ax2.set_yticklabels([...
- 1,366
0
votes
2
answers
718
views
Removing/collapsing duplicate rows in R
I am using the following R code, which I copied from elsewhere (https://support.bioconductor.org/p/70133/). Seems to work great for what I hope to do (which is remove/collapse duplicates from a ...
- 1,383
0
votes
1
answer
44
views
Is there a reason MATLAB is giving me deviations as I perform the calculations? [duplicate]
I have these random Gaussian variables A and B to represent voltages. I also have resistances in series with the voltages, RA and RB, respectively. I want to take voltage measurements in between RA ...
-3
votes
3
answers
138
views
How can normalize the data in format (-3 ,-2,-1,0,1,2,3) if given data is in range (-1 to 1) using R or Python?
Value:
0.344
-0.124
0.880
0
0.910
-0.800
- 9
0
votes
1
answer
1k
views
Calculation of rolling standard deviation by group
I have a long dataset in the following format:
Date Country Score
1995-01-01 Australia 100
1995-01-02 Australia 99
1995-01-03 Australia 85
: : :
: ...
- 11
2
votes
2
answers
203
views
Standard deviation calculation - Am I following the right approach? How do we find SD percentage?
I have a query which gives me below data.
item_name, total_purchase_count_per_week, previous_day_purchase_count.
For ex,
iPhone , 4800, 200
Samsung, 3000, 470
Moto, 1700, 80
Now, I'm interested in ...
- 153
-1
votes
3
answers
518
views
Deviation of a list from a reference value
I've got a reference value:
ref = 0.5
And a list:
my_list = [0.4, 0.5, 0.6, 0.5]
I'm trying to calculate how much, on average, the elements of my list differ from my reference value. Basically, it ...
- 525
3
votes
1
answer
1k
views
What is the between variance formula in panel data?
I want to calculate panel descriptive statistics for my variables analogously to how Stata provides them using the "xtsum" function. I am able to compute almost everything (overall/within sd, mean, ...
user11005502
0
votes
1
answer
178
views
Inconcsistent location when radius decreased in HERE Geocoding API
Using the HERE geocoding API (version 6.2) to get LinkIDs from a given location(lat,long).
Example: same coordinates with different radius
base-URL used for queries: https://reverse.geocoder.api.here....
-1
votes
1
answer
639
views
Computing variance, standard deviation in python [closed]
How to calculate data distribution (variance and standard deviation) on Python 3, if the data has > given with atribute Jumlah_individu?
this is my code to calculate mean (I have get it) but for ...
- 21
10
votes
1
answer
3k
views
How do I create a reliable compass for iOS and Android in Javascript?
I'm trying to create a reliable compass in Javascript/JQuery (using deviceorientation) so that it works on iOS and Android mobile devices.
I know nearly every (very old) question/answer here in ...
- 886
-1
votes
1
answer
446
views
mean and standard deviation
Im trying to make a mean and standard deviation calculator on visual studio using windows form. It's for a class and I have to use windows form and you have to be able to input data manually or select ...
- 13
0
votes
1
answer
590
views
Relationship of standard deviation for Gaussian filter between pixel domain and the real world
I constructed an experiment with Gaussian blur in real world and MR images. I printed some test images blurred and compare augmented images blurred too.
What is the best way to express how much ...
- 11
2
votes
1
answer
1k
views
Hmisc wtd.var confusion: calculated weighted variance in R
I'm trying to calculate a weighted variance for a group of studies in a meta analysis for which I have individual means and variances:
variance #available variance values for studies
[1] 0.705600 ...
- 21
-1
votes
2
answers
76
views
MySQL: How to count the number of deviations?
I've got a table with two columns: timestamp and integer value (let's name these date and value). The second value gets swings between 0 and ~290 and then goes back to 0, so on the chart it looks like ...
- 3
0
votes
0
answers
202
views
Calculate Variance with Excel ignoring some values
I have two colums :
One with data
The other with group names. In each cells it's either "Group A" or "Group B".
I would like to calculate Variance with the data from Group A. How could I proceed ?
I'...
- 4,614
0
votes
1
answer
865
views
Beginner Using OOP in java how do I getAverage and getStandardDeviation()
Here's what I have so far from my code. this is an introductory course so we haven't covered more advanced topics yet. With what I gave so far I input number and press -1 but the program doesn't do ...
- 1
0
votes
0
answers
108
views
Android Google Maps automatic positioning with position deviation why
So, dude, I use the automatic positioning of Google map API, I am Chinese Beijing, Spain Barcelona customers to automatically locate the address in the city, I Chinese, also will not have the ...
0
votes
1
answer
175
views
Employee wise standard deviation for daily attendance time
I want to calculate the standard deviation for the employee wise daily time.
following is the data frame or csv I am importing:
EmpCode,Date,InTime,OutTime,expetcedIn,expetcedOut
9889,01-Feb-17,9:...
- 1
3
votes
0
answers
220
views
SWIFT: Compass-like animation
I have configured Core Motion manager in order to access the rotation coordinates and use them to animate deviation, like in native compass application. So here is what I want to achieve:
It is this ...
1
vote
2
answers
9k
views
how to compute standard deviation in sql without built-in function
I have a column of numbers in my database. How can I computer the standard deviation? I do not want use the stddev function.
- 37