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!

puaka2011-07-25T12:38:46Z

Favorite 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.

00

Related Questions

Calibration curve using excel?Excel for Mac: repeating a 7 row trend?Significant figures Excel?How do you find a formula using excel?help with excel trend line?

Trending Questions

Convert the whole number to a percent: 58?11 answersThe rectangle is 84m long and 57m wide what is the length use the value 3.14 and do not round. ?7 answersFinding Derivative of a Point?4 answerswhat is 3/2 of 4?9 answersSolve the system: y=14x2+2x−6 y=−14x2−3x+6?6 answers