Use a spreadsheet to determine the 10-day SMA for Dell Inc....

Use a spreadsheet to determine the 10-day SMA for Dell Inc. 31-Mar 19.92 8-Apr 19.00 16-Apr 18.72 24-Apr 19.14 2-May 19.32 1-Apr 20.33 9-Apr 18.69 17-Apr 19.05 25-Apr 19.11 5-May 19.10 2-Apr 19.95 10-Apr 18.77 18-Apr 19.47 28-Apr 18.87 6-May 19.19 3-Apr 20.12 11-Apr 18.50 21-Apr 19.56 29-Apr 18.97 7-May 18.90 4-Apr 19.53 14-Apr 18.24 22-Apr 19.05 30-Apr 18.63 8-May 18.84 7-Apr 19.23 15-Apr 18.28 23-Apr 19.05 1-May 19.08 9-May 19.03

Use a spreadsheet to determine the 10-day SMA for Dell Inc.
31-Mar 19.92 8-Apr 19.00 16-Apr 18.72 24-Apr 19.14 2-May 19.32
1-Apr 20.33 9-Apr 18.69 17-Apr 19.05 25-Apr 19.11 5-May 19.10
2-Apr 19.95 10-Apr 18.77 18-Apr 19.47 28-Apr 18.87 6-May 19.19
3-Apr 20.12 11-Apr 18.50 21-Apr 19.56 29-Apr 18.97 7-May 18.90
4-Apr 19.53 14-Apr 18.24 22-Apr 19.05 30-Apr 18.63 8-May 18.84
7-Apr 19.23 15-Apr 18.28 23-Apr 19.05 1-May 19.08 9-May 19.03

Labs

Want to see this concept in action?

NEW

Explore this concept interactively to see how it behaves as you change inputs.

View Labs

Key Concepts

Rolling Window Calculation

A rolling window calculation refers to the process of applying a statistical function, such as an average, to a fixed subset of data points that moves sequentially through the dataset. This method is essential in time series analysis for deriving metrics over different periods, such as calculating the 10-day moving average by continuously updating the data window.

Spreadsheet Software

Spreadsheets are digital tools that organize data in rows and columns, allowing users to perform calculations, visualize data, and easily manipulate datasets. They provide built-in functions and formulas which simplify complex computations, such as those needed for calculating moving averages in time series analysis.

Simple Moving Average (SMA)

The simple moving average is a statistical tool used to smooth out short-term fluctuations by averaging a fixed number of past data points. It is particularly useful in analyzing trends over time, as it reduces the impact of volatile data and highlights underlying trends in datasets.

Transcript

Please give Ace some feedback