Chapter 4.7, Problem 7TY

Interpretation Introduction

Interpretation:

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

Concept Introduction:

Slope and Intercept through method of least squares:

The slope (m) and intercept (b) of the “best” straight line are found from the following least-square equations:

$\begin{array}{l}\text{slope (}m)=\frac{n{\displaystyle \sum (x_i{y}_i)-{\displaystyle \sum x_i}{\displaystyle \sum y_i}}}{n{{\displaystyle \sum (x_i}}^2)-({\displaystyle \sum x_i{)}^2}}\\ \text{intercept (}b)=\frac{{\displaystyle \sum (x_i{}^2){\displaystyle \sum y_i}-{\displaystyle \sum (x_i{y}_i)}{\displaystyle \sum x_i}}}{n{\displaystyle \sum (x_i{}^2})-({\displaystyle \sum x_i{)}^2}}\end{array}$

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