Data Analysis for Business Decision Making: A Laboratory manual

Cover
Half-Title
Title page
Copyright
Dedication
Contents
Preface
Chapter 1 – SHAPING AND CLEANINGDATA
	Analysis Case 1.1 – Shaping the Data File
	Analysis Case 1.2 – Cleaning the Data File
Chapter 2 – INSTALLING THE ANALYSISTOOLPAK
	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 theORDERS 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 AirportSurvey Data
Chapter 4 – HISTOGRAMS
	Analysis Case 4.1 – Histograms
	Frequency Distributions
	Analysis Case 4.2 – Additional Case Using Titanic Data
Chapter 5 – PARE TO 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 AirportSurvey 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 AirportSurvey Data
Chapter 7 – CORRELATION AND LINEARREGRESSION
	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 AirportSurvey Data
Chapter 8 – MULTIVARIATE REGRESSION
	Analysis Case 8.1 – Multivariate Regression
	Predictive Modeling
	Analysis Case 8.2 – Additional Case Using SFO AirportSurvey Data
Chapter 9 – FORECASTING AND TIMESERIES
	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 AirportSurvey 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 AirportSurvey 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 AirportSurvey Data
	Analysis Case 12.4 – Additional Analysis Cases Using TitanicData
Chapter 13 –  TEX T ANALY TICS
	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 theBankComplaints 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 basiccharts 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 ratherthan beautiful art?
	Case Analysis
	Analysis Case 15.3 – Purpose
	Consider the Information Need – Does the chart fulfill organizationalinformation needs?
	Consider the Audience – Does the chart allow for audience biases,needs, and journeys?
	Answer Well-Framed Analytical Questions – Does the visual answera well-framed analytical question?
	Case Analysis
	Analysis Case 15.4 – Perception
	Use the Eye-Brain System of Seeing – Does the eye of the viewer focuson the most important point being made?
	Employ the Gestalt Principles of Perception – Have the principles ofthe Gestalt psychology of perception been thoughtfully employed in thevisual?
	Design with Quality – Does the visual inform the viewer and dispel hisignorance?
	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 visualelements not leading to a clear point being made?
	Tell the Story with the Title – Does the title of the chart convey thepoint 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 levelof judgment required?
	Select the Chart Type Effectively – Does the chart type used match thebusiness question being answered?
	Enhance Table Data for Emphasis – Are referenceable visuals(tables) readable with appropriate conditional formatting andthumbnail graphs used for emphasis?
	Case Analysis
	Analysis Case 15.7 – Putting It All Together
	A Possible Solution
Chapter 16 –  SUMMARY OF ANALYSISTECHNIQUES
	Business Questions and Analysis Techniques for Addressing Them
	Data Sources
INDEX