Book Description

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 The companion files are available online by emailing the publisher with proof of purchase at [email protected].