Regression Analysis Microsoft Excel
Conrad Carlberg, ""
English | ISBN: 0789756552 | 2016 | PDF | 368 pages | 22 MB
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 yourregressions 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
发帖
雷达卡
加好友,备注jr
京公网安备 11010802022788号
论坛法律顾问：王进律师
知识产权保护声明
免责及隐私声明
提升卡
置顶卡
沉默卡
变色卡
抢沙发
千斤顶
显身卡
