![]() Calculating the Slope and Interceptįirst, we’ll calculate the slope, k/m, of the data with the slope function: We could use the LINEST function to get both at once, or we could use the SLOPE and INTERCEPT functions to obtain the values separately.įor this exercise, SLOPE and INTERCEPT are more straightforward, so let’s use them. There are a couple of different ways we could go about getting the best-fit slope and intercept from this data. So, the term k/m is now the slope of this equation and 1/m is the intercept. ![]() ![]() Remember, we’ve linearized the hyperbolic equation into the form: (How about that? It’s almost like I planned it that way. Just as a quick check, we can plot these two new columns (E and F) on a chart and see that the relationship between them is indeed linear. When the formulas are filled down, we get the following: We need to create two new columns in our spreadsheet – one for values of 1/x and another for the values of 1/y.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |