Graphing and Data Analysis Techniques

Ryan Rice from Washington State University guides viewers through creating and analyzing graphs in Excel for an enthalpy of formation experiment. The tutorial covers data entry, graph creation, formatting, adding trendlines, extrapolating data, and calculating temperature changes. The video is designed for users with the 2016 version of Excel, but the principles apply to other versions as well.

What is the first step in preparing for the enthalpy of formation experiment using Excel?

• Creating a scatterplot

• Entering data into an Excel spreadsheet

• Adding trendlines

• Calculating temperature changes

Which type of chart is used to visualize the pre-reaction and post-reaction data?

• Pie chart

• Scatterplot

• Line chart

• Bar chart

How can you adjust the y-axis to better display the data on the graph?

• Remove the x-axis

• Add more data points

• Set the axis bounds

• Change the chart type

What should you do to add a title to the y-axis?

• Use the insert symbol option

• Click on the x-axis

• Click on axis titles and enter the title

• Change the chart type

What is the purpose of adding trendlines to the graph?

• To adjust the axis bounds

• To remove data points

• To visualize the data trend

• To change the chart type

How can you make a trendline more visible on the graph?

• Add more data points

• Remove the x-axis

• Change its color and thickness

• Change the chart type

What is the purpose of extending trendlines in the graph?

• To change the chart type

• To adjust the axis bounds

• To remove data points

• To visualize data beyond the collected points

Why might you exclude certain data points from the graph?

• They are too high

• They were collected before temperature stabilization

• They are duplicates

• They are too low

How do you calculate the temperature change at the time of mixing?

• By dividing the post-reaction temperature by the pre-reaction temperature

• By subtracting the pre-reaction temperature from the post-reaction temperature

• By adding the pre and post-reaction temperatures

• By multiplying the pre and post-reaction temperatures

What is the final step before performing enthalpy calculations?

• Calculating temperature changes

• Adding trendlines

• Creating a scatterplot

• Entering data into Excel