![]() ![]() You can verify this by using the equation. The trendline predicts 120 sold Wonka bars in period 13.The Trendline Analysis package is a built-in analysis tool in Excel. And the R 2 value of 0.9855 indicates a pretty good fit of the estimated trendline values to the actual data For example, the following linear trendline shows a steady increase in sales over 6 months. ![]() Typically, a linear trendline describes a continuous rise or fall over time.You cannot create a power trendline if your data contains zero or negative values For example, the acceleration of a race car at 1-second intervals. Showing a curved line, this trendline is useful for data sets that compare measurements that increase at a specific rate.Home Which is an example of a trendline option in Excel Trendline options in Office - Office Suppor ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |