Skip to main content

Consolidating Multiple Naïve Forecasts with Monte Carlo

  • Chapter
  • First Online:
Business Statistics for Competitive Advantage with Excel 2016
  • 16k Accesses

Abstract

The modeling team compared export market forecasts for the U.S. and Latin America, shown in Figure 6.1. Exports to the U.S. were much more consistent, stable and predictable. The trend accounted for 93% of the variation in U.S. exports, and the margin of error in forecasts was small, .24 ML. However, forecast growth was low, 4 to 5% per year. Exports to Latin America differed. While the trend accounted for 92% of the variation in Latin American exports, the margin of error was larger, .51ML. Yet future growth was higher, 5 to 9% per year.

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 79.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 99.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 129.99
Price excludes VAT (USA)
  • Durable hardcover 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

Author information

Authors and Affiliations

Authors

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer International Publishing Switzerland

About this chapter

Cite this chapter

Fraser, C. (2016). Consolidating Multiple Naïve Forecasts with Monte Carlo. In: Business Statistics for Competitive Advantage with Excel 2016 . Springer, Cham. https://doi.org/10.1007/978-3-319-32185-1_6

Download citation

Publish with us

Policies and ethics