In the past, I eschewed Excel. However, I now use Excel frequently and enjoy it very much! What changed?
Starting my Excel Journey During last academic year, my degree program required me to do three laboratory rotations. My first two rotations were computational where I did work in bioinformatics of biochemistry and genetics data. However, for my third rotation, I choose a rotation that was 100% biology lab bench work, with no computational component.
In this video I demonstrate calculations of quantum harmonic oscillator in Excel.
For the best experience, I recommend viewing it full screen!
This video is about creating normally and uniformly distributed random values in Excel.
I recommed viewing it full screen for the best experience!
Functions demonstrated: SEQUENCE(), RAND(), RANDBETWEEN(), RANDARRAY(), NORM.DIST(), NORM.INV().
This video is an example of creating a heatmap of a 2D Gaussian function in Excel using conditional formatting.
I recommed viewing it full screen for the best experience!
Functions demonstrated: SEQUENCE().
Introduction On Kaggle, I found a dataset of customer churn data for a fictitious bank deposited by Radesheshyam Kollipara. It is a simple dataset of just one table. The exercise analyzes which customers are most likely to exit the bank.
The table’s most critical column is the “Exited” column, which in the original data is one if the customer left the bank and 0 if the customer stayed. It also contains other information about each customer and their accounts.
