Understand the height of a california redwood tree

Reference no: EM1317362

Using Excel finding the multiple regression equation and 95% confidence

Answer the following question: Measuring the height of a California redwood tree is a very difficult undertaking because these trees grow to heights of over 300 feet. People familiar with these trees understand that the height of a California redwood tree is related to other characteristics of the tree, including the diameter of the tree at the breast height of a person and the thickness of the bark of the tree. The data in the file redwood.sls attached represents the height, diameter at breast height of a person and the bark thickness for a sample of 21 California redwood trees.

a) State the multiple regression equation.

b) Interpret the meaning of the slopes in this equation.

c) Predict the mean height for a tree that has a breast diameter of 25 inches and a bark thickness of 2 inches.

d) Interpret the meaning of the coefficient of multiple determination in this problem

e) Perform a residual analysis on the results and determine the adequacy of the model.

f) Determine whether there is a significant relationship between the height of redwood trees and the two independent variables (breast diameter and the bark thickness) at the 0.05 level of significance.

g) Construct a 95% confidence interval estimate of the population slope between the height of the redwood trees and the bark thickness.

h) At the 0.05 level of significance, determine whether each independent variable makes a significant contribution to the regression model. Indicate the independent variables to include in this model.

i) Construct a 95% confidence interval estimate of the mean height for trees that have a breast diameter of 25 inches and a bark thickness of 2 inches along with a prediction interval for a individual tree.

j) Compute and interpret the coefficients of partial determination.

NOTE: The answer for a is Y = 62.1411 + 2.0567X1 + 15.6418X2

Reference no: EM1317362

Questions Cloud

Use algebra to solve menstruation problems : Use algebra to solve menstruation problems

Calculate the dollar cost of the possible hedges : Calculate the dollar cost of the possible hedges and explain which hedge you would use

Cost allocation using direct method : Cost allocation using Direct method allocate costs to the mission centers using the direct distribution method

Find the maximum height : Find the maximum height

Understand the height of a california redwood tree : Any person who is familiar with these trees understand the height of a California redwood tree which is related to another characteristics of the tree.

Plotting points & then sketching the curves : Plotting points & then sketching the curves

Critical value of f test for similar level of significance : Find out the critical value for the given degrees of freedom of the F-test also the lower-tailed critical value of F test for the similar level of significance

Solving maxima and minima : Solving maxima and minima

Discriminate of the quadratics : Discriminate of the quadratics.

User Account

All Pages