Data Analysis for Business Decisions: Case Studies in Excel, R, and ChatGPT, Third Edition
Andres Fortino
Contents
Preface ix
Acknowledgments xiii
Chapter 1: Data Analysis and Business 1
Introduction to Data Analysis and Business 3
Business Analytics and Business Intelligence 7
Algorithmic Technologies Associated with Data Analysis 8
Data Analysis and Data Mining 10
References 13
Chapter 2: Framing Analytical Questions 15
Framing Analytical Questions 17
References 34
Chapter 3: Data Preparation 35
Data Preparation 37
Chapter 4: The Analysis Tools 59
The Analysis Tools 61
Excel Analysis Tools: The Analysis ToolPak 64
R Analysis Tool: Jamovi 67
Generative AI: ChatGPT 68
Chapter 5: Descriptive Statistics 79
Descriptive Statistics 80
Chapter 6: Histograms 113
Histograms 115
Chapter 7: Pareto Analysis 133
Pareto Analysis 135
Chapter 8: Scatterplots 165
Scatterplots 167
Chapter 9: Correlation and Linear Regression 189
Correlation and Linear Regression 191
Chapter 10: Multivariate Regression 213
Multivariate Linear Regression 216
Chapter 11: Forecasting and Time Series 235
Forecasting and Time Series Analysis 237
Chapter 12: Inferential Statistics 269
Inferential Statistics 272
ChatGPT Answer to the Framed Analytical Question 296
Chapter 13: Contingency Analysis 299
Contingency Analysis 301
Chapter 14: A/B Testing 335
A/B Testing 337
Chapter 15: Text Analytics 353
Text Analytics 355
Chapter 16: Analyzing Large Datasets 371
Using Sampling to Work with Large Data Files 373
Chapter 17: Data Visualization 383
Data Visualization 386
Improving Data Visuals Using Generative AI 400
References 408
Chapter 18: Summary of Data Analysis Techniques 409
Business Questions and Analysis Techniques for Addressing Them 410
Appendix: Data Sources 413
Index 415