1000/1000
Hot
Most Recent
You're using an outdated browser. Please upgrade to a modern browser for the best experience.
Fracture Analysis by Simple Excel Sheet with VBA Macro
- Subjects: Geology
- |
- Contributor:
- Vincenzo Guerriero
- Maximum Likelihood
- fracture statistical analysis
- Monte Carlo method
- MS Excel
- visual basic for applications
Video Introduction
This video is adapted from 10.3390/geosciences13120379
This technical note illustrates a linear regression algorithm based on the Maximum Likelihood Estimation (MLE), with a related Excel spreadsheet and VBA program, adapted to the case of fracture aperture data sets in which sampling of the smallest values is problematic. The method has been tested by means of Monte Carlo simulations and exhibits significantly better convergence against Least Squares criterion (LSM).
Full Transcript
Confirm
Are you sure to Delete?
Cite
If you have any further questions, please contact Encyclopedia Editorial Office.
Guerriero, V. Fracture Analysis by Simple Excel Sheet with VBA Macro. Encyclopedia. Available online: https://encyclopedia.pub/video/video_detail/1029 (accessed on 05 December 2025).
Guerriero V. Fracture Analysis by Simple Excel Sheet with VBA Macro. Encyclopedia. Available at: https://encyclopedia.pub/video/video_detail/1029. Accessed December 05, 2025.
Guerriero, Vincenzo. "Fracture Analysis by Simple Excel Sheet with VBA Macro" Encyclopedia, https://encyclopedia.pub/video/video_detail/1029 (accessed December 05, 2025).
Guerriero, V. (2024, January 04). Fracture Analysis by Simple Excel Sheet with VBA Macro. In Encyclopedia. https://encyclopedia.pub/video/video_detail/1029
Guerriero, Vincenzo. "Fracture Analysis by Simple Excel Sheet with VBA Macro." Encyclopedia. Web. 04 January, 2024.
Copy Citation