Excel 2007 for Scientists and Engineers

Part 4: Regression Analysis

Chapter List

Chapter 33: Linear Regression
Chapter 34: Nonlinear Regression
Chapter 35: Curve Fitting
Chapter 36: Sigmoid Curves
Chapter 37: Predictability
Chapter 38: Correlation
Chapter 39: Multiple Regression: Linear Estimates
Chapter 40: Reiterations and Matrixes
Chapter 41: Solving Equations
Chapter 42: What-If Controls
Chapter 43: Syntax of Functions
Chapter 44: Worksheet Functions
Excercises - Part 4

Regression analysis is the process of making predictions of some variable, based on the relationship between this dependent variable and an independent variable (or set of variables). It is a scientist's task to find a model or an equation to make such predictions possible.

Single linear regression assumes a linear relationship between two factors: a dependent factor (y) and an independent factor (x). By using the linear equation y=a 1x+a 0, you can derive, estimate, determine, or predict the dependent factor (y) from the independent factor (x).

Figure 4.1 explains a bit of the terminology used in connection with linear regression. Let's assume that there is a linear relationship between hemoglobin percentage and the erythrocyte count in human blood. You determine what the independent factor is and plot that variable on the x axis. The linear equation y=a 1x+a 0 uses a slope (a 1) and an intercept (a 0). Thanks to this model, you can predict, determine, or estimate y based on x.


Figure 4.1

The actual, observed values are usually clustered around the linear regression line. RSQ or R 2 is a "measure...

UNLIMITED FREE
ACCESS
TO THE WORLD'S BEST IDEAS

SUBMIT
Already a GlobalSpec user? Log in.

This is embarrasing...

An error occurred while processing the form. Please try again in a few minutes.

Customize Your GlobalSpec Experience

Category: Data Mining Software
Finish!
Privacy Policy

This is embarrasing...

An error occurred while processing the form. Please try again in a few minutes.