Author: Spreadsheet Solving

Predicting a Tennis Pro’s Weight based on Height

TechsmithWorEE2E.pngWith 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”

Spreadsheet Operators Tutorial

There are many ways to skin a cat, so the saying goes. In spreadsheets, there are multiple ways to achieve the same result when performing an operation – such as addition, division, equal to, etc. See below to view our 3-minute video tutorial and reference chart. Continue reading “Spreadsheet Operators Tutorial”

How to Analyze Stocks in Spreadsheets

In a few steps, you can create a basic stock analyzer spreadsheet. Our post and 5-minute video tutorial will guide you to building a spreadsheet template that charts prices, calculates return and volatility metrics, and identifies lowest and highest daily returns! (Basic template also accessible below).

[youtube=http://youtu.be/hMawNIfdFRo]

Continue reading “How to Analyze Stocks in Spreadsheets”

Splitting Group Costs with Spreadsheets

Laguna Beach, CA. Photo: Amie Chuang
Laguna Beach, CA. Photo: Amie

After a beach outing, ski trip, or joint roommate purchase, we just might need to split shared expenses among a group. A spreadsheet can serve as an efficient and practical tool to do just that! See this framework live in action in our 6-minute video below.

Continue reading “Splitting Group Costs with Spreadsheets”

Calculate Distance Traveled with Spreadsheets

mini
Photo: Katie Ko

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”

Take the ‘Order of Operations’ Spreadsheet Quiz!

TechsmithWor63E8.pngKnow the rules of the order of operations? A central concept in pre-algebra/algebra, these rules clarify which actions in any algebraic expression should be performed first. Let’s review what the rules are and why they are important. Then, you can test your knowledge with a spreadsheet quiz!   Continue reading “Take the ‘Order of Operations’ Spreadsheet Quiz!”

My Life in a Tree Map

Tree
Grand Teton, WY. Photo: Amie

How does my life compare to the average American’s? What does my ideal day look like? With data from the Bureau of Labor Statistics (BLS), Google spreadsheets, and problem-solving skills, let’s conduct some analysis with Tree Maps.

Continue reading “My Life in a Tree Map”

How Accurate is your Robot? Measurement Error & 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”

How to Track & Analyze Spending

Where does your money go? This is an important question, because it gets to the heart of basic money management and personal finance. Let’s discover and create a spreadsheet application that tracks and analyzes your spending!  Continue reading “How to Track & Analyze Spending”

Probabilities & Dice Roll Simulations in Spreadsheets

Dice
Photo: Amie Chuang

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!

Continue reading “Probabilities & Dice Roll Simulations in Spreadsheets”