A community for students.

Here's the question you clicked on:

55 members online
  • 0 replying
  • 0 viewing

anonymous

  • one year ago

Anyone know what this mean or What I'm support to do ? Here the question: Sheet 2 of the attached spreadsheet is to be completed to display a dependency graph of the given data points. Make sure that your points are linked by segments.

  • This Question is Closed
  1. anonymous
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    1 Attachment
  2. anonymous
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Plot the points on a coordinate graph, and then try to find the line that goes through the points, assuming it is a linear pattern.

  3. anonymous
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    any example on how to that ?

  4. anonymous
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    you mean, example online?

  5. anonymous
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    yes i guess

  6. mathmate
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 1

    @Andresfon12 Is this a math question or Excel question? Answer depends on what to expect.

  7. anonymous
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    more like a statistic question dealing with excel

  8. mathmate
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 1

    So is your answer supposed to be in Excel commands, or a general description? Your answer could be an pen-and-paper plot, or it must be in Excel? I interpret it to be the latter case.

  9. anonymous
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    need to be in excel but i can do it on paper then excel after

  10. anonymous
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    I got go now I guess i will closed this question when i get back

  11. mathmate
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 1

    To do the first part that shows a graph of the scattered plot linked by a straight line, 1. mark the two columns of data (include the heading if you wish) 2. choose "[insert]-[scatter (under charts)]-[scatter with straight line and markers] and you're done. It will be obvious that a regression line would fit the data quite will, with a coefficient of correlation of 0.998

  12. mathmate
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 1

    If you need to find the regression line, follow instructions of the following link with examples. http://cameron.econ.ucdavis.edu/excel/ex52bivariateregression.html The equation is \(approximately\) y (estimated) = 2000-20x

  13. anonymous
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    thx so much

  14. mathmate
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 1

    You're welcome! :)

  15. Not the answer you are looking for?
    Search for more explanations.

    • Attachments:

Ask your own question

Sign Up
Find more explanations on OpenStudy
Privacy Policy

Your question is ready. Sign up for free to start getting answers.

spraguer (Moderator)
5 → View Detailed Profile

is replying to Can someone tell me what button the professor is hitting...

23

  • Teamwork 19 Teammate
  • Problem Solving 19 Hero
  • You have blocked this person.
  • ✔ You're a fan Checking fan status...

Thanks for being so helpful in mathematics. If you are getting quality help, make sure you spread the word about OpenStudy.

This is the testimonial you wrote.
You haven't written a testimonial for Owlfred.