Saturday 26 August 2017

microsoft excel - Eliminate the appearance of a dip when plotting increasing data with smoothing


I have a data set in which Y is an increasing function of X.  Here is the data:


5  | 0.1
10 | 0.789
15 | 147.5
20 | 216.5
25 | 276.5

I create an XY (Scatter) Chart with Smooth Lines:


     


Because the first two points are very close in Y value, and not characteristic of the distribution of the other points, the smooth line option displays a 'dip' between those two points.


How can I plot this with a smoothed line that estimates the curve on which the data lie without having it include a dip?



Answer



Are you willing to manipulate (fudge) your data to get the desired chart?  I was able to add one point:



5 0.1
9.9 0.7
10 0.789
15 147.5
20 216.5
25 276.5

and the chart changed to this:


     


No comments:

Post a Comment

Where does Skype save my contact's avatars in Linux?

I'm using Skype on Linux. Where can I find images cached by skype of my contact's avatars? Answer I wanted to get those Skype avat...