Does anyone know how to choose the correct trendline for a data set? I have plotted a data set in Excel 2007(located at the following link) http://www.mediafire.com/?sha<WBR>rekey=a6c026861bdd9f9ad2db6fb9a8902bda, but I don't know how to choose the correct trendline from the options Excel provides (see attached file).
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Excel 2007 trendline
- Thread starter damo12
- Start date
tusharm
MrExcel MVP
- Joined
- May 28, 2002
- Messages
- 11,029
You have to know what kind of trendline makes sense for your data. Don't know if the below will help.
Trendline Coefficients and Regression Analysis
http://www.tushar-mehta.com/publish_train/data_analysis/16.htm
Trendline Coefficients and Regression Analysis
http://www.tushar-mehta.com/publish_train/data_analysis/16.htm
Upvote
0
FrigateSkimmer
New Member
- Joined
- Apr 20, 2009
- Messages
- 3
damo12,
"I don't know how to choose the correct trendline ..."
People go to college to acquire the fundamentals, and then spend years working with mentors in the field to refine. It isn't found in a single statistics book or in a software reference manual. It's obtained through a career.
Are there mentors in your workplace?
FS
"I don't know how to choose the correct trendline ..."
People go to college to acquire the fundamentals, and then spend years working with mentors in the field to refine. It isn't found in a single statistics book or in a software reference manual. It's obtained through a career.
Are there mentors in your workplace?
FS
Upvote
0
Similar threads
- Question
- Solved
