lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,805
Office Version
  1. 2016
Platform
  1. Windows
Hi
I want to know based on what excel draw the trendline? Does excel take the average of values and draw the Trendlne?
I have a chart look like "V" letter but upside down. When I right click --> trendline, excel will draw a line in the middle. It seems to me excel took the average values and draw the trendline. Thank you.
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
@lezawang.... No, it is not as simple as taking averages. For a linear trendline, Excel calculates estimated y (points on the trendline) by a method ironically called simple linear regression. See the wiki page "simple linear regression" for details. You might also look at the help page for the FORECAST function. But there are some critical typos there. For example, it says that "x and y are the sample means AVERAGE(known_x's) and AVERAGE(known y's)". It should say x-bar and y-bar; that is, x with a line over it and y with a line over it.
 
Upvote 0

Forum statistics

Threads
1,216,077
Messages
6,128,673
Members
449,463
Latest member
Jojomen56

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top