Microsoft Excel Help!!

Watch this thread
This 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
Report Thread starter 18 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
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#2
Report 18 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:
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#3
Report Thread starter 18 years ago
#3
noooooooooo!!!!!!!!!!!!!!!!!!!!!! damn!!!!!!!!!
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.
#4
Report 18 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:
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#5
Report 18 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:
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#6
Report 18 years ago
#6
(Original post by Lord Huntroyde)
Badda boom, badda bing.
You say potato, and I say patato.
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
Report Thread starter 18 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:
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#8
Report 18 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:
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#9
Report Thread starter 18 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:
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#10
Report 18 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:
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#11
Report Thread starter 18 years ago
#11
I did, put the equation is not that of the gradient, its something else
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.
#12
Report 18 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:
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#13
Report Thread starter 18 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:
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#14
Report Thread starter 18 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:
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#15
Report 18 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:
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#16
Report 18 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:
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#17
Report Thread starter 18 years ago
#17
yes i am
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.
#18
Report Thread starter 18 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:
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#19
Report 18 years ago
#19
I'm not aware of any. Just draw it on.
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.
#20
Report Thread starter 18 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

Y13's - If you haven't confirmed your firm and insurance choices yet, why is that?

I am waiting until the deadline in case anything in my life changes (10)
20.41%
I am waiting until the deadline in case something else changes (e.g. exams/pandemic related concerns) (4)
8.16%
I am waiting until I can see the unis in person (4)
8.16%
I still have more questions before I make my decision (5)
10.2%
No reason, just haven't entered it yet (14)
28.57%
Something else (let us know in the thread!) (12)
24.49%

Watched Threads

View All