Using these two values, we can write the trendline equation for this dataset: The first value in the output represents the slope of the trendline and the second value represents the intercept of the trendline. The following screenshot shows how to use this formula in practice: We can type the following formula into cell D2 to find the trendline equation: =LINEST( B2:B14, A2:A14) Now suppose that we would like to find a trendline equation that summarizes the relationship between these two variables. Suppose we have the following dataset in Excel: Example: How to Find Trendline Equation Without Chart in Excel The following example shows how to use the LINEST function in practice in Excel to find a trendline equation for two variables. This function produces a value for both the intercept and slope of the trendline.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |