Features
- Teaches the theory behind regression analysis, so students can perform, assess, and troubleshoot any regression-based analysis
- Uses Excel functions to perform analyses ranging from simple correlations and t-tests through multiple analysis of covariance
- Shows what you can and can't do with regression, the limits it places on inferences, and the consequences of each Excel option and argument
- Teaches advanced techniques, and shows how to apply them to real problems in business and research
- All new, hands-on content from Conrad Carlberg, the world's #1 best-selling expert on Excel-based analytics and statistics
- Copyright 2016
- Dimensions: 7" x 9-1/8"
- Pages: 368
- Edition: 1st
-
Book
- ISBN-10: 0-7897-5655-2
- ISBN-13: 978-0-7897-5655-8
This is today’s most complete guide to regression analysis with Microsoft® Excel for any business analytics or research task. Drawing on 25 years of advanced statistical experience, Microsoft MVP Conrad Carlberg shows how to use Excel’s regression-related worksheet functions to perform a wide spectrum of practical analyses.
Carlberg clearly explains all the theory you’ll need to avoid mistakes, understand what your regressions are really doing, and evaluate analyses performed by others. From simple correlations and t-tests through multiple analysis of covariance, Carlberg offers hands-on, step-by-step walkthroughs using meaningful examples.
He discusses the consequences of using each option and argument, points out idiosyncrasies and controversies associated with Excel’s regression functions, and shows how to use them reliably in fields ranging from medical research to financial analysis to operations.
You don’t need expensive software or a doctorate in statistics to work with regression analyses. Microsoft Excel has all the tools you need—and this book has all the knowledge!
- Understand what regression analysis can and can’t do, and why
- Master regression-based functions built into all recent versions of Excel
- Work with correlation and simple regression
- Make the most of Excel’s improved LINEST() function
- Plan and perform multiple regression
- Distinguish the assumptions that matter from the ones that don’t
- Extend your analysis options by using regression instead of traditional analysis of variance
- Add covariates to your analysis to reduce bias and increase statistical power
Downloads
Follow the instructions to download additional support files.
- Click the Download button below to start the download.
- If prompted, click Save.
Download
Online Sample Chapter
Using Regression to Test Differences Between Group Means
Sample Pages
Download the sample pages (includes Chapter 7 and Index)
Table of Contents
-
1 Measuring Variation: How Values Differ
-
2 Correlation
-
3 Simple Regression
-
4 Using the LINEST( ) Function
-
5 Multiple Regression
-
6 Assumptions and Cautions Regarding Regression Analysis
-
7 Using Regression to Test Differences Between Group Means