Back
to top
Excel can calculate gradients?
Watch
Announcements
Page 1 of 1
Go to first unread
Skip to page:
Basically i need the line of best fit to be really accurate, can excel add it in for me + calculate gradient?
0
reply
Report
#2
Yes, excel can calculate a best fit line and include its equation, from which you can get the gradient.
0
reply
Report
#4
Right click on the point, 'Add Trend Line' then 'Display Eqn On Graph'
The gradient is the bit before the X value =)
The gradient is the bit before the X value =)
0
reply
Can't see anything... Office 2003...
EDIT: 'Any point lol', ok got it now. It's a bit of a crude line though, it only extends as far as the data...
Can i make excel display the intercept?
EDIT: 'Any point lol', ok got it now. It's a bit of a crude line though, it only extends as far as the data...
Can i make excel display the intercept?
0
reply
Report
#8
Select the option to display equation (or whatever it's called), and there's the information you need.
0
reply
Report
#9
(Original post by majikthise)
Select the option to display equation (or whatever it's called), and there's the information you need.
Select the option to display equation (or whatever it's called), and there's the information you need.
y=mx+c
m is the gradient (change in y for each 1 change in x), and c is the intercept.
0
reply
Report
#10
(Original post by LearningMath)
Can't see anything... Office 2003...
EDIT: 'Any point lol', ok got it now. It's a bit of a crude line though, it only extends as far as the data...
Can i make excel display the intercept?
Can't see anything... Office 2003...
EDIT: 'Any point lol', ok got it now. It's a bit of a crude line though, it only extends as far as the data...
Can i make excel display the intercept?
0
reply
Report
#11
(Original post by LearningMath)
it only extends as far as the data...
it only extends as far as the data...
0
reply
Report
#12
Hey guys. Little help please. I've got the equation but it gives me a decimal but when i wor out the gradient myself from my raw data i get a figure of thousands
0
reply
Report
#13
(Original post by 'bob')
Hey guys. Little help please. I've got the equation but it gives me a decimal but when i wor out the gradient myself from my raw data i get a figure of thousands
Hey guys. Little help please. I've got the equation but it gives me a decimal but when i wor out the gradient myself from my raw data i get a figure of thousands
You might need to activate the add-in Analysis TookPak, you can do this in "Excel Options".
0
reply
Report
#14
Hi guys, if the line of best fit isn't a line but instead a curve, how do I work out the gradient of the tangent on the curve at a specific point (without having to differentiate etc.)? Is there a way excel can differentiate for me and I can input the x value to get the gradient at that specific point?
0
reply
Report
#15
(Original post by LearningMath)
Basically i need the line of best fit to be really accurate, can excel add it in for me + calculate gradient?
Basically i need the line of best fit to be really accurate, can excel add it in for me + calculate gradient?
0
reply
X
Page 1 of 1
Go to first unread
Skip to page:
Quick Reply
Today on TSR
-
Have your say on 2021 assessmentOfqual and DfE want students' thoughts
- Applying to uni? Chat to others here
- Starting my new job - AMA!
- Win a year of Headspace
- Private candidates support thread