Analyzing Data and Graphing Techniques

The video tutorial demonstrates how to use Google Docs and Excel to analyze data from a potato osmosis lab. It covers calculating percent change, formatting data, identifying errors, and creating a scatter plot with a trendline to determine the isotonic solution of sucrose for potatoes. The tutorial concludes with a summary of findings and contact information for further questions.

What tool is being used to create graphs for the potato osmosis lab?

• Adobe Photoshop

• Google Docs

• Notepad

• Microsoft Word

What is the formula for calculating percent change in Excel?

• Final minus initial divided by initial

• Final plus initial divided by two

• Initial minus final divided by final

• Initial plus final divided by two

What does a positive percent change in potato mass indicate?

• Potatoes are in an isotonic solution

• Potatoes are in a hypertonic solution

• Potatoes are in a neutral solution

• Potatoes are in a hypotonic solution

What might a negative percent change in potato mass suggest?

• Potatoes changed color

• Potatoes lost mass

• Potatoes gained mass

• Potatoes remained the same

What should you do if you encounter an unexpected data point in your results?

• Change it to fit expectations

• Assume it's correct

• Ignore it

• Investigate for potential errors

What is the purpose of recreating columns and calculating averages in the lab?

• To change the experiment results

• To make the data look better

• To prepare data for graphing

• To confuse the students

What type of chart is used to determine the isotonic solution for potatoes?

• Line chart

• Bar chart

• Pie chart

• Scatter plot with trend line

What is the significance of a trend line in the scatter plot?

• It changes the data values

• It helps identify the isotonic solution

• It shows the average data

• It decorates the graph

What is the isotonic sucrose concentration for potatoes as determined in the lab?

• 0.35 molar

• 0.45 molar

• 0.15 molar

• 0.25 molar

Why is it important to label the axes in a graph?

• To provide context for the data

• To make the graph larger

• To confuse the viewer

• To make the graph colorful