We have discussed and learned how powerful a quick analysis can be for determining profitability and other factors of finance, specifically the snapshot attained from a five-number summary. In this book, we have also discussed methods for formatting data tables and creating analysis worksheets for viewing this information. However, with changing data, the ability to attain a summary analysis on data without having to formally build an analysis can be extremely valuable.
In this recipe, you will learn to create an add-in function that will provide a five-number summary of selected data, on-demand.
We will begin this recipe by opening a new blank worksheet: