Explore BrainMass

Explore BrainMass

    Scatter Plot

    BrainMass Solutions Available for Instant Download

    Scatter Plot and Determining Correlation

    In forestry there appears to be a correlation between the diameter of a tree at breast height and the total height of the tree. For the following sample of ten white spruces, first construct a scatter plot then find the correlation (r) between height, r squared, and T. Diameter(cm) Height 18.9 20.0 15.5

    Excel scatter plot diagram

    Given the following data, 1) how do you make Excel create a scatter diagram for you? 2) If you were to draw a line through the points, how straight would the line be? 3) What is the coefficient of determination - r2 for this data, and more importantly, 4) what does it mean? # Employees # Orders received 1 1