Statistical Analysis: Microsoft Excel 2016

Conrad Carlberg

  • 出版商: QUE
  • 出版日期: 2017-12-04
  • 售價: $1,680
  • 貴賓價: 9.5$1,596
  • 語言: 英文
  • 頁數: 568
  • 裝訂: Paperback
  • ISBN: 0789759055
  • ISBN-13: 9780789759054
  • 相關分類: Excel
  • 無法訂購

商品描述

USE EXCEL’S STATISTICAL TOOLS TO TRANSFORM YOUR DATA INTO KNOWLEDGE



Nationally recognized Excel expert Conrad Carlberg shows you how to use Excel 2016 to perform core statistical tasks every business professional, student, and researcher should master. Using real-world examples and downloadable workbooks, Carlberg helps you choose the right technique for each problem and get the most out of Excel’s statistical features. Along the way, he clarifies confusing statistical terminology and helps you avoid common mistakes.

 

You’ll learn how to use correlation and regression, analyze variance and covariance, and test statistical hypotheses using the normal, binomial, t, and F distributions. To help you make accurate inferences based on samples from a population, Carlberg offers insightful coverage of crucial topics ranging from experimental design to the statistical power of F tests. Updated for Excel 2016, this guide covers both modern consistency functions and legacy compatibility functions.


Becoming an expert with Excel statistics has never been easier! In this book, you’ll find crystal-clear instructions, insider insights, and complete step-by-step guidance.


  • Master Excel’s most useful descriptive and inferential statistical tools
  • Understand how values cluster together or disperse, and how variables move or classify jointly
  • Tell the truth with statistics—and recognize when others don’t
  • Infer a population’s characteristics from a sample’s frequency distribution
  • Explore correlation and regression to learn how variables move in tandem
  • Use Excel consistency functions such as STDEV.S( ) and STDEV.P( )
  • Test differences between two means using z tests, t tests, and Excel’s Data Analysis Add-in
  • Identify skewed distributions using Excel’s new built-in box-and-whisker plots and histograms
  • Evaluate statistical power and control risk
  • Explore how randomized block and split plot designs alter the derivation of F-ratios
  • Use coded multiple regression analysis to perform ANOVA with unbalanced factorial designs
  • Analyze covariance with ANCOVA, and properly use multiple covariance
  • Take advantage of Recommended PivotTables, Quick Analysis, and other Excel 2016 shortcuts

商品描述(中文翻譯)

使用Excel的統計工具將您的數據轉化為知識

全國知名的Excel專家Conrad Carlberg向您展示如何使用Excel 2016執行每個商業專業人士、學生和研究人員都應該掌握的核心統計任務。Carlberg通過真實世界的例子和可下載的工作簿,幫助您為每個問題選擇合適的技術,並充分利用Excel的統計功能。在此過程中,他澄清了令人困惑的統計術語,並幫助您避免常見的錯誤。

您將學習如何使用相關性和回歸分析、分析變異和協方差,以及使用正態分佈、二項分佈、t分佈和F分佈進行統計假設檢驗。為了幫助您根據來自人口樣本的樣本進行準確的推斷,Carlberg提供了有關從實驗設計到F檢驗的統計功效的深入涵蓋。此指南已更新至Excel 2016,涵蓋了現代一致性函數和舊版兼容性函數。

成為Excel統計專家從未如此輕鬆!在本書中,您將找到清晰明確的指導、內部見解和完整的逐步指導。

- 掌握Excel最有用的描述性和推論性統計工具
- 理解數值如何聚集或分散,以及變量如何聯合移動或分類
- 用統計數據說實話,並識別他人的不實之處
- 從樣本的頻率分佈推斷出人口的特徵
- 探索相關性和回歸分析,了解變量如何同步移動
- 使用Excel的一致性函數,如STDEV.S()和STDEV.P()
- 使用z檢驗、t檢驗和Excel的數據分析增益進行兩個均值之間的差異檢驗
- 使用Excel的新內置盒式圖和直方圖識別偏斜分佈
- 評估統計功效並控制風險
- 探索隨機區塊和分割區塊設計如何改變F比率的推導
- 使用編碼多元回歸分析執行具有不平衡因子設計的ANOVA
- 使用ANCOVA分析協方差,並正確使用多個協方差
- 利用推薦樞紐表、快速分析和其他Excel 2016快捷方式