Advanced Analytics—Technology and Tools: In-Database Analytics - Data Science and Big Data Analytics - page 495

Exercises
1. Show that EWMA smoothing is equivalent to an ARIMA(0,1,1) model with
no constant, as described in Chapter 8, “Advanced Analytical Theory and
Methods: Time Series Analysis.”
2. Referring to Equation ( 11.1 ) , demonstrate that the assigned weights decay
exponentially in time.
3. Develop and test a user-defined aggregate to calculate n factorial (n!),
where n is an integer.
4. From a SQL table or query, randomly select 10% of the rows. Hint: Most
SQL implementations have a random() function that provides a uniform
random number between 0 and 1. Discuss possible reasons to randomly
sample records from a SQL table.