Get full access to Predictive Analytics: Microsoft® Excel and 60K+ other titles, with free 10-day trial of O'Reilly.
There's also live online events, interactive content, certification prep materials, and more.
1 Building a Collector
Planning an Approach
A Meaningful Variable
Planning the Workbook Structure
More Complicated Breakdowns
The VBA Code
The DoItAgain Subroutine
The GetNewData Subroutine
The GetRank Function
The GetUnitsLeft Function
The RefreshSheets Subroutine
The Analysis Sheets
Defining a Dynamic Range Name
Using the Dynamic Range Name
2 Linear Regression
Correlation and Regression
Charting the Relationship
Calculating Pearson’s Correlation Coefficient
Correlation Is Not Causation
Creating the Composite Variable
Analyzing the Composite Variable
Assumptions Made ...
Get Predictive Analytics: Microsoft® Excel now with the O’Reilly learning platform.
O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.
Get Mark Richards’s Software Architecture Patterns ebook to better understand how to design components—and how they should interact.