MS Excel question: How can I produce the slope (y=___x=___) from a line graph?

Question

i meant (y=mx+b)

yes, how do i do that? is that the one that produces y=mx+b from a line graph?

Answer 1

Here are the steps to get an equation for a line in Excel (best fit if points do not constitute a true line):

1.) highlight the line on the chart that you want the equation for by left-clicking on the line
2.) once the line is highlighted, right-click the line and select Add Trendline
3.) in the Type tab,select Linear as the type of trend/regression line
4.) click on the Options tab and check the display equation on chart option
5.) Close out the window by clicking the OK at the bottom

An equation for the line should now be displayed on the chart

Answer 2

in the equation y=mx + b whatever value is m is the slope. so if the formual was y=2x - 7 the slope would be 2

If you are asking how to determine the slope the formula for that is y2-y1/x2-x1 for example (4,8) and (6,20) m= 20-8/6-4 or 12/2 or 6

goodluck

Answer 3

you do no longer say what version of Excel you have, yet assuming that's pre 2007:the thank you to do it so as that the graph immediately updates itself is on your spreadsheet to rather style contained sooner or later dates then go decrease back on your chart, precise button of mouse right down to source records, click on the little pink/black container to the realm of the advice variety container then drag your mouse over the advice to be blanketed contained in the chart so as that it covers the destiny dates. Then, as you enter your weight loss alongside the dates your chart would be as much as date. no count if that's 2007, that's incredibly the comparable, precise button of mouse on the chart, right down to elect source records.

Answer 4

I doubt that Excel has this function unless you're referring to linear regression?