geostatsguy / excelnumericaldemos

A set of numerical demonstrations in Excel to assist with teaching / learning concepts in probability, statistics, spatial data analytics and geostatistics. I hope these resources are helpful, Prof. Michael Pyrcz

I'm Michael Pyrcz (a.k.a. GeostatsGuy), a professor working in Data Analytics, Geostatistics and Machine Learning at The University of Texas at Austin, Austin, Texas, USA and a Ukrainian Canadian. I share all of my university content to support my students, potential students and working professionals interested to learn about data science. I have a lot of well-documented workflows in Python, R (and even Excel) in my repositories, including all of the hands-on exercises and demonstrations for all of my lectures shared freely on my YouTube channel. Follow me on Twitter, where I share resources and positivity daily.

excelnumericaldemos's Issues

Two typos: Alberta Einstein and Categorical

On the ExcelNumericalDemos, there are two typos:

1. Alberta Einstein instead of Albert Einstein, see: https://github.com/GeostatsGuy/ExcelNumericalDemos
2. Cateogrical Indicator Kriging Demo instead of Categorical, see: 565bf81

PS: Thank you very much for sharing all of your knowledge, explanations, demos, code and everything for everyone!

Some issues in Simple_Kriging_Demo.xlsx

Hello and hope you are doing well.
First I have to appreciate your efforts on providing useful resources.
I was checking Simple_Kriging_Demo.xlsx file and I think I came across some errors in it.
1 - In the matrix number 4, its diagonal elements are set to fixed value 0. It has to be equal to the nugget!
2 - In the matrix number 5, I think covariance are being calculated in a wrong way because if I'm not wrong, we know that:
Covariance + Variogram = Sill (spherical) but when I inspect the cell formula I find something different

I'm glad if you could help me with mentioned issues ( maybe I'm wrong )

Thanks in advance.

ID vs. OK

Hi Michael,
Here's my little Demo, more to come!
cheers

David

Inverse Distance interpolation vs Ordinary Kriging.xlsx