![Dr. Gerard Verschuuren](/img/default-banner.jpg)
- 256
- 5 795 216
Dr. Gerard Verschuuren
เข้าร่วมเมื่อ 21 มิ.ย. 2013
At the interface of science and technology
Can we prove that God exists?
What scientific proofs and mathematical proofs cannot do is what philosophical proofs can do with 100% certainty. Let me explain how.
มุมมอง: 310
วีดีโอ
Science under the Miscroscope
มุมมอง 18911 หลายเดือนก่อน
In this book, science has its say. But not with the pretension that science has the last word. We want to look beyond the scientific nose. And for that you need a philosophical analysis. That amounts to putting science under “the microscope of philosophy.”
A Beautiful Mind and Soul
มุมมอง 208ปีที่แล้ว
Dr. Stephen Barr comments on my book A Beautiful Mind and Soul. He is a particle physicist and is currently the president of the Society of Catholic Scientists.
How God Made Earth Our Home
มุมมอง 2.1K4 ปีที่แล้ว
Instead of the vaunted "randomness" of our immense universe, scientists have recently discovered indisputable patterns in the structures of matter and energy. Over the eons, these distinctive patterns drove the universe inexorably toward formation of the Earth as what we experience it to be: our secure, exceptional, and singularly welcoming home.
Send Email Reminders at certain Dates
มุมมอง 38K6 ปีที่แล้ว
If you need to remind people of certain dates or times, you can do so from Excel by using Outlook. This requires Excel functions and formulas combined with VBA script.
Simulation of the Galton Board
มุมมอง 8K6 ปีที่แล้ว
The Galton or bean board creates normal distributions with a bell-shaped curve. This Excel spreadsheet simulates how the board works.
Transforming Data with a LogNormal Distribution
มุมมอง 75K7 ปีที่แล้ว
If your values are not normally distributed but have a lognormal distribution, you may want to transform them into a normally distributed data set, so you can apply regular statistical techniques, such as significance testing and determining confidence or prediction limits. Here is how to do that.
Working with Dates in Excel
มุมมอง 3.3K7 ปีที่แล้ว
Users of Excel often need to deal with dates. How can that be done best and how can we extract information from dates? This video shows you many tools and tricks.
Simulation of Holism and Reductionism
มุมมอง 1.1K7 ปีที่แล้ว
Simply put, reductionism promotes breaking things down in science, to simplify them for further study, whereas holism tries to put things back together again so we see them in their context. In this video, we use a simple simulation that breaks a word apart and then puts the letters back together in a random way until we reach the original setting.
Learn to Conquer Excel and Access
มุมมอง 1.5K7 ปีที่แล้ว
244 different videos to make you an expert with Excel or Access. Here you can find all of them together, so you can access individual videos of your choosing. Yes, here!!!
Interpolation with Formulas and VBA
มุมมอง 24K7 ปีที่แล้ว
Interpolation allows you to locate an unobserved value in a set of observed values. It can be done by using functions such as INDEX, MATCH, and TREND, or by using VBA code.
Managing Gradients in Excel
มุมมอง 1.5K7 ปีที่แล้ว
When you want smooth transitions between certain values, you need in-between calculations based on surrounding cells and the center cell itself. Here are two ways: using mere formulas or running Visual Basic.
Simulation of Election Polls
มุมมอง 1.6K7 ปีที่แล้ว
This video shows you the simulation of polling a population based on sampling. This can be done in Excel with formulas and functions only, or with the help of Visual Basic.
Monte Carlo Simulation to Buy/Sell Stock
มุมมอง 18K7 ปีที่แล้ว
Monte Carlo Simulation to Buy/Sell Stock
Deleting multiple, discontinuous rows with VBA
มุมมอง 3.8K8 ปีที่แล้ว
Deleting multiple, discontinuous rows with VBA
Bootstrapping for Non-Normal Distributions
มุมมอง 8K8 ปีที่แล้ว
Bootstrapping for Non-Normal Distributions
How To Change Internet explorer To Microsoft Edge
Hello! I know this video was posted a long time ago but by chance do you still have the excel file available? I tried the link you posted in the comments but it seems to not work. Could you potentially post a new link to the excel file or send it to my email.
This guy saved me hundreds of pounds. You are a genius ❤
Dear Dr Verschuuren. Thank you for such excelent and didactical tutorial. My issues are on a sinus voltage & current measuring series, but with only 20 values per cycle (voltage and current of the same phase), due to an low 1200 Sample/s rate, over a 90s @ 60 Hz measuring window. Now I need to determine an angular phase difference (phi) between a voltage senoid and its current senoid, to calculate [cos phi] of this angular difference (the result makes the power factor, either advanced or delayed). So with only 20 values recorded, a gross error in cos phi will be produced, where an accurate 2nd decimal cipher shall be produced. Given that a whole cycle is 360°, how can I interpolate within the sinus function to get four to ten times more values, in order to have better accuracy on each zero crossing point (voltage and current), to have the said difference (phi)? I guess this is a non-linear, function & amplitude-conditioned interpolation. Thank you in advance S. C. Kirschstein [sc.kirschstein@gmail.com]
Thank you so , so much, very helpful video Ich danke Ihnen
Great explanation of the filter string. Much appreciated.
Now I know how to show positive values on the left and right sides of the stacked bar chart.
Thank you!
Thank you!! I now know how to show positive percentage values on the right and left side of my stacked bar chart.
This did not work for me
thank you for the video!
I never dreamed of this. It takes me by surprise. I feel like you gave me a birthday present. Thank you.
Brilliant, I'm buying the full book!
THANK YOU A ZILLION!!!!!!
Nice explanation No doubt salute sir
The distributional parameters are not preserved. If X and Z are iid Normal (10,2), and Y=rX + SQRT(1-r^2)Z where r is the target correlation, then Y is effectively a weighted average of X and Z, each of which have a mean of 10. But the weights sum to more than 1, so the mean of Y will always be more than 10. For example, suppose that r=1/2. Then SQRT (1-r^2) is the square root of 1/2, which is SQRT(2)/2, which is about 0.707. Then the sum of the "weights" is 0.5+0.707 = 1.207, and Y will "overshoot" by 20.7%, on average. To make this work, all of the Y values would have to be multiplied by 1/(1+SQRT(1-r^2)).
Can you elaborate on why the correction factor is needed and the motive? I found through a simulation that even with your correction factor, the correlation coefficient still over(under)shoots by +/-35%-50%. Basically, I simulated 2 scenarios and ran 50 trials whereby the 1st is the correlation equation as presented in the video and the 2nd is by correcting each and all Y values with your correction factor. And in my view, I don't think you should modify the correlation equation Y by your 'corrected' factor since it relates to matrices at the end of the day.
Dr, you should make audiobooks of your work, with you as narrator. Keep up the good work. Cheers.
How do we create date range for crosstab query, using "Between [Forms]![frmQDate]![QDateFrom] And [Forms]![frmQDate]![QDateTo]". This code is not working for crosstab query MS Access engine does recognize it as valid field. Then How do we do that, how do we create date range for crosstab query ?
Thanks, was very helpful video
In the last part of the video, I believe the transpose on the Cholesky decomposition is not needed and would provide you with better results that more closely resemble the original correlation matrix. Can someone please check?
A warning to anyone who stumbles across this like I did: Lookup Fields in tables of your Access Database are evil. First, any query that tries to order the table data by that company name will not work, because the underlying value isn't the name, but instead a CompanyID number. Nor will any queries that use a company name in that field as a criteria. Second, if a filter is applied to the combobox as is created in this form, the persistent filter effect of Access may save that to the underlying query in the table and the next time the form is opened there will be a prompt for the value which cannot be provided, thus creating an error. And finally, any Access database that has Lookup Fields in tables cannot be upsized to, or queried by, any other database management engine without first removing all the lookup fields because no other engines use or understand them. Think very carefully before implementing any solution that uses Lookup Fields in tables in your Access database.
how to identify the actual real life data , why we are using here random number between 0-1 ?
What do the outsider values mean? The ones that landed outside of the confidence intervals?
Hi Dr. wish you well. I already subscribed your channel. Thumbs up for all your valuable tutorials. I have database that I splitted and put it in shared drive. Is there a way to protect the code? thanks a lot
Great video! Trying to figure out how to open an excel file and refresh all data sources and then close it with a script such as this. I'm not a programmer but looking to run this once daily to update this file. What would that script be? Any help would be much appreciated
Amazingly this 8 year old video is still one of the very few resources on TH-cam addressing crosstabs in reports. Thank you for this!
Where I can download or buy for it?
Hello DR. Verschuuren, this week I ordered your book 130 Simulations from Business to Science and Gambling and have a question about Chapter 88, specifically cells B20:E27. Why do some scenarios return zero?
How to make a parameter report where the form is a columnnar having multiple pages.
Very clean explanation, even 8 years later ;)
Hello That's a great tuto. However, it looks like Sunday is still the first day of the week. How to set Monday as the first day of the week ? I tried to set Monday as the first day of the using this line. I am correct ?? dDate = Date - Weekday((Date), vbMonday) + 1
The 🐐
CD isn't AVAILABLE....
Sorry, this item is temporarily out of stock Can't SELL if you don't HAVE
What do I do if the extrapolated value falls off the trendline
Too complicated for me
Fantastic template and excellent presentation Dr. Verschuuren! Is it possible to do the same (And Plot PIs and CIs) in Excel with quadratic, cubic or arbitrary curve-fit? I always have to go to Minitab when I need these estimates. I would like to do this totally in Excel with non-linear dependencies.
thanks for the video.. i learned a lot even if i'm not new to excel
Hey Gerard, very helpful information thank you, I'm guessing by your name & accent you're Dutch. My Dad is from Holland & we have the same name. Lol
What is the difference between confidence interval for the slope and the confidence interval for the mean?
What if I want to populate RaceGroup column when Country Column is typed the country or when imported or appended data. Does this method applies or I have to use Dlookup afterupdate? I have the list of Countries and related Race-Group or Nationality. I could make combo box which we have. But the goal is to avoid clicking to much on combos to select the country. We want to avoid typing. Example when I import or append many rows with patients and countries. So after the importation or appending I want to see the country column and nationality or Race-Group to be populated. When you have too many columns and hundreds of rows you don't want to keep clicking on combo to drop down, etc. It's a lot stress on the hand for unnecessary repetitive tasks.
how to encrypted Combine the alphanumeric?
👍
Thank you sir 🙏
Thank you sir 🙏
You are a God. In university and still using TH-cam tutorials
Even today in 2023 this is one of the best explanations for using VBA to convert dates to a calendar. I've tried using CHATGPT and failed. With this video, I got it to work!!
Dr.Gerard, best of the best, thank you!: th-cam.com/video/_9rfzYTMs1E/w-d-xo.html
How do I add record in the subform with another data?