How to Calculate a Cumulative Average in R

[This article was first published on Data Analysis in R » Quick Guide for Statistics & R » finnstats, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here)
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

The post How to Calculate a Cumulative Average in R appeared first on finnstats.

If you want to read the original article, click here How to Calculate a Cumulative Average in R.

Are you looking for the latest Data Science Job Vacancies / Internship then click here finnstats.

We encourage that you read this article from finnstats to stay up to date..

Cumulative Average in R, The average of a series of values up to a certain point is given by a cumulative average.

In R, you can calculate the cumulative average of values using the following methods.

Subscribe to our newsletter!

Approach 1:- Base R

cum_avg <- cumsum(x) / seq_along(x)

Approach 2:- dplyr

library(dplyr)
cum_avg <- cummean(x)

Approach 3-: Using cumsum and seq_along

data$cum_avg_volume<-cumsum(data$Volume) / seq_along(data$Volume)  

How to Calculate Jaccard Similarity in R » finnstats

Above techniques get the same output, although the dplyr method is faster when working with huge data frames.

With the following data frame in R, the following examples explain how to utilize each method in practice.

Let’s create a data frame.

data <- data.frame(Month=seq(1:12),
                 Volume=c(3,5,7,8,4,9,1,2,9,12,14,15))

Now we can view the head of the data frame.

Granger Causality Test in R (with Example) » finnstats

head(data)
   Month Volume
1     1      3
2     2      5
3     3      7
4     4      8
5     5      4
6     6      9

Approach 1: Using Base R, calculate the Cumulative Average.

data$cum_avg_volume <- cumsum(data$Volume) / seq_along(data$Volume)

Okay, now view the updated data frame.

String Manipulation in R » finnstats

data
   Month Volume cum_avg_volume
1      1      3       3.000000
2      2      5       4.000000
3      3      7       5.000000
4      4      8       5.750000
5      5      4       5.400000
6      6      9       6.000000
7      7      1       5.285714
8      8      2       4.875000
9      9      9       5.333333
10    10     12       6.000000
11    11     14       6.727273
12    12     15       7.416667

The cumulative average values could be interpreted as follows:

The first sales value’s cumulative average is 3.

The first two sales values have a cumulative average of 4.

The first three sales values have a cumulative average of 5.

And so forth.

What is neural network in machine learning? » finnstats

Example 2: Using dplyr, calculate the cumulative average

To calculate a cumulative average in R, we may use the cummean function from the dplyr package.

The following code demonstrates how to use this function to add a new column to our data frame that represents the volume cumulative average:

library(dplyr)

add a new column with the cumulative average of volume.

Regression Analysis Example-Ultimate Guide » finnstats

data <- data.frame(Month=seq(1:12),
                   Volume=c(3,5,7,8,4,9,1,2,9,12,14,15))

Let’s view the updated data frame

data
  Month Volume cum_avg_volume
1      1      3       3.000000
2      2      5       4.000000
3      3      7       5.000000
4      4      8       5.750000
5      5      4       5.400000
6      6      9       6.000000
7      7      1       5.285714
8      8      2       4.875000
9      9      9       5.333333
10    10     12       6.000000
11    11     14       6.727273
12    12     15       7.416667

It’s worth noting that this strategy produces the same outcomes as the prior one.

Example 3: Using cumsum and seq_along

Using the cumsum and seq_along functions from the R programming language.

Cross Validation in R with Example » finnstats

data <- data.frame(Month=seq(1:12),
                   Volume=c(3,5,7,8,4,9,1,2,9,12,14,15))
data$cum_avg_volume<-cumsum(data$Volume) / seq_along(data$Volume)  
data
  Month Volume cum_avg_volume
1      1      3       3.000000
2      2      5       4.000000
3      3      7       5.000000
4      4      8       5.750000
5      5      4       5.400000
6      6      9       6.000000
7      7      1       5.285714
8      8      2       4.875000
9      9      9       5.333333
10    10     12       6.000000
11    11     14       6.727273
12    12     15       7.416667

Model Selection in R (AIC Vs BIC) » finnstats

It’s worth noting that this technique yields the same results as we have seen in the one and two.

To read more visit How to Calculate a Cumulative Average in R.

If you are interested to learn more about data science, you can find more articles here finnstats.

The post How to Calculate a Cumulative Average in R appeared first on finnstats.

To leave a comment for the author, please follow the link and comment on their blog: Data Analysis in R » Quick Guide for Statistics & R » finnstats.

R-bloggers.com offers daily e-mail updates about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)