Question

 

60 observations from a study on the impact of exercise and diet on body weight loss. The variables, exercise, diet, and exdiet are binary variables and the variable diff is a continuous variable.

exercise = 1 if a person exercises, 0 otherwise. diet = 1 if a person follows a diet plan, 0 otherwise. exdiet = 1 if a person exercises and follows a diet plan, 0 otherwise. diff = The difference observed in weight (in lbs.) after 3 months of observation.

Summary Statistics:

	Excercise	Diet	Exdiet	Diff
Count	60	60	60	60
Mean	0.68	0.48	0.45	10.595932
sample standard deviation	0.47	0.50	0.50	9.771008
sample variance	0.22	0.25	0.25	95.472603
Minimum	0	0	0	-16.2738
Maximum	1	1	1	26.5177
Range	1	1	1	42.7915
1st quartile	0.00	0.00	0.00	4.075273
Median	1.00	0.00	0.00	11.387700
3rd quartile	1.00	1.00	1.00	18.964165
interquartile range	1.00	1.00	1.00	14.888892
Mode	1.00	0.00	0.00	#N/A
low extremes	0	0	0	0
low outliers	0	0	0	0
high outliers	0	0	0	0
high extremes	0	0	0	0

Answer 1

First of all you have add analysis tool pack on excel-

1. Click the File tab, click Options, and then click the Add-Ins category.

   If you're using Excel 2007, click the Microsoft Office Button , and then click Excel Options

2. In the Manage box, select Excel Add-ins and then click Go.

   If you're using Excel for Mac, in the file menu go to Tools > Excel Add-ins.

3. In the Add-Ins box, check the Analysis ToolPak check box, and then click OK.

A Data tab should have shown on ribbon menu.

steps -

Click Data tab - Data Analysis(extreme right) - Descriptive Statistics - ok

Input Range - Select the whole data under study.

Labels in first row - Check only if you have selected data with label column .ie first column.

Summary statistics - check box

Kth Largest - Check box

Kth Smallest - Check box

and click OK.

Hope you will get Your required Result.