Graph this! (Practice) – Add a trendline

When using Excel to generate this graph, be sure to pay attention to the following points:

When adding the trendline, right-mouse click over a data point. From the context menu, select: Linear as the Trend/Regression Type Set intercept 0,0 Display line on chart Display R-squared value on chart

For this graph, the slope . . . → Read More: Graph this! (Practice) – Add a trendline

How to insert a graph in Excel

When you prepare your computer-generated graph for next week, do NOT use the Physics software “Graph it”. “Graph it” is a macro for Excel. You should learn to generate the graph from inputting the data in Excel.

Start by inputting the data points into Excel, select the points and click Insert > Scatter (see . . . → Read More: How to insert a graph in Excel

Graph this! (Practice) – Due next week

Many important relationships can be expressed by graphing. For the analysis of materials, a standard curve is used to determine the concentration of a substance (i.e. – the unknown sample).

The analyst first prepares samples of the substance in various known concentrations (i.e. – the standards). The method of preparation should be similar to . . . → Read More: Graph this! (Practice) – Due next week

Introduction, Review, Graphing

Introduction:

Welcome, class! Course outline Calendar Laboratory Lab orientation Grading Scheme

Review:

Significant figures Rules for determining significant figures Rules for rounding numbers Calculations involving significant figures Rules for addition and subtraction Rules for multiplication and division Rules for . . . → Read More: Introduction, Review, Graphing