Question

	Coefficients	Standard Error	t-Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept
Calories

Calories (x)	Fat Content (y)	Predicted y value	Residual
140	7	5.75	1.25
160	8	6.77	1.23
70	2	2.18	-0.18
120	3.5	4.73	-1.23
170	16	7.28	8.72
290	12	13.4	-1.4
210	17	9.32	7.68
190	12	8.3	3.7
210	1.5	9.32	-7.82
130	3.5	5.24	-1.74
150	4.5	6.26	-1.76
160	12	6.77	5.23
150	7	6.26	0.74
140	6	5.75	0.25
180	4.5	7.79	-3.29
80	1	2.69	-1.69
200	7	8.81	-1.81
200	5	8.81	-3.81
180	7	7.79	-0.79
140	2.5	5.75	-3.

i need to fill in the top chart but with this given information but i have no idea what they are asking for or what calculations to do. i also do not know what my professor means by intercept

Answer 1

We need to enter just the "Calories (x)" and the "Fat Content (y)" columns of the data set in MS Excel and use the "Regression" option under Data > Data Analysis to carry out the regression analysis and fill up the top chart, which your professor provided. The screenshot of the data set and the output is given below.


The top chart contents are given below.

	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	-1.391	3.237	-0.430	0.673	-8.192	5.410	-8.192	5.410
Calories (x)	0.051	0.019	2.683	0.015	0.011	0.091	0.011	0.091