A Primer on Spreadsheet Analytics

Details A Primer on Spreadsheet Analytics A Primer on Spreadsheet Analytics

2008-09-21

arxiv.org/abs/0809.3586v1

Proc. European Spreadsheet Risks Int. Grp. (EuSpRIG) 2008 129-140 ISBN 978-905617-69-2

Computer Science

Software Engineering

12 Pages, 8 Colour Figures

Scientific paper

This paper provides guidance to an analyst who wants to extract insight from a spreadsheet model. It discusses the terminology of spreadsheet analytics, how to prepare a spreadsheet model for analysis, and a hierarchy of analytical techniques. These techniques include sensitivity analysis, tornado charts,and backsolving (or goal-seeking). This paper presents native-Excel approaches for automating these techniques, and discusses add-ins that are even more efficient. Spreadsheet optimization and spreadsheet Monte Carlo simulation are briefly discussed. The paper concludes by calling for empirical research, and describing desired features spreadsheet sensitivity analysis and spreadsheet optimization add-ins.

Affiliated with

Also associated with

No associations

Rating

A Primer on Spreadsheet Analytics does not yet have a rating. At this time, there are no reviews or comments for this scientific paper.

If you have personal experience with A Primer on Spreadsheet Analytics, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and A Primer on Spreadsheet Analytics will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFWR-SCP-O-507022