Studyfin
✨ Sign up free
Hi there! Today we will learn how to use digital spreadsheets to find cool patterns and make smart guesses from data.
A spreadsheet is a digital tool made of rows and columns. We use it to organize numbers so we can easily spot trends and make inferences.
When we look at data over time, we can see if numbers are going up, going down, or staying the same. This path is called a trend.
Once you find a trend, you can make an inference. An inference is a smart guess based on the facts you already see.
✏️ Worked example
Imagine you run a school snack shop. You put your weekly apple sales into a spreadsheet. Week 1: 10 apples, Week 2: 20 apples, Week 3: 30 apples. Walk through how to transform this data to find the trend and make an inference.
- First, enter your numbers into two columns: 'Week' and 'Apples Sold'.
- Next, highlight your data and create a line graph using your spreadsheet tool.
- Analyze the graph. Notice that the line goes straight up from left to right.
- Identify the trend. Since the numbers are increasing each week, you have an upward trend.
- Make an inference. You can guess that Week 4 will have even higher sales, so you should order more apples!
Want the full interactive lesson — quiz, animations, and Finn cheering them on?