I am not sure how to answer b, c and d.

Q3										12 Marks				Age	Weight
A researcher is interested in determining if age predicts weight or not.									54	65
The table to the right indicate the age and weights of the people (14) in the sample.									62	92
														80	82
														25	74
a) Run simple regression analysis using Excel.							2 Mark					28	76
Note: use 95% confidence level.													29	71
														62	79
b) Is age a significant determinant of weight? Explain.						3 Marks					64	85
														47	82
c) What is amount of variation in weight that is explained by age? Explain.				4 Marks					49	62
														52	64
d) What is the expected weight of a person who is 56 years old?					3 Marks					35	54
														36	73
														91	83
a)
SUMMARY OUTPUT
Regression Statistics
Multiple R	0.48539918
R Square	0.23561237
Adjusted R Square	0.1719134
Standard Error	9.4953326
Observations	14
ANOVA
	df	SS	MS	F	Significance F
Regression	1	333.4924782	333.4925	3.698841	0.078498257
Residual	12	1081.936093	90.16134
Total	13	1415.428571
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	61.325246	7.270437818	8.434877	2.18E-06	45.48432282	77.166169	45.4843228	77.16616921
Age	0.25692795	0.133591403	1.923237	0.078498	-0.03414271	0.5479986	-0.0341427	0.547998612