Fracture Analysis by Simple Excel Sheet with VBA Macro
  • View Times: 48
  • |
  • 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

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 2024).
Guerriero V. Fracture Analysis by Simple Excel Sheet with VBA Macro. Encyclopedia. Available at: https://encyclopedia.pub/video/video_detail/1029. Accessed December 05, 2024.
Guerriero, Vincenzo. "Fracture Analysis by Simple Excel Sheet with VBA Macro" Encyclopedia, https://encyclopedia.pub/video/video_detail/1029 (accessed December 05, 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.
ScholarVision Creations