From the course: The Data Science of Experimental Design
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Baseline time-series analyses
From the course: The Data Science of Experimental Design
Baseline time-series analyses
- [Instructor] Now we are ready to do a baseline time series analysis. Up to now, we've done a lot of conceptual work and documented our decisions. Remember our planning spreadsheet? We decided on numerators and denominators for rates. And we decided on time increments. Now that we made those management decisions, it's not that hard to go get historical data. So let's pretend we went and did that. Now we need to actually calculate those historical rates and make a time series graph of them. So I made some exercise files for us as examples. First we'll look at an Excel spreadsheet. On one of the tabs I'll show you how I calculated the Pay1 Rate. Remember that's the rate of sales conversions. Then I'll also show you an example of how you can calculate rates when you have the same numerator, but different denominators. I'll also show you about making a time series graph for both of these. With the second set of rates, the…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.