This laboratory manual is intended for business analysts who wish to increase their skills in the use of data 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, and data visualization. Includes companion files with videos, solution spreadsheets, sample files, data sets, etc. from the book. (Available for downloading with Amazon proof of purchase by writing to the publisher at [email protected].)
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 videos, solution spreadsheets, sample files, data sets, etc. used in the book’s case studies (Available for downloading with Amazon proof of purchase by writing to the publisher at [email protected].)
Brief Table of Contents
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.
About the Author
Andres Fortino, PhD holds an appointment as a clinical associate professor of management and systems at the NYU School of Professional Studies, where he teaches courses in business analytics, data mining, and data visualization. He also leads his own consulting company, Fortino Global Education. Dr. Fortino has published ten books and over 40 academic papers, and has received IBM’s First Invention Level Award for his work in semiconductor research. He holds three US patents and ten invention disclosures.
