Your browser does not fully support modern features. Please upgrade for a smoother 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
${ textCharacter }/${ maxCharacter }
Submit
Cancel
Back
Comments
${ item }
|
${ item.createdUser.fullName }
${ item.createdAt }
${ item.vote }
${ item.reply }
Delete
${ reply.createdUser.fullName }
${ reply.createdAt }
${ reply.vote }
Delete
There is no reply to this comment~
${ item.replyTextCharacter }/${ item.replyMaxCharacter }
Submit
Cancel
More
No more~
There is no comment~
${ textCharacter }/${ maxCharacter }
Submit
Cancel
${ selectedItem.replyTextCharacter }/${ selectedItem.replyMaxCharacter }
Submit
Cancel
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 17 January 2026).
Guerriero V. Fracture Analysis by Simple Excel Sheet with VBA Macro. Encyclopedia. Available at: https://encyclopedia.pub/video/video_detail/1029. Accessed January 17, 2026.
Guerriero, Vincenzo. "Fracture Analysis by Simple Excel Sheet with VBA Macro" Encyclopedia, https://encyclopedia.pub/video/video_detail/1029 (accessed January 17, 2026).
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