Fracture Analysis by Simple Excel Sheet with VBA Macro
  • View Times: 14
  • |
  • Release Date: 2024-01-04
  • 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
1000/1000
Hot Most Recent
©Text is available under the terms and conditions of the Creative Commons-Attribution ShareAlike (CC BY-SA) license; additional terms may apply. By using this site, you agree to the Terms and Conditions and Privacy Policy.

Confirm

Are you sure to Delete?
Yes No
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 28 April 2024).
Guerriero V. Fracture Analysis by Simple Excel Sheet with VBA Macro. Encyclopedia. Available at: https://encyclopedia.pub/video/video_detail/1029. Accessed April 28, 2024.
Guerriero, Vincenzo. "Fracture Analysis by Simple Excel Sheet with VBA Macro" Encyclopedia, https://encyclopedia.pub/video/video_detail/1029 (accessed April 28, 2024).
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.
Feedback