Have some data of the following form:
X | Y ----+----- 3 | 42 4 | 57 6 | 92 11 | 119 19 | 316
(NOTE: The above table is made-up data)
What I'd like to do with MS-Excel is to plot 2 curves, one that treats values in col. 'X' as horizontal axis data, assuming it to be a linear scale, and another assuming it to be a logarithmic scale. Is this possible ? If so, how ?
Also, if I wish to extrapolate the value of Y, (using, what I hope would be a choice of multiple "models"), for a given value of X, s.a. X = 5 or X = 9, how can I do it ?
I'd believe this to be the typical curve-fitting problem, with the statistical extrapolation, but don't know enough of MS-Excel to get around.