Go to first unread
Back
to top
Microsoft Excel Help!!
Watch
Announcements
This discussion is closed.
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
Report
#2
when i studied as level ict i was told it was impossible to draw a line of best fit on excel.
sorry !!!!
sorry !!!!
0
Report
#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 !!!!
when i studied as level ict i was told it was impossible to draw a line of best fit on excel.
sorry !!!!
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
Report
#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.
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.
0
Report
#6
(Original post by Lord Huntroyde)
Badda boom, badda bing.
Badda boom, badda bing.
0
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
Report
#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?
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
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
Report
#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?
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
Report
#12
(Original post by BABYGUY)
I did, put the equation is not that of the gradient, its something else
I did, put the equation is not that of the gradient, its something else
0
its given me an equation, so how do i work the gradient from it?
equation of my line: y = 0.6815x + 0.0089
equation of my line: y = 0.6815x + 0.0089
0
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
Report
#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
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
Report
#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
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
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
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
