SCRIPT 1
Question:
How do I get the Holtwinters Alpha code in the below script and replace the Chronsbachs Alpha?
SCRIPT 1
read_file(sales1)
library(tidyverse)
library(psy)
#Number of rows before to take into account
rolling = 2
sales1 <- sales::sales(
~date, ~sales,)
#Lag
sales1 = sales1 %>% mutate(lagsales = lag(sales))
#Rolling Chronbachs Alpha.:
sales1$alpha = c(
rep(NA, rolling),
map_dbl((rolling + 1):nrow(sales1), function(x){
cronbach(sales1 %>% select(sales, lagsales) %>% slice((x-rolling):x))$alpha
})
)
sales1
extract from Sales1 table
Date | sales |
---|---|
03-01-2017 | 40 |
04-01-2017 | 2 |
05-01-2017 | 2 |
06-01-2017 | 2 |
07-01-2017 | 30 |
08-01-2017 | 2 |
01-02-2017 | 9 |
02-02-2017 | 5 |
03-02-2017 | 65 |
04-02-2017 | 3 |
05-02-2017 | 65 |
06-02-2017 | 1 |
07-02-2017 | 11 |
08-02-2017 | 9 |
01-03-2017 | 21 |
02-03-2017 | 65 |
03-03-2017 | 5 |
04-03-2017 | 10 |
05-03-2017 | 40 |
06-03-2017 | 2 |
07-03-2017 | 2 |
08-03-2017 | 2 |
09-03-2017 | 30 |
01-04-2017 | 2 |