You are Here: Home >< Maths

Statistics- Standard deviation of regression watch

1. Hi,

I've done regression analysis on a set of data in Excel. One of the questions asks me to report the standard deviation of regression. I've got quite a complicated formula for this but I was wondering how to use Excel to work this out e.g. is it a figure from the regression analysis.

Many thanks
2. (Original post by VioletPhillippo)
Hi,

I've done regression analysis on a set of data in Excel. One of the questions asks me to report the standard deviation of regression. I've got quite a complicated formula for this but I was wondering how to use Excel to work this out e.g. is it a figure from the regression analysis.

Many thanks
If you look at the help file for LINEST, you'll find a logical switch ("stats") to the command that if set will return a load of regression statistics.

TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

This forum is supported by:
Updated: February 22, 2018
Today on TSR

Are exams rubbish?

Is the exam system out of date?

University open days

• University of Exeter
Wed, 24 Oct '18
Wed, 24 Oct '18
• Northumbria University
Wed, 24 Oct '18
Poll
Useful resources

Maths Forum posting guidelines

Not sure where to post? Read the updated guidelines here

How to use LaTex

Writing equations the easy way

Study habits of A* students

Top tips from students who have already aced their exams

Chat with other maths applicants