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
Author(s): Andres Fortino
Edition: 2
Publisher: Mercury Learning and Information
Year: 2020
Language: English
Pages: 167
Cover
Title
Copyright
Dedication
Contents
Preface
Chapter 1 Shaping and Cleaning Data
Analysis Case 1.1 – Shaping the Data File
Analysis Case 1.2 – Cleaning the Data File
Chapter 2 Installing the Analysis Toolpak
Analysis Case 2.1 – Excel Analysis ToolPak
Installation and Activation
Chapter 3 Descriptive Statistics
Analysis Case 3.1 – Descriptive Statistics
Five-Point Summaries
Analysis Case 3.2 – Additional Analysis Case Using the ORDERS File
Analysis Case 3.3 – Descriptive Statistics
Tabulation and Pivot Tables
Analysis Case 3.4 – Additional Case Using Titanic Data
Analysis Case 3.5 – Additional Case Using SFO Airport Survey Data
Chapter 4 Histograms
Analysis Case 4.1 – Histograms
Frequency Distributions
Analysis Case 4.2 – Additional Case Using Titanic Data
Chapter 5 Pareto Analysis
Analysis Case 5.1 – Pareto Analysis
Which Are the Most Important?
Analysis Case 5.2 – Additional Case Using MOVIES Data
Analysis Case 5.3 – Additional Case Using ORDERS
Analysis Case 5.4 – Additional Case Using SFO Airport Survey Data
Chapter 6 Scatter Plots
Analysis Case 6.1 – Scatter Plots and 2x2 Analysis
Which Are the “Best”?
Analysis Case 6.2 – Additional Case Using World Bank Data
Analysis Case 6.3 – Additional Case Using SFO Airport Survey Data
Chapter 7 Correlation and Linear Regression
Analysis Case 7.1 – Correlation and Linear Regression
How Are the Variables Related?
Analysis Case 7.2 – Additional Case Using ORDERS
Analysis Case 7.3 – Additional Case Using SFO Airport Survey Data
Chapter 8 Multivariate Regression
Analysis Case 8.1 – Multivariate Regression
Predictive Modeling
Analysis Case 8.2 – Additional Case Using SFO Airport Survey Data
Chapter 9 Forecasting and Time Series
Analysis Case 9.1 – Forecasting and Time Series
Predicting Trends and Future Values
Analysis Case 9.2 – Additional Case Using ORDERS
Analysis Case 9.3 – Additional Case Using MOVIES
Analysis Case 9.4 – Additional Forecasting Case Study
Chapter 10 Inferential Statistics
Analysis Case 10.1 – Assurance of Results
Inferential Statistics
Analysis Case 10.2 – Additional Case Using FOOTBALLTRIALS
Analysis Case 10.3 – Additional Exercise Using SFO Airport Survey Data
Chapter 11 Contingency Analysis
Analysis Case 11.1 – Contingency Analysis and Chi-Squared
Test of Variable Independence
Analysis Case 11.2 – Additional Case Using SFO Airport Survey Data
Chapter 12 A/B Testing
Analysis Case 12.1 – Design and Analysis of Trials
A/B Testing
Analysis Case 12.2 – Additional Case Using ORDERS
Analysis Case 12.3 – Additional Case Using SFO Airport Survey Data
Analysis Case 12.4 – Additional Analysis Cases Using Titanic Data
Chapter 13 Text Analytics
Analysis Case 13.1 – Unstructured Text Analysis I
Analysis Case 13.2 – Unstructured Text Analysis II
Using Excel for Sentiment Analysis
Chapter 14 Analyzing Big Data Sets
Analysis Case 14.1 – Big Data Analysis
Using Sampling to Work with Large Data Files
Analysis Case 14.2 – Additional Case Using the BankComplaints Big Data File
Chapter 15 Data Visualization
The Case
The Analysis Template
Analysis Case 15.1 – Story
Create a Visual Story − Is the point of the visual very clear?
Make It a Prop − Has the visual has been simplified and focused?
Emulate Legendary Storytellers − Are past masters and the basic charts that they pioneered emulated?
Case Analysis
Analysis Case 15.2 – Signs
Give Them a Sign − Is the use of signs and symbols appropriate?
It’s Like a Communication System − Is the signal-to-noise ratio high?
Design for Function − Is the chart functionally informational rather than beautiful art?
Case Analysis
Analysis Case 15.3 – Purpose
Consider the Information Need – Does the chart fulfill organizational information needs?
Consider the Audience – Does the chart allow for audience biases, needs, and journeys?
Answer Well-Framed Analytical Questions – Does the visual answer a well-framed analytical question?
Case Analysis
Analysis Case 15.4 – Perception
Use the Eye-Brain System of Seeing – Does the eye of the viewer focus on the most important point being made?
Employ the Gestalt Principles of Perception – Have the principles of the Gestalt psychology of perception been thoughtfully employed in the visual?
Design with Quality – Does the visual inform the viewer and dispel his ignorance?
Case Analysis
Analysis Case 15.5 – Method
Use Color Effectively – Is color used judiciously and sparsely?
Remove All Chart Junk – Is the visual is clear of unnecessary visual elements not leading to a clear point being made?
Tell the Story with the Title – Does the title of the chart convey the point being made with the chart?
Case Analysis
Analysis Case 15.6 – Charts
Use the Right Chart – Does the type of chart being used match the level of judgment required?
Select the Chart Type Effectively – Does the chart type used match the business question being answered?
Enhance Table Data for Emphasis – Are referenceable visuals (tables) readable with appropriate conditional formatting and thumbnail graphs used for emphasis?
Case Analysis
Analysis Case 15.7 – Putting It All Together
A Possible Solution
Chapter 16 Summary of Analysis Techniques
Business Questions and Analysis Techniques for Addressing Them
Data Sources
Index
