- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Excel help
Posted on 9/15/15 at 11:23 am to Sigma
Posted on 9/15/15 at 11:23 am to Sigma
Interesting association.
I'm sure you're aware of R-squared, residual plots, etc - check those.
If you're trying to make a prediction, I'd steer away from using high degree polynomials. I don't know if this is something that is common in your line of work but high degree polynomials are pretty misleading.
I'm sure you're aware of R-squared, residual plots, etc - check those.
If you're trying to make a prediction, I'd steer away from using high degree polynomials. I don't know if this is something that is common in your line of work but high degree polynomials are pretty misleading.
Posted on 9/15/15 at 12:50 pm to NoFlexZone
quote:
I get 68,167 using an exponential function. Just using the "Add trend line" in XLS. The equation is 5E+10e^-2.154x R Sq = 0.9991
This was part of my problem. Several other types of regressions would work, just the calculation using the 4th order fit was crazy.
quote:
If you're trying to make a prediction, I'd steer away from using high degree polynomials. I don't know if this is something that is common in your line of work but high degree polynomials are pretty misleading.
My knowledge of statistics is admittedly poor, but the plotted data are very smooth. I can read off the Y value using the given X value and be within 5%. I was just looking to understand the math I suppose. Thanks for your help.
Popular
Back to top
Follow TigerDroppings for LSU Football News