Data Analysis for Business Decision Making: A Laboratory manual

• Tongue: English
• Leaves: 181
• Edition: 2
• Category: Library

✦ Table of Contents

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