08 Jan, 03:40PM in sunny Singapore!
Home → IT Support and Tech Corner →

Ploting graident in excel

Subscribe to Ploting graident in excel 5 posts

Please Login or Signup to reply.
  • soloken
    soloken's Avatar
    460 posts since Jun '05
    • 14 Feb `06, 10:11AM

      Hi,

      Need advice from excel experts:

      If I have calculated the slope which is m from the following example data:

      x y
      1 5
      2 7
      3 8

      Now I want to use the gradient from the above set to plot a chart which I have only the starting point now :

      x y
      1 6
      2 ?
      3 ?

      Please advise how can I calculate and plot for the ? in x 2 and 3?

      thanks.

  • Moderator
    ndmmxiaomayi
    ndmmxiaomayi's Avatar
    53,347 posts since Aug '05
  • soloken
    soloken's Avatar
    460 posts since Jun '05
    • 14 Feb `06, 1:49PM
      Originally posted by ndmmxiaomayi:
      Ermm, how do you calculate gradient when you have one x and one y coordinates?

      ok i manage to solve it.

      why not? y=mx+b and m = slope, you need to find the b and m, in this case you can use excel to find out the m using linear.

  • Moderator
    lpx88
    lpx88's Avatar
    6,985 posts since Jun '05
    • 14 Feb `06, 4:16PM

      i learn that y=mx+c in skool, where m is the gradient and C is they intercept on the y axis Laughing

  • Moderator
    ndmmxiaomayi
    ndmmxiaomayi's Avatar
    53,347 posts since Aug '05
    • 14 Feb `06, 4:38PM
      Originally posted by soloken:
      ok i manage to solve it.

      why not? y=mx+b and m = slope, you need to find the b and m, in this case you can use excel to find out the m using linear.

      But your graph is not linear. I drew out the graph, the line is a crooked. Rolling Eyes

Please Login or Signup to reply.