I'm a student
I'm an educator
Request full copy

Regression Analysis Microsoft Excel, 1st edition

Published by Que Publishing (May 6, 2016) © 2016

  • Conrad Carlberg

eTextbook

$37.99

  • Available for purchase from all major ebook resellers, including InformIT.com.
  • To request a review copy, click on the "Request a Review Copy" button.
$31.99

  • A print text (hardcover or paperback) 
  • Free shipping
  • Also available for purchase as an ebook from all major ebook resellers, including InformIT.com

The author clearly explains all the theory students will need to avoid mistakes, understand what 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.

  • 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
  • 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

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 that 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.

Need help? Get in touch

Video
Play
Privacy and cookies
By watching, you agree Pearson can share your viewership data for marketing and analytics for one year, revocable by deleting your cookies.

Video transcript (PDF | 16KB) 

Pearson eTextbook: What’s on the inside just might surprise you

They say you can’t judge a book by its cover. It’s the same with your students. Meet each one right where they are with an engaging, interactive, personalized learning experience that goes beyond the textbook to fit any schedule, any budget, and any lifestyle. 

Digital Learning NOW

Extend your professional development and meet your students where they are with free weekly Digital Learning NOW webinars. Attend live, watch on-demand, or listen at your leisure to expand your teaching strategies. Earn digital professional development badges for attending a live session.

Explore webinars