# How To Compute The Best Fit Straight Line To A Set Of Data?

50 %
50 %
Information about How To Compute The Best Fit Straight Line To A Set Of Data?

Published on February 4, 2009

Author: siddharth4mba

Source: slideshare.net

## Description

How To Compute The Best Fit Straight Line To A Set Of Data?

How-To Compute the Best-Fit Straight Line to a Set of Data Page 1 How-To Compute the Best Fit Straight Line to a Set of Data Objective: Learn how to compute and use regression equations to a set of data. Keywords and Concepts 1. Best fit straight line 6. Dependent variable 2. Bivariate scatter plot 7. Slope (rate of change) of the best-fit line 3. Regression equation 8. Y-intercept 4. Y’ = mX + C 9. Correlation coefficient (r) 5. Independent variable A bivariate scatter plot (two-variable relationship) reveals the association between an individual’s score on one variable can be used to predict the corresponding score on a related variable (see Fig. 1). This prediction depends on the equation for a straight line that minimizes the variation of data points about it. The equation used to draw the best-fit straight line is called a regression equation and was first used by Sir Francis Galton (1822-1911) to show that when tall or short couples have children their heights tend to “regress”, or revert to the mean height of their parents. Figure 1. scatter plot of Fahrenheit versus Celsius temperature FAHRENHEIT VERSUS CELSIUS SCATTER PLOTÊ 112 Value used to 102 construct line 92 82 72 Regression Line 62 Value used to y = 1.80x + 32 construct line 52 Farhrenheit, degree 42 32 0 10 20 30 40 Celsius, degreeÊ

How-To Compute the Best-Fit Straight Line to a Set of Data Page 2 Regression Equation Given a collection of paired sample data, the following formula (regression equation) describes the relationship between X (independent or predictor variable) and Y’ (dependent or response variable): Y’ = mX + C (eq. 1) where, m expresses the slope (rate of change) of the best-fit line, X is any particular X value within the range of the data set, and C represents the Y-intercept or the value of X when Y equals zero. Use equation 2 to compute m as follows: Σ∆Ψ m=ρ (eq. 2) Σ∆ Ξ The symbol r equals the correlation coefficient between X and Y; SDY and SDX are their respective X and Y variable standard deviations. The Y-intercept C computes in equation 3 as: C = Ψ− µ Ξ (eq. 3) where, Y equals the mean of the Y scores, m equals the slope, and X equals the mean of the X scores. Equation 3 can be rewritten as follows: Σ∆Ψ C = Ψ − ρ( )Ξ (eq. 4) Σ∆Ξ Combining equations 2 and 3 expresses the equation for the best-fit regression line to predict Y (Y’) from any X value in equation 5: SDY Y ′ = r( (eq. 5) )X + Y - mX SDX Alternatively, combining equations 2 and 4 expresses the equation for a straight line as:

How-To Compute the Best-Fit Straight Line to a Set of Data Page 3 SDY SD Y ′ = r( )X + Y - (r Y )X (eq. 6) SDX SDX The slope and Y-intercept of the best-fit regression line also can be computed from raw scores with the following formula (equation 7): (∑ ) − ( ∑ )( ∑ ) ΞΨ Ξ Ψ Ν Ν Ν Slope,m = (eq. 7) (∑ ) − ( ∑ ) Ξ2 Ξ2 Ν Ν where, the equation’s numerator equals the numerator for the correlation coefficient (r) and the denominator equals SDX. The raw score equation (eq. 8) computes the Y-intercept (C) as: (eq. 8) The denominator in equation 8 equals the square of SDX. Example Given the following 5 data points for temperature in degrees Fahrenheit (Y- variable) and temperature in degrees Celsius (X-variable), compute the equation for the best-fitting straight line. Y 32 40 60 80 100 Fahrenheit Temperature X 0 4.44 15.55 26.6 37.77 Celsius Temperature Step 1. Compute r, SDx, and SDy. ∑Y=312; ∑Y2=22624; ∑X=84.36; ∑X2=2395.65; ∑XY=7015.6; N=5 r = 0.999 Y = 62.4; SDY = 25.12 X = 16.87; SDX = 13.95

How-To Compute the Best-Fit Straight Line to a Set of Data Page 4 Step 2. Compute the slope (m) and Y-intercept (C) using equations 2 and 4, respectively. Σ∆Ψ m=ρ (eq. 2) Σ∆ Ξ m = 0.9999 (25.12 ÷ 13.95) m = 1.80 Σ∆Ψ C = Ψ − ρ( )Ξ (eq. 4) Σ∆Ξ 25.2 C = 62.4(0.999 )16.87 13.95 Χ = 32.0 Step 3. The equation for the regression of degrees Celsius on degrees Fahrenheit becomes: Y’ = mX + C Y’ = 1.8 X + 32.0 Step 4. Determine the best-fit straight line of the regression, and plot the individual data points as a scatter diagram. (See figure 1) Arbitrarily select a value of X near the maximum observed values of X, and substitute the score in the equation to solve for Y’ (predicted Y). Plot this point (X, Y’) on the scattergram. Repeat the procedure for another value of X near the minimum observed value of X. The straight line joining the two points represents the best-fitting straight line generated from the regression equation. 32 0 40 4.44 60 15.55 80 26.6

 User name: Comment:

## Related presentations

#### Cheapest canvas prints shopcanvasprintcom

April 2, 2014

Canvas Prints at Affordable Prices make you smile.Visit http://www.shopcanvasprint...

#### Paseo en bici por la historia del comercio gijones

April 1, 2014

30 Días en Bici en Gijón organiza un recorrido por los comercios históricos de la ...

#### Meta anlysis of 5 spanish ropo studies minerva ove...

April 1, 2014

Con el fin de conocer mejor el rol que juega internet en el proceso de compra en E...

#### Informa Whitepaper - The Rise of Australia's LNG I...

April 1, 2014

With three established projects across the country and seven more in the pipeline,...

#### Decoding Retail StartUp : Comprehensive Roll-Out S...

April 1, 2014

Retailing is not a rocket science, neither it's walk-in-the-park. In this presenta...

#### What is research??

April 2, 2014

Explanatory definitions of research in depth...

## Related pages

### Constructing a best fit line - SERC

... draw a best fit line or trend in the data ... a straight line through data points? Best-fit ... a best-fit line for a set of data but ...

### Best Fit Lines - Honolulu Community College

To do this you must draw what is known as a "best fit" straight line, ... line will suffice. Many computer ... best fit line is to enter the data ...

### Comparing two ways to fit a line to data - John D. Cook

Comparing two ways to fit a line to data. ... best line of the form y = mx + b, best in the sense ... ways to a fit a straight line to a set of data ...

### Line of Best Fit (Least Square Method) - Math Homework ...

Line of Best Fit (Least Square Method) A line of best fit is a straight line that is the best approximation of the given set of data.

### Least Squares Fitting -- from Wolfram MathWorld

Least Squares Fitting. ... a solution to the problem of finding the best fitting straight line through a set of ... to find the best fit line.

### Straight line plot in excel.mp4 - YouTube

Creating a simple straight line plot and adding a line of best fit from data in Microsoft Excel.

### Statistics 1 - Line of Best Fit - Math Bits Secondary Math ...

A line of best fit (or "trend" line) is a straight line that best represents the data on a scatter plot. ... Prepare a scatter plot of the data. Set up for ...