anonymous
  • anonymous
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.
Mathematics
  • Stacey Warren - Expert brainly.com
Hey! We 've verified this expert answer for you, click below to unlock the details :)
SOLVED
At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat.
jamiebookeater
  • jamiebookeater
I got my questions answered at brainly.com in under 10 minutes. Go to brainly.com now for free help!
anonymous
  • anonymous
1 Attachment
anonymous
  • anonymous
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.
anonymous
  • anonymous
any example on how to that ?

Looking for something else?

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

More answers

anonymous
  • anonymous
you mean, example online?
anonymous
  • anonymous
yes i guess
mathmate
  • mathmate
@Andresfon12 Is this a math question or Excel question? Answer depends on what to expect.
anonymous
  • anonymous
more like a statistic question dealing with excel
mathmate
  • mathmate
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.
anonymous
  • anonymous
need to be in excel but i can do it on paper then excel after
anonymous
  • anonymous
I got go now I guess i will closed this question when i get back
mathmate
  • mathmate
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
mathmate
  • mathmate
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
anonymous
  • anonymous
thx so much
mathmate
  • mathmate
You're welcome! :)

Looking for something else?

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