Chapter 4, Problem 4.29P

Interpretation Introduction

Interpretation:

The slope, intercept, standard errors and a graph has to be given for the provided datas using excel LINEST function.

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 Give: The slope, intercept, standard errors and a graph using excel LINEST function.