98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Graphs
Graphs
Resolved · Low Priority · Version 2003
Tue 23 Sep 2008, 11:36Delegate Stanley said...
Stanley has attended:
Excel Intermediate course
Graphs
please let me know how to build up a regression curve using the graph function
Thu 25 Sep 2008, 12:12Trainer Greg said...
RE: graphs
Hello Stanley
My name is Greg Eze and I am one of the trainers from BEST.
All you need to do is have a two columns of figures, select the two columns in order to create a scatter diagram. Then from the Menu Bar, choose Chart, then Add Trendline, choose the Linear option, click on the Option tab and choose the tick box which says Display equation on chart. Choose Ok after that and it will display the straight line graph formula (y = 3.232x+452 for example). If you wish to checl whether the value before the x is value for the regression (which is a fairly complex statistical formula, then use the SLOPE function (e.g. = Slope (Y range, X range) ie = SLOPE(B1:B8,A1:A8).
I hope this helps
Greg
Thu 25 Sep 2008, 12:24Delegate Stanley said...
RE: graphs
many thanks
very helpfull
Thu 25 Sep 2008, 13:41Trainer Greg said...
RE: graphs
Thank you too.
Greg
BEST STL Training
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Use Paint Brush to Format More than one CellTo copy a format to many cells or ranges |
