From the course: Python in Excel: Data Outputs in Custom Data Visualizations and Algorithms
Unlock the full course today
Join today to access over 24,800 courses taught by industry experts.
Challenge: Comparing time series components to anomalies
From the course: Python in Excel: Data Outputs in Custom Data Visualizations and Algorithms
Challenge: Comparing time series components to anomalies
(upbeat music) - [Instructor] Now let's tie what you've learned in this course with the final part of the challenge. We'll, again, continue to work with the hourly Santa Barbara weather data, focusing on temperature measurements. In the last chapter, you ran an anomaly detection algorithm on the temperatures to determine when these anomalies occurred. As we saw in this chapter, we can put time series data in a chart to visualize it. We can then break down this line chart into components for trend, seasons, and anomalies. Now, your task is to use time series decomposition on the same data to not only create a time series decomposition, but compare the anomalies seen in the residuals plot to the anomalies we calculated in the previous chapter. Good luck.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
Visualizing data1m 35s
-
(Locked)
Leveraging Excel line charts3m 58s
-
(Locked)
Leveraging Excel scatter plots5m 21s
-
(Locked)
Configuring Python in Excel with dynamic parameters4m 32s
-
(Locked)
Creating Python visuals2m 13s
-
(Locked)
Visualizing hierarchical clustering with dendrograms6m 43s
-
(Locked)
Breaking down time series models into components5m 29s
-
(Locked)
Challenge: Comparing time series components to anomalies50s
-
(Locked)
Solution: Comparing time series components to anomalies4m 56s
-
-