Question

	betas
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	60	9.22603481	6.503336	0.000187444	38.72472558	81.27527
X Variable 1	5	0.580265238	8.616749	2.54887E-05	3.661905962	6.338094

please show me the formula on exel how the teacher got thesee results?

Here are the following data

Restaurant	Population as x	Sales as y
1	2	58
2	6	105
3	8	88
4	8	118
5	12	117
6	16	137
7	20	157
8	20	169
9	22	149
10	26	202

Answer 1

This rsults is obtained by performing Regression in excel taking x as independent variable and y as dependent variable.

the steps of performing regression in excel is explained below:

To add data analysis option in your tool bar( ignore this part if data analysis is showing in your tool bar after selecting data tab)

1. Click on FILE> Options> Add-Ins
2. From the manage box appearing select Excel Add-Ins. click Go.
3. From the Add-Ins available box appearing select Analysis Tool pack then click Ok.

this will add data analysis to your tool bar.

doing Regression.

1. Click on DATA tab select Data Analysis.
2. From the Analysis Tools select Regression. click on Ok.
3. In Input y range select sales as y column.
4. In Input x range select population as x column.
5. Click on Ok.

This will give you the above result.