Chapter 4.7, Problem 8TY

Interpretation Introduction

Interpretation:

Using the spreadsheet the value of $s_y$ from LINEST has to be found out by changing the value of x from $3\text{ to 3}\text{.5}$

Concept Introduction:

Standard deviation of y: $s_y$

The standard deviation of y is:

${\sigma }_y\approx s_y=\sqrt{\frac{{\displaystyle \sum (d_i{}^2)}}{n-2}}$

Standard uncertainty of slope and intercept:

The standard uncertainty of slope is:

${\text{u}}_m^2=\frac{s_y^{2}n}{D}$

The standard uncertainty of intercept is:

${\text{u}}_b^2=\frac{s_y^2{\displaystyle \sum (x_i{}^2)}}{D}$

To Find: The value of $s_y$ from LINEST by changing the value of x from $3\text{ to 3}\text{.5}$ using spreadsheet.