Introduction
I don't normally work with VBA Macros but I have preparaed an analysis of the following financial and other information for BMW for the last 15 years.
Firstly, my introduction and then the data
In this file, I carried out the following
- correlation matrix
- descriptive statistics
- graphs of each variable
- Stepwise multiple linear regression with Y = EBIT ... to find the optimal model
- Residuals analysis
- Standardised residuals analysis
- Graphs of the residuals and standardised residuals analysis
You can run each of the 10 macros one by one or all at once, using the combined macro
You can download this file from here and if you have similar data: 15 years' worth, not necessarily the same data as I have ... you can run these macros on your data!
This file and all its contents have been created exclusively for this blog and have not been shared with anyone else: it is a bonus file for Blog Subscribers.
Duncan Williamson
18th June 2024
No comments:
Post a Comment