Mastering Financial Modelling in Microsoft Excel 3rd edn, 3rd Edition

23

Data functions

Introduction

Dataset

Database functions

Descriptive statistics

Histogram

Function output

Box plots

Summary

INTRODUCTION

The previous chapters have concentrated on financial models for cash flow and risk, whereas the next two chapters review some of the data analysis functions that take blocks of data and produce statistics, charts and tables. Organisations hold increasing amounts of data and need to present varying levels of detail to different audiences. The model for this chapter is called MFM3_23_Data_Functions.

DATASET

The dataset consists of some leasing sales data on transactions written by individual salespeople on different types of products. There is a header row followed by 1,000 records (Figure 23.1). The original ...