Regression Analysis Microsoft Excel

Business & Finance, Economics, Statistics, Nonfiction, Computers, Application Software, Spreadsheets, Financial Applications
Cover of the book Regression Analysis Microsoft Excel by Conrad Carlberg, Pearson Education
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Conrad Carlberg ISBN: 9780134393520
Publisher: Pearson Education Publication: May 2, 2016
Imprint: Que Publishing Language: English
Author: Conrad Carlberg
ISBN: 9780134393520
Publisher: Pearson Education
Publication: May 2, 2016
Imprint: Que Publishing
Language: English

        

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

 

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

        

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!

 

 

More books from Pearson Education

Cover of the book Building Applications with Windows Workflow Foundation (WF) by Conrad Carlberg
Cover of the book BBC PORTUGUESE PHRASE BOOK & DICTIONARY by Conrad Carlberg
Cover of the book Following Effective Trends in Sector Investing by Conrad Carlberg
Cover of the book York Notes Companions: Shakespeare and Renaissance Drama by Conrad Carlberg
Cover of the book Learn Ruby the Hard Way by Conrad Carlberg
Cover of the book Cloud Computing and SOA Convergence in Your Enterprise by Conrad Carlberg
Cover of the book Northanger Abbey: York Notes for AS & A2 by Conrad Carlberg
Cover of the book 31 Days Before Your CCNA Routing and Switching Exam by Conrad Carlberg
Cover of the book Twitter 101: Everything You Need to Know about Twitter Marketing by Conrad Carlberg
Cover of the book Flash Professional CS5 Advanced for Windows and Macintosh by Conrad Carlberg
Cover of the book Real World Camera Raw with Adobe Photoshop CS3 by Conrad Carlberg
Cover of the book Business Basics by Conrad Carlberg
Cover of the book Your Team Dynamics and the Dynamics of Your Team (Chapter 6 from Disrupt Together) by Conrad Carlberg
Cover of the book My Samsung Galaxy Tab 4 by Conrad Carlberg
Cover of the book Brilliant Start-Up by Conrad Carlberg
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy