Downloads

This page shows data and spreadsheets used during the course of this book.

Description Chapter Download
ACME financial data, showing detailed information for the fictitious company used in several parts of the book. 2 Download XLS
This small model calculates whether there is a significant difference between two means or two proportions. 5 Download XLS
A dynamic model which explains the difference between standard deviation and the standard error of the mean (SEM). 5 Download XLS
Another dynamic simulation model, used this time for major incidents. 9   Download XLS
This spreadsheet shows the layout of the LP model discussed in the chapter. To amend the constraints, invoke Solver. 10  Download XLS
This model demonstrates how the total tax burden changes with elasticity of demand, including the proportions paid by the supplier and customer. 13   Download XLS
Calculations used when accounting for different rates of inflation for selected account components. 15   Download XLS
Relationship between inflation and the exchange rate; accounting for exchange rate in import costs. 15 Download XLS
Demonstration of EOQ as the minimum stockholding cost 19 Download XLS  
Simple regression of yield versus rainfall 22  Download XLS
Multivariate regression analysis using Acme data. The file also includes dummy variables introduced in chapter 24. 23,24 Download XLS  
Use of non-.linear regression (quadratic function) 25 Download XLS  
An example of Stepwise regression (note: this file is of limited use without the Excel Stepwise add-in). 25   Download XLS
Data for the UK-Greece air transport market including time series calculations. 26   Download XLS
As above but for the UK-Japan air transport market. 27   Download XLS
A demonstration of the investment appraisal technique and a calculation of WACC. 35 Download XLS
Workbook used for analysis of variance calculations and charts 36   Download XLS