One of the stores is a proud sponsor of the college soccer t

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.

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

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

One of the stores is a proud sponsor of the college soccer t

Solution

Get Help Now

Submit a Take Down Notice