Stack Overflow
Stack Overflow

Questions tagged [cumulative-frequency]

76 questions
2
votes
1 answer

Need to get cumulative count distinct by periods (year,month)

I already managed to obtain a cumulative distinct count by months but I can't get it when trying to do it by years. I tried partition function but I keep getting all kinds of errors, this is what I got so far. Could you give me some guidance, Im new…
J Suarez
  • 23
  • 3
2
votes
2 answers

Dynamic counting of occurrences

R newb. Small rep of my data. TeamHome <- c("LAL", "HOU", "SAS", "LAL") TeamAway <- c("IND", "SAS", "LAL", "HOU") df <- data.frame(cbind(TeamHome, TeamAway)) df TeamHome TeamAway LAL IND HOU SAS SAS LAL LAL …
Sburg13
  • 121
  • 5
2
votes
2 answers

Given index i,j(j>=i) How to find the frequency of a A[j] at a subarray(i,j)?

Given an array A of integers , I am trying to find out at a given position j , how many times A[j] occurs from every i=0 to i=j in A. I have devised a solution like below map CF[400005]; for(int i=0;i>A[i]; if(i!=0) …
Unbound
  • 233
  • 1
  • 11
2
votes
1 answer

Frequency and cumulative frequency curve on the same graph in R

Is there a way (in R with ggplot or otherwise) to draw frequency and cumulative frequency curves in a single column (two rows) i.e. one top of the other such that a given quartile can be shown on both the curves using straight lines? I hope I am…
Stat-R
  • 4,482
  • 8
  • 37
  • 61
1
vote
1 answer

How to plot a cumulative frequency line graph using ggplot2?

Forgive me if this question is self explanatory, but I am still trying to get to grips with some more of R's features. I am currently trying to use R to replot a cumulative frequency with lines I plotted in excel. I think a lot of my problems are…
Tom Wright
  • 19
  • 2
1
vote
1 answer

R Add CDF Columns to DataFrame

Suppose I have the following R dataframe: The Peril and Range columns are both factors. And I want to create a cumulative distribution column for Counts and Value like so: How would I do this? I am using dplyr if that helps.
jippyjoe4
  • 742
  • 4
  • 19
1
vote
1 answer

Confidence intervals for a normal fit in ggplot, cumulative probability

Edit: sorry I'm new to the community. I try to make it more clear with the sample data and code. Here's the data (output of dput): structure(list(`Sample Name` = c(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22),…
Reza
  • 23
  • 3
1
vote
1 answer

How can I create a column for cumulative count in Power BI?

I am trying to create a new column in a table like the last column here: Where I can count up the cumulative products from the same category that are added to a basket, based on the timestamp. I've tried grouping and adding an index column, but the…
erat93
  • 43
  • 3
1
vote
2 answers

Algorithm to generate all possible populations for a 5-Likert Scale in R (cumulative frequency per level by 0.1)

I would like to generate all possible populations in a 5-likert scale which values are the cumulative frequency by 0.1 in each level), e.g.: [1] [2] [3] [4] [5] 1 0 0 0 0 0 1 0 0 0 ... 0 0 0 0 1 0.9 …
Juan Antonio Guevara Gil
  • 27
  • 4
1
vote
2 answers

cumulative frequency given certain conditions in R

I am new at R and I do not really know how to count cumulative number of occurrences of a row if it is the same ID but different date.Also, if the first date appears more than once, it should not count in the first attempt.Look at the rows 2 and 3,…
Magggggg
  • 67
  • 6
1
vote
0 answers

R nonlinear regression of cumulative X and Y data

I'm trying to figure how to make a nonlinear regression of some cumulative data of X and Y values. The dataset is based on cumulative items and their respective cumulated demand. I have a plot that looks like this based on the following…
LRO
  • 79
  • 6
1
vote
2 answers

Cumulative Sum using 2 columns

I am trying to create a column that does a cumulative sum using 2 columns , please see example of what I am trying to do :@Faith Akici index lodgement_year words sum cum_sum 0 2000 the 14 14 1 2000 …
Ian_De_Oliveira
  • 271
  • 3
  • 13
1
vote
1 answer

SQL: Fast Cumulative Frequency Query (postgres)

I'm looking to get Cumulative Frequency Data out of our database. I've created a simple temp table with all unique status update counts that we've seen, and the number of users that have that amount of status updates. Table…
Peck
  • 782
  • 1
  • 7
  • 26
1
vote
0 answers

Cumulative Frequency Tables and Chart Output

I'm working with some rather large time-series data sets related to futures prices and am in the process of converting some calculations which I previously did in Excel to R. This conversion has been relatively straightforward thus far but I m…
Kuba_R
  • 11
  • 2
1
vote
1 answer

How to create a cumulative graph in R

Is there a cumulative graph package in R? Or how might I create a cumulative graph in R? For example, given values of 2, 4, 2, 2, they values should be plotted as 2, 6, 8, 10 d3 example here. Then forming a stair step pattern as with other…
d-cubed
  • 902
  • 5
  • 29
  • 52
1
2
3 4 5 6