Have you heard of Bayes’ Rule? Let’s use an intuitive example to understand an application of this rule. What’s the probability American Hustle wins the Golden Globes given it wins the Oscars? Continue reading “Bayes’ Rule, Oscars, & Golden Globes”
Author: Spreadsheet Solving
Conditional Probabilities & the Academy Awards
What’s the probability American Hustle wins the 2014 Oscars? Let’s talk Academy Awards, spreadsheets, and conditional probabilities! Continue reading “Conditional Probabilities & the Academy Awards”
Top 3 Spreadsheets You Need (but Never Knew!)
Look no further! Whether you are a traveler, student, teacher, parent, or coach, here are our top 3 spreadsheets that can benefit you. Select any choice below to access both our spreadsheet and video tutorial.
Continue reading “Top 3 Spreadsheets You Need (but Never Knew!)”
Improve Agreement Accuracy with Kappa
Have you heard of kappa, a measure of inter-rater agreement? In this post, we’ll delve into this statistic and see how spreadsheets can help us calculate and understand it. Continue reading “Improve Agreement Accuracy with Kappa”
Date & Time Functions in Spreadsheets
Spreadsheets can generate date and time data, which are useful when tracking tasks, resolutions, or priorities; managing deadlines; and organizing calendar-based events. We’ll introduce a few of these functions and their applications in our post and video below!
What’s the Volume of a Pyramid?
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.
The Ultimate Wedding Planning Spreadsheet
Planning a wedding or a large party? A spreadsheet can be your guide as you navigate through this exciting, busy time! Whether it is keeping your guest list organized, creating a vendor comparison list, or developing a budget, you can rise above wedding planning stress with this reliable, easily accessible tool! Continue reading “The Ultimate Wedding Planning Spreadsheet”
Play Time! Build a Lottery with Spreadsheets
Play time! How do I create my own lottery or random prize drawing? Of course, you can always list entries on sheets of folded paper, drop them into a hat, and then have a friend reach in to select one. But to build one that can be used anywhere at any time and designed any way you’d like – check out our spreadsheet template “Lottery / Random Prize Drawing.”
Continue reading “Play Time! Build a Lottery with Spreadsheets”
College App Tracker Spreadsheet
As you navigate through the college application process, this spreadsheet framework can benefit you! Stay organized, track requirements, and manage deadlines with this spreadsheet template. To get started, view our 5-minute video and download our template. Continue reading “College App Tracker Spreadsheet”
Create a Currency Exchange Rate Calculator
Discover how to create a currency exchange rate calculator – a practical & versatile spreadsheet app. From a list of 61 currencies, this tool can generate a total of over 3,600 exchange rate combinations! Discover how to build it with basic functions: GoogleFinance, IF, data validation, and Vlookup.
Continue reading “Create a Currency Exchange Rate Calculator”
Create & Automate Large Order Forms
As a student leader of your club or sports team, you’ll benefit from an order form template! If you’re in charge of collecting info such as t-shirt orders or cookie sales, this spreadsheet template will make your life easier by tracking user-entered data and automating key data.
Predicting a Tennis Pro’s Weight based on Height
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!
Continue reading “Predicting a Tennis Pro’s Weight based on Height”