Strata Analysis for Open Invoices
Go to the Tab named Open Invoices in the Excel workbook. Make sure your data is clean and prepped for analysis. Perform an analysis using ActiveData to stratify the data for the following two views:
a. The CFO would like to present the data as by amount, in strata of 2500 dollars
b. The CFO would like to present the data by due date, in strata of 90 days
c. Generate an associated chart for each, and modify using Excel Charting Tools to improve the presentation and make clear what the charts depict
d. Question: As CFO, verbally describe in a narrative what each of these strata charts show and how they can be used in financial management decision making.