This post was inspired by reading a Quora response where the child of a top 1% family says that one of the advantages of his upbringing is that his parents taught him about how business works. “Business” is a somewhat broad term that some schools say takes two years and $120k in tuition to “master”. However, as we typically do in this blog, we can educate ourselves on some of the central concepts of business on our own through spreadsheets!
Will you save more with standard PPO or a high-deductible PPO Saver plan with a Health Savings Account?
It is currently Open Enrollment season at many workplaces, which is when employees choose their medical insurance and other benefits plans for the upcoming year. It’s also the time of year when people grumble “why is the US healthcare system so complicated” and just elect whatever plan they had in the prior year. Building a spreadsheet can help someone compare the costs and benefits of each of the plans under a variety of different assumptions about tax rate and healthcare expenditure. Continue reading “Build a Spreadsheet to help you choose a healthcare plan”
At first glance, it sounds like an obvious question – surely it is better when stocks go up, right? From watching the ads on CNBC, it would seem that higher stock prices directly translate into more steak dinners and golf vacations while lower stock prices mean bringing your own peanut butter sandwiches to work (jelly is for bull markets). Continue reading “Do you want the stock market to go up or down?”
How many cubic feet of sand can a pyramid hold? Did you know that it is exactly 1/3 of the volume of a rectangular prism with the same height, base, and width as the pyramid? Let’s use spreadsheets to confirm this and calculate the volume of other geometric solids.
With a Grand Slam approaching, let’s talk tennis! If we were to predict a tennis pro’s weight based on his height, where would we begin? How will our understanding of the best-fit line and spreadsheets help us make this prediction?
We’ve collected the heights and weights of tennis pros including Federer, Djokovic, Nadal, Murray, Azarenka, Sharapova, and Williams, along with another 192 top players. Let’s investigate how to 1) calculate the correlation of weights and heights, and 2) draw a best fit-line and scatter plot in Google spreadsheets to extrapolate or make predictions!
If you have data such as velocity and time traveled, would you be able to calculate the total distance journeyed? Let’s discover how to tackle this question with spreadsheets! We’ll first begin by calculating distance traveled when velocity is constant. Then we’ll approach a more realistic situation of varying velocity using the Mid Rectangular Approximation Method (MRAM)!Continue reading “Calculate Distance Traveled with Spreadsheets”
No robot or machinery is consistently perfect. Glitches might occur with overuse, or the environment is unsuitable. While achieving a perfectly functioning robot is a noteworthy goal, it may not be realistic. So, what level of error or tolerance level would you be willing to accept? Let’s discover how to use spreadsheets as a tool for understanding and calculating measurement error. Continue reading “How Accurate is your Robot? Measurement Error & Spreadsheets”
What is the probability of rolling any pair of numbers with two dice? Let’s first solve this and then confirm our calculated probability by simulating 500 dice rolls with a spreadsheet! In this post, we will focus on understanding basic probability concepts and then discover how with spreadsheets, we can actually see whether our calculated probability holds true!