How do i find the equation of the line and R2? I don't have Excel 2008 handy to test, but usually one way is to right-click (or Control-click) the trendline, choose Format Trendline from the pop-up menu, click Options, click "Display equation on chart" and "Display R-squared value on chart," and click OK.
Equations in excel are none other than our formulas which we type in cell, to write an equation we start with an equals to sign (=) which excel recognizes as to calculate and then we use variables which are connected with each other with some operators, depending upon the operators we get results, an equation can be both linear or non linear.
LINEST Function in Excel includes the following parameters: known_y’s: The known y’s is n range or array of y values from the line equation. known_x’s: The known x’s is a range or array of x values from the line equation. If this x value is null excel will assume those x_values as 1,2,3..with the same number of values as y values.
I want to take the equation of a line of best fit from a graph and use it in a calculation. How do I do this? I have seen it done. Imagine I have a linear relationship, e.g. the race times of an athlete against their distances. I get an equation for this graph using Excel.
I am taking a chem lab and right now we are studying rate laws using kenetics. we had to graph the results of our experiment and then find the equation of the line. such as y=mx+b but i cant fiugre out how to do it. or if i am supposed to put a trend line in the graph, but if that is what I am supposed to do how do I find the equation of it?
Take the log of the above equation to get ln =ln(c)+b*ln(x). This is a linear equation! So, LINEST will give you ln(c) as the intercept and b as the slope. Suppose your x and y values are in columns A and B. Then, in C and D, calculate LN() of the cells in columns A and B respectively.
Then right click the line and select Add trend line. You will see a pop up with various methods of plotting a trend line. Select your desired method then click the options tab. On the tend line options check the "Show equation on graph" check box then click OK. You will get a trend line plotted on the chart along with the equation of the trend ...
The FIND function will return the location of the first instance of find_text in within_text. The location is returned as the number of characters from the start of within_text. Start_num is optional and defaults to 1. FIND will return #VALUE if find_text is not found in within_text . FIND is case-sensitive and does not support wildcards.
In scattered table,i draw linear trend line. my trendline equation is y=5.3864x+37.5. I use an formula to find angle of trend line.The formula is
Troy - if you right-click on the trendline and format trendline there is an option at the bottom to display the line's equation, in this case y = 1.3714x + 81.2 I think that means the first point is 82.5714 and the last point is 89.4284.