# How to calculate a regression line

## Office Calculate linear regression in Excel - this is how it works

display

**Linear regression is a data plot that graphically depicts the linear relationship between an independent and a dependent variable. It is typically used to visually represent the strength of the relationship and the dispersion of the results - all for the purpose of explaining the behavior of the dependent variable. Sounds complicated, but with Microsoft Excel you can easily calculate and display linear regression.**

### How to do linear regression on a graph

Follow our step-by-step instructions or take a look at the quick start guide.

### How to perform linear regression using a formula

Follow our step-by-step instructions or take a look at the quick start guide.

### Quick guide: diagram

- Select the desired value columns in Excel and then use the tab "
**Insert**" a**Dot (XY) diagram**a. - If necessary, adjust the axes by using a
**Double click**do it and then under "**Limits**" the wished**minimum**and**maximum**specify. - Then click on the top right of the diagram
**green plus**and then check "**Trend line**". Open the menu via the**arrow**next to "Trendline" and select the option "**Linear**". Then click in the same menu on"**More options...**". - Now check the box next to "
**Show formula in diagram**" and "**Show the coefficient of determination in the diagram**". - Now move the formula and the coefficient of determination to a desired position on your regression diagram.

### Quick guide: Formula

- First mark
**two cells side by side**. - Enter the following formula above: "
**= LINEST (values_y's; values_x: constants)**" - Replace_y_values and_x_values with your value ranges.
- Enter as a constant "
**TRUE**" a. - Confirm the matrix formula with
**[Ctrl] + [Shift] + [Enter]**. - Excel gives you the values for m and b in the adjacent cells.

- In which direction do the fans turn
- How important was the 1st World War
- How long do fibromyalgia flares last
- What is 20 2 30 2
- How has your life been almost ruined
- Who should take AP World History
- How do you develop a great leader
- Are you a dentist or a dental student
- How do deal aggregators make money
- Why should i use Evernote
- How open-minded are scientists today
- How old is hairspray
- Another world war is inevitable
- Will give PSU study leave
- When to use frustrated and frustrating
- Is it good to follow modes blindly
- How good are Gotti Pitbulls about kids
- What are the properties of tunnel diodes
- Where's Mark Pilgrim?
- What causes an intestinal infection
- What if you stub your toe
- What is half of dfrac 3 3
- How do I operate a piston pump
- Christians and Muslims get along