Regression Analysis Microsoft Excel
- ISBN-10
- 013439352X
- ISBN-13
- 9780134393520
- Category
- Business & Economics
- Pages
- 368
- Language
- English
- Published
- 2016-05-02
- Publisher
- Que Publishing
- Author
- Conrad Carlberg
Description
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
Get the book
Other editions
Similar books
-
Taxation for Decision Makers, Binder Ready Version
By Shirley Dennis-Escoffier, Karen A. Fortin[LO 8.2] The Timberlake Corporation has an opportunity to sell its manufacturing facility to Carroll Corporation for $4,500,000. The property has a basis of ...
-
Taxation for Decision Makers, 2019 Edition
By Shirley Dennis-Escoffier, Karen A. Fortin[LO 9.2] The Timberlake Corporation has an opportunity to sell its manufacturing facility to Carroll Corporation for $4,500,000. The property has a basis of ...
-
Taxation for Decision Makers, 2020
By Shirley Dennis-Escoffier, Karen A. Fortin[LO 9.2] The Timberlake Corporation has an opportunity to sell its manufacturing facility to Carroll Corporation for $4,500,000. The property has a basis of ...
-
Keeping House in Lusaka
By Karen Tranberg Hansen1934. Memorandum on the Native Tribes and Tribal Areas of Northern Rhodesia . Lusaka : Government Printer . Timberlake , Michael , ed . 1985.
-
Encyclopedia of Community: From the Village to the Virtual World
By DAVID LEVINSON, KAREN CHRISTENSENTimberlake, L. (1987). Only one Earth. London: BBC Books: Earthscan. Tinker, I. (1987). Street foods: Testing assumptions about informal sector by women and ...
-
Taxation for Decision Makers 2006
By Shirley Dennis-Escoffier, Karen FortinThe Timberlake Corporation has an opportunity to sell its manufacturing facility to Carroll Corporation for $ 4,500,000 . The property has a basis of ...
-
Handbook of Organizational Performance: Behavior Analysis and Management
By William K Redmon, Thomas C Mawhinney, Carl Merle JohnsonTimberlake (1980, 1984) promulgated a behavioral-regulation analysis of learned performance that emphasizes the importance of behavioral.
-
Money and the Rule of Law: Generality and Predictability in Monetary Institutions
By Peter J. Boettke, Alexander William Salter, Daniel J. Smith190; Timberlake 1993, pp. 356–357). By increasing fiscal expenditures, President Carter may have successfully cornered the Fed into delaying tighter ...
-
Economic Politics: The Costs of Democracy
By William R. Keech, William R Keech( Timberlake , 1993 , p . 4 ) The same was true of the second Bank of the United States , which was chartered in 1816. However , under the leadership of ...
-
Handbook of Organizational Performance: Behavior Analysis and Management
By William K Redmon, Thomas C Mawhinney, Carl Merle JohnsonSchlinger, H. and Blakely, E. (1987). Function-altering effects of ... Timberlake, W. and Allison, J. (1974). Response deprivation: An empirical 48 HANDBOOK ...