A Primer on Spreadsheet Analytics - Computer Science > Software EngineeringReport as inadecuate

A Primer on Spreadsheet Analytics - Computer Science > Software Engineering - Download this document for free, or read online. Document in PDF available to download.

Abstract: This paper provides guidance to an analyst who wants to extract insight froma spreadsheet model. It discusses the terminology of spreadsheet analytics, howto prepare a spreadsheet model for analysis, and a hierarchy of analyticaltechniques. These techniques include sensitivity analysis, tornado charts,andbacksolving or goal-seeking. This paper presents native-Excel approaches forautomating these techniques, and discusses add-ins that are even moreefficient. Spreadsheet optimization and spreadsheet Monte Carlo simulation arebriefly discussed. The paper concludes by calling for empirical research, anddescribing desired features spreadsheet sensitivity analysis and spreadsheetoptimization add-ins.

Author: Thomas A. Grossman

Source: https://arxiv.org/

Related documents