xy scatterplots
chip smith
percentages as my y axis and a logrithmic scale for the x
axis. but i need to find points on the graph. for example,
i need to find out what the x value is at 30%. my prof
told there is a way for excel to do it, but i need
help...any suggestions? thanx
GB
"chip smith" <anon...@discussions.microsoft.com> wrote in message
news:07ef01c3a4e4$c7829b30$a101...@phx.gbl...
I guess that what your prof wants you to do is to draw a trendline / line of
best fit through the data and then use that line to estimate the x-value at
30%. Excel can do the trendline for you. It can give you the line's
equation, or you can measure the values off the chart. Look up trendlines in
the help, but here's a snippet to get you started:
Trendlines in charts
Trendlines are used to analyze problems of prediction. Such analysis is also
called regression analysis. By using regression analysis, you can extend a
trendline in a chart forward or backward beyond the actual data to show a
trend. You can also create a moving average, which smooths out fluctuations
in data and shows the pattern or trend more clearly.
You can add trendlines to data series in unstacked 2-D area, bar, column,
line, stock, xy (scatter), and bubble charts. You cannot add trendlines to
data series in 3-D, stacked, radar, pie, or doughnut charts. If you change a
chart or data series so that it can no longer support the associated
trendline ž for example, by changing the chart type to a 3-D chart ž you
lose the trendlines.
To create a trend on your worksheet, use AutoFill or one of the statistical
functions such as GROWTH() or TREND(). For more information, click .