This discussion is closed.
BABYGUY
Badges: 0
Rep:
?
#1
Report Thread starter 17 years ago
#1
Help! I have a set of data, and i want to draw a graph to represent it. However, i cant find a graph on excel to draw a line of best fit for the data. there are many graphs, which connecte the points etc...but how do i get a line of best fit? please help!
0
ryan_h
Badges: 0
#2
Report 17 years ago
#2
when i studied as level ict i was told it was impossible to draw a line of best fit on excel.
sorry !!!!
0
BABYGUY
Badges: 0
Rep:
?
#3
Report Thread starter 17 years ago
#3
noooooooooo!!!!!!!!!!!!!!!!!!!!! ! damn!!!!!!!!!
0
Perplexed
Badges: 8
Rep:
?
#4
Report 17 years ago
#4
(Original post by ryan_h)
when i studied as level ict i was told it was impossible to draw a line of best fit on excel.
sorry !!!!
Not quite, draw a scatter graph (with no lines connecting the points).

Right-click on one of the points on your graph, and they should all become highlighted.

One of the options you get is 'Add Trendline'. Select it... it's pretty straight forward after that.

Badda bing, badda boom.
0
LH
Badges: 15
Rep:
?
#5
Report 17 years ago
#5
(Original post by Alec)
Not quite.

Right-click on one of the points on your graph, and they should all become highlighted.

One of the options you get is 'Add Trendline'. Select it... it's pretty straight forward after that.

Badda bing, badda boom.
Badda boom, badda bing.
0
Perplexed
Badges: 8
Rep:
?
#6
Report 17 years ago
#6
(Original post by Lord Huntroyde)
Badda boom, badda bing.
You say potato, and I say patato.
0
BABYGUY
Badges: 0
Rep:
?
#7
Report Thread starter 17 years ago
#7
wow thankyou very much guys, my line of best fit looks fab now!!! just out of curioisty, should a line of best fit go to the origin? i.e.) where the y and x axis meet at zero?
0
jediknight007
Badges: 10
Rep:
?
#8
Report 17 years ago
#8
(Original post by BABYGUY)
wow thankyou very much guys, my line of best fit looks fab now!!! just out of curioisty, should a line of best fit go to the origin? i.e.) where the y and x axis meet at zero?
Depends on the data but normally, no.
0
BABYGUY
Badges: 0
Rep:
?
#9
Report Thread starter 17 years ago
#9
Well, i have my lines of best fit, but is there any way for me to calculate a gradient for this line on excel?
0
Perplexed
Badges: 8
Rep:
?
#10
Report 17 years ago
#10
(Original post by BABYGUY)
Well, i have my lines of best fit, but is there any way for me to calculate a gradient for this line on excel?
Click on 'Add Trendline' again and there should be an option to display the equation of the line.
0
BABYGUY
Badges: 0
Rep:
?
#11
Report Thread starter 17 years ago
#11
I did, put the equation is not that of the gradient, its something else
0
LH
Badges: 15
Rep:
?
#12
Report 17 years ago
#12
(Original post by BABYGUY)
I did, put the equation is not that of the gradient, its something else
If you have the equation of the line, you can work out the gradient.
0
BABYGUY
Badges: 0
Rep:
?
#13
Report Thread starter 17 years ago
#13
its given me an equation, so how do i work the gradient from it?

equation of my line: y = 0.6815x + 0.0089
0
BABYGUY
Badges: 0
Rep:
?
#14
Report Thread starter 17 years ago
#14
omg, lol, well obviously 0.6825 is the gradient, because it is of the form y= mx + c. as m is 0.6825 then that is the gradient of the line
0
Perplexed
Badges: 8
Rep:
?
#15
Report 17 years ago
#15
(Original post by BABYGUY)
omg, lol, well obviously 0.6825 is the gradient, because it is of the form y= mx + c. as m is 0.6825 then that is the gradient of the line
You're doing maths AS? :rolleyes:
0
LH
Badges: 15
Rep:
?
#16
Report 17 years ago
#16
(Original post by BABYGUY)
omg, lol, well obviously 0.6825 is the gradient, because it is of the form y= mx + c. as m is 0.6825 then that is the gradient of the line
Yes, or for the mathematically simple people like me, the one with the 'x' next to it.
0
BABYGUY
Badges: 0
Rep:
?
#17
Report Thread starter 17 years ago
#17
yes i am
0
BABYGUY
Badges: 0
Rep:
?
#18
Report Thread starter 17 years ago
#18
Is there any way that i can get excel to draw me a triangle under the straight line, so that i can show how a change in y/change in x will give me the gradient = 0.6815. coz i need to show it like that aswell.
0
Perplexed
Badges: 8
Rep:
?
#19
Report 17 years ago
#19
I'm not aware of any. Just draw it on.
0
BABYGUY
Badges: 0
Rep:
?
#20
Report Thread starter 17 years ago
#20
damn, i have got my axis the wrong way round. my x axis should be the y, and the y should be the x. is there any way that i can switch them around, without having to do nother full graph all over again?
0
X
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

Which of these would you use to help with making uni decisions?

Webinars (64)
12.28%
Virtual campus tours/open days (123)
23.61%
Live streaming events (46)
8.83%
Online AMAs/guest lectures (52)
9.98%
A uni comparison tool (121)
23.22%
An in-person event when available (115)
22.07%

Watched Threads

View All