Hello, maybe you can help me. And quickly.
I have a rather busy chart that shows the forecast by weight of 10 items we bring in to our warehouse over the past 4 years. 10 different colours and symbols all with ups and downs weekly over 4 years. It's rather busy. I'm looking to cut through the noise and add some trendlines. I'm having trouble. Below is what my manager has said.
"It immediately shows variability, but of course fcsts by nature are somewhat bumpy. “Ignoring” the extreme noise should facilitate discussion. I’m pondering a best-fit line to draw focus on “norm” and trend over time. Could be around 30,000kg? Also I gather that the band 25,000 – 35,000 captures what, 80% of the readings? "
and
"I’m thinking of adding a trend line & two lines range lines that highlight where the bulk of the readings fall."
So far I have a polynomial of order 6 trendline and I'm relatively pleased with it. However, I can't figure out how to do the range lines that show where 80% of the bulk lies.
Any help out there?
I have a rather busy chart that shows the forecast by weight of 10 items we bring in to our warehouse over the past 4 years. 10 different colours and symbols all with ups and downs weekly over 4 years. It's rather busy. I'm looking to cut through the noise and add some trendlines. I'm having trouble. Below is what my manager has said.
"It immediately shows variability, but of course fcsts by nature are somewhat bumpy. “Ignoring” the extreme noise should facilitate discussion. I’m pondering a best-fit line to draw focus on “norm” and trend over time. Could be around 30,000kg? Also I gather that the band 25,000 – 35,000 captures what, 80% of the readings? "
and
"I’m thinking of adding a trend line & two lines range lines that highlight where the bulk of the readings fall."
So far I have a polynomial of order 6 trendline and I'm relatively pleased with it. However, I can't figure out how to do the range lines that show where 80% of the bulk lies.
Any help out there?
