Explore BrainMass

Explore BrainMass

    Excel scatter plot diagram

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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 12
    2 10
    4 9
    3 11
    5 12
    4 15

    © BrainMass Inc. brainmass.com March 4, 2021, 5:46 pm ad1c9bdddf
    https://brainmass.com/statistics/scatter-plot/excel-scatter-plot-diagram-10284

    Solution Preview

    Enter the data in excel. select all the data and hit chart icon.
    <br>Select chart type to be scatter ...

    Solution Summary

    The expert examines an Excel scatter plot diagram.

    $2.49

    ADVERTISEMENT