Question

Set up a spreadsheet to reproduce Figure 4-15. Add error bars: Follow the procedure on pages $\mathbf{87}\mathbf{-}\mathbf{88}$. Uses_yfor the + and - error.

Short answer

A spreadsheet similar to Figure $4-15$is set up in step 2.

A graph plotted on the spreadsheet by the use of x and y values is shown in step 3.

Step-by-step solution

Error bar to agraph

Error bars on the graphs helps to judge the quality of data and the fit of a curve to the data.

Generation of Spreadsheet

Given data:

Use the data from Figure 4-15

Use the procedure from pages $87-88$to add error bars.

Use ${\mathrm{s}}_{\mathrm{y}}$for the + and - error

A spreadsheet similar to Figure $4-15$ is as shown below.

The above spreadsheet gives the slope, the intercept and its uncertainties, and also the standard uncertainty and standard deviation of$\mathrm{y}\left({\mathrm{s}}_{\mathrm{y}}\right)$

Plot the graph

Now, let us plot a graph on the spreadsheet by the use of the x and y values.

The error bars on the points of the graph are drawn with the help of the procedure given in pages $87-88$.

The obtained graph with the addition of error bars is shown in Figure 2.