Skip to main content

A Relief from Spreadsheet Misery

  • Chapter
  • First Online:
Business Case Analysis with R
  • 2751 Accesses

Abstract

Business case analyses that are typically developed in spreadsheets are fraught with a lack of transparency and prone to propagating significant coding errors. The R programming language provides a better alternative for creating clear and minimal-error analysis.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 29.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 37.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    http://www.r-project.org

  2. 2.

    http://www.businessinsider.com/excel-partly-to-blame-for-trading-loss-2013-2

  3. 3.

    http://www.businessinsider.com/thomas-herndon-michael-ash-and-robert-pollin-on-reinhart-and-rogoff-2013-4?goback=%2Egde_1521427_ member_234073689

  4. 4.

    You will find other examples of spreadsheet errors at Raymond Panko’s web site at http://panko.shidler.hawaii.edu/SSR/index.htm . Panko researches the cause and prevalence of spreadsheet errors.

  5. 5.

    Spreadsheets allow the use of named references, but the naming convention can become unwieldy if sections in an array need different names.

Author information

Authors and Affiliations

Authors

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Robert D. Brown III

About this chapter

Check for updates. Verify currency and authenticity via CrossMark

Cite this chapter

Brown III, R.D. (2018). A Relief from Spreadsheet Misery. In: Business Case Analysis with R. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-3495-2_1

Download citation

Publish with us

Policies and ethics