Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Using Excel to figure out a trend?
I'm trying to figure out two things in Excel (Office Mac 2011, but Windows version is fine.)
I have a set of 20 numbers. I need to know the difference of percentage between them in Excel and then the average %.
I then need to find out the trend, after the first 20, to the 1000, if X percent was lost between the first 20 and that trend continued, what would the numbers from 21 to 1000 be. Thanks!
1 Answer
- puakaLv 510 years agoFavorite Answer
Create a chart, either line or column chart is fine. Select the line or column graph, right click (or Mac equivalent of right click), add trend, select linear or growth, and add the forward projection data points you need, in this case the rest of the 979 points.