Question

<sup>The next three questions are based on the following data on the girth (in inches) and the height (in feet) of black cherry trees. Treat the girth as the independent/explanatory variable.
Girth 8.6 10.5 11.3 12.9 13.3 Height 65 72 79 85 86
5. Find ˆ m.
A. ≈−5.07 B. ≈ .212 C. ≈ 4.64 D. ≈ 24.93 E. other value
6. Find the coefficent of determination.
A. ≈ .991 B. ≈ .981 C. ≈ .970 D. ≈ .941 E. other value
7. Find a 90% confidence interval for the slope of the regression line.
A. [3.77,5.51] B. [3.86,5.42] C. [4.03,5.25] D. [4.13,5.15] E. other value</sup>

Answer 1

Solution :

From Excel,

DATA ---> Data Analysis----> Regression

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.990695
R Square	0.981476
Adjusted R Square	0.975302
Standard Error	1.399495
Observations	5
ANOVA
	df	SS	MS	F	Significance F
Regression	1	311.3242	311.3242	158.9535	0.001076
Residual	3	5.875759	1.958586
Total	4	317.2
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 90.0%	Upper 90.0%
Intercept	24.92546	4.208905	5.922076	0.00962	11.53084	38.32007	15.02037	34.83054
X Variable 1	4.63556	0.367678	12.60768	0.001076	3.465446	5.805675	3.770281	5.500839

5)

Option C (4.64)

6)

Option B (0.981)

7)

Option A [3.77,5.51]