Data Analysis for Business Decisions (Edition 2‪)‬

This laboratory manual is intended for business analysts who wish to increase their skills in the use of statistical analysis to support business decisions. Most of the case studies use Excel, today's most common analysis tool. They range from the most basic descriptive analytical techniques to more advanced techniques such as linear regression and forecasting. Advanced projects cover inferential statistics for continuous variables (t-Test) and categorical variables (chi-square), as well as A/B testing. The manual ends with techniques to deal with the analysis of text data and tools to manage the analysis of large data sets (Big Data) using Excel. Includes companion files with solution spreadsheets, sample files, data sets, etc. from the book.


Features:


Teaches the statistical analysis skills needed to support business decisions
Provides projects ranging from the most basic descriptive analytical techniques to more advanced techniques such as linear regression, forecasting, inferential statistics, and analyzing big data sets
Includes companion files with solution spreadsheets, sample files, data sets, etc. used in the book's case studies



1: Shaping and Cleaning Data

2: Installing the Analysis ToolPak

3: Descriptive Statistics

4: Histograms. 

5: Pareto Analysis

6: Scatter Plots

7: Correlation and Linear Regression

8: Multivariate Regression 

9: Forecasting and Time Series

10: Inferential Statistics

11: Contingency Analysis

12: A/B Testing 

13: Text Analytics

14: Analyzing Big Data Sets

15: Data Visualization

16. Summary of Analysis

Techniques.

Index.