Regression Analysis Microsoft Excel

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

這是今天最完整的使用 Microsoft® Excel 進行迴歸分析的指南，適用於任何商業分析或研究任務。憑藉25年的高級統計經驗，Microsoft MVP Conrad Carlberg展示了如何使用Excel的迴歸相關工作表函數進行各種實用分析。

Carlberg清楚地解釋了所有你需要了解的理論，以避免錯誤，了解你的迴歸分析的真正作用，並評估他人進行的分析。從簡單的相關性和t檢驗到多元共變異分析，Carlberg提供了有意義的實例進行逐步操作的實用指南。

他討論了使用每個選項和參數的後果，指出了與Excel的迴歸函數相關的特殊性和爭議，並展示了如何在醫學研究、財務分析和運營等領域可靠地使用它們。

你不需要昂貴的軟體或統計學博士學位來進行迴歸分析。Microsoft Excel擁有你所需的所有工具，而這本書則提供了所有相關知識！

以下是本書的主要內容：
- 理解迴歸分析的能力和限制，以及原因
- 掌握內建在最新版本的Excel中的基於迴歸的函數
- 使用相關性和簡單迴歸進行分析
- 充分利用Excel改進的LINEST()函數
- 計劃並執行多元迴歸分析
- 區分重要的假設和不重要的假設
- 通過使用迴歸而不是傳統變異數分析來擴展分析選項
- 添加共變量到分析中以減少偏差並增加統計功效