Question 1

The Billingsley Health Center offers a regimented weight loss program for its customers. The program director monitored 83 men. The file called BHC contains data on the weight they lost after six weeks on the program and the average daily calories each consumed per day. (Use Excel to generate the results of the linear regression)

a) Develop a regression model using calories as the independent variable and weight lost as the dependent variable. What percentage of the variation in weight lost is explained by the average calories consumed?

b) Test using an alpha = 0.05 level to determine if the regression slope coefficient is statistically significant.

c) Use the regression model to describe the relationship between calories consumed and weight lost.

Weight Loss	Calories
10	2053
15	1985
10	2045
17	1936
12	2027
11	2028
11	2038
9	2056
13	1986
14	1970
16	1996
10	2049
13	2024
15	1976
9	2055
10	2050
10	2037
14	1959
5	2120
13	2015
9	2080
17	1936
17	1946
13	1977
10	2050
6	2120
7	2078
11	2043
8	2095
7	2094
10	2052
11	2035
12	2020
11	2029
16	1945
14	1995
15	1996
10	2059
11	2028
15	1958
10	2057
14	1979
8	2089
15	1957
9	2070
7	2092
3	2154
12	2029
12	2025
8	2086
8	2092
12	2000
12	2020
13	2003
12	2019
16	1973
12	2026
11	2059
12	2009
16	1964
9	2052
14	1992
11	2023
11	2036
8	2088
7	2092
9	2070
6	2102
9	2066
19	1920
19	1914
16	1963
12	2014
9	2072
14	1990
15	1972
10	2062
11	2047
10	2070
12	2014
7	2091
13	2015
13	1980