Plotting a square root line of best fit

**SV232** · 03-17-2010, 10:21 AM

I have data recorded from an experiment which is of the form y proportional to the square root of x. I would like to plot a line of best fit to this information but am unsure of how to do this as the power option will not let me enter 0.5.

I'm using excel 2007

Thanks in advance for any help

**Marcol** · 03-17-2010, 11:44 AM

Put x in Column "A"
then in Column "B" Row 2

Code:

=SQRT(A2)

Fill Down

This if you use a scatter chart should give you what you want

EDIT:-

Added sample

EDIT 2:-

Martins formulae added to sample sheet