Microsoft Excel Help!!
Watch this threadThis discussion is closed.
BABYGUY
Badges:
0
Rep:
?
You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#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
?
You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#2
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
BABYGUY
Badges:
0
Rep:
?
You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#3
Perplexed
Badges:
8
Rep:
?
You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#4
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
LH
Badges:
15
Rep:
?
You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#5
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
Perplexed
Badges:
8
Rep:
?
You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#6
Report
#6
(Original post by Lord Huntroyde)
Badda boom, badda bing.
Badda boom, badda bing.

0
BABYGUY
Badges:
0
Rep:
?
You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#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:
?
You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#8
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
BABYGUY
Badges:
0
Rep:
?
You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#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:
?
You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#10
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
BABYGUY
Badges:
0
Rep:
?
You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#11
LH
Badges:
15
Rep:
?
You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#12
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
BABYGUY
Badges:
0
Rep:
?
You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#13
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
BABYGUY
Badges:
0
Rep:
?
You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#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:
?
You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#15
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
LH
Badges:
15
Rep:
?
You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#16
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
BABYGUY
Badges:
0
Rep:
?
You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#17
BABYGUY
Badges:
0
Rep:
?
You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#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:
?
You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#19
BABYGUY
Badges:
0
Rep:
?
You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#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
to top