Excel can calculate gradients?

Watch
LearningMath
Badges: 14
Rep:
?
#1
Report Thread starter 12 years ago
#1
Basically i need the line of best fit to be really accurate, can excel add it in for me + calculate gradient?
0
reply
Nonsmoking
Badges: 12
Rep:
?
#2
Report 12 years ago
#2
Yes, excel can calculate a best fit line and include its equation, from which you can get the gradient.
0
reply
LearningMath
Badges: 14
Rep:
?
#3
Report Thread starter 12 years ago
#3
How? :p:
0
reply
QuantumTheory
Badges: 12
Rep:
?
#4
Report 12 years ago
#4
Right click on the point, 'Add Trend Line' then 'Display Eqn On Graph'
The gradient is the bit before the X value =)
0
reply
LearningMath
Badges: 14
Rep:
?
#5
Report Thread starter 12 years ago
#5
Sorry, how do i add the line first?
0
reply
QuantumTheory
Badges: 12
Rep:
?
#6
Report 12 years ago
#6
I just said.. Right click on any point, then 'Add Trend Line'
0
reply
LearningMath
Badges: 14
Rep:
?
#7
Report Thread starter 12 years ago
#7
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
majikthise
Badges: 0
Rep:
?
#8
Report 12 years ago
#8
Select the option to display equation (or whatever it's called), and there's the information you need.
0
reply
Mithent
Badges: 0
Rep:
?
#9
Report 12 years ago
#9
(Original post by majikthise)
Select the option to display equation (or whatever it's called), and there's the information you need.
Yep. If it's a straight line, it will be in the format of:
y=mx+c

m is the gradient (change in y for each 1 change in x), and c is the intercept.
0
reply
cowsgoquack
Badges: 16
Rep:
?
#10
Report 12 years ago
#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?
how can a line be crude? its a line!
0
reply
Trevor 12345
Badges: 0
Rep:
?
#11
Report 12 years ago
#11
(Original post by LearningMath)
it only extends as far as the data...
well there is a very good reason for that.....
0
reply
'bob'
Badges: 9
Rep:
?
#12
Report 9 years ago
#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
Sammydemon
Badges: 17
Rep:
?
#13
Report 9 years ago
#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
You could perform a linear regression analysis on your data for a more accurate interpretation and gradient.

You might need to activate the add-in Analysis TookPak, you can do this in "Excel Options".
0
reply
Adilllll
Badges: 0
Rep:
?
#14
Report 4 years ago
#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
natninja
Badges: 21
Rep:
?
#15
Report 4 years ago
#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?
You can use the functions SLOPE and INTERCEPT
0
reply
X

Quick Reply

Attached files
Write a reply...
Reply
new posts
Back
to top
Latest
My Feed

See more of what you like on
The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

Personalise

Do you have the space and resources you need to succeed in home learning?

Yes I have everything I need (85)
64.89%
I don't have everything I need (46)
35.11%

Watched Threads

View All