Table of Contents

• 1 Making the Transition
• 2 Descriptive Statistics
• 3 Regression Analysis in Excel and R
• 4 Analysis of Variance and Covariance in Excel and R
• 5 Logistic Regression in Excel and R
• 6 Principal Components Analysis

About the Author

Conrad Carlberg (www.conradcarlberg.com) is a nationally recognized expert on quantitative analysis and on data analysis and management applications such as Microsoft Excel, SAS, and Oracle. He holds a Ph.D. in statistics from the University of Colorado and is a many-time recipient of Microsoft's Excel MVP designation.

Carlberg is a Southern California native. After college he moved to Colorado, where he worked for a succession of startups and attended graduate school. He spent two years in the Middle East, teaching computer science and dodging surly camels. After finishing graduate school, Carlberg worked at US West (a Baby Bell) in product management and at Motorola.

In 1995 he started a small consulting business which provides design and analysis services to companies that want to guide their business decisions by means of quantitative analysis–approaches that today we group under the term "analytics." He enjoys writing about those techniques and, in particular, how to carry them out using the world's most popular numeric analysis application, Microsoft Excel.