One of the stores is a proud sponsor of the college soccer team. They constantly

Question

One of the stores is a proud sponsor of the college soccer team. They constantly try to raise money for the team and they want to determine if there is any type of relationship between the amount of contribution and the years that the alumnus has been out of school.

Years (X)               1      5      3      10      6       6       2               

Contribution (Y)    250    100    110    0        70      80      175            

Using Excel construct a scatter plot. Discuss the output of the scatter plot.  

Explanation / Answer

First plot the scatter plot

Step 1: Find XY and X2 as it was done in the table below. X Y XY XX 1 250 250 1 5 100 500 25 3 110 330 9 10 0 0 100 6 70 420 36 6 80 480 36 2 175 350 4 33 785 2330 211 a Intercept 228.724 b slope -24.729 y=228.724-24.729x

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.