Regression analysis on charts

Hi Sally

Thanks for getting in touch. There are some options in the Analysis Toolkpak to create regression lines but often it's overkill. It's often simplest to create additional columns for the +/- 1/2 standard deviations, and plot those on to the chart.

It's probably easier to give specific help if I could see the workbook you're using. Could you send a copy to gary@stl-training.co.uk please?

In the meantime there's a useful summary of the statistical functions for calculating regression on the Microsoft site:

http://office.microsoft.com/en-gb/excel-help/perform-a-regression-analysis-HA001111963.aspx

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector