Statistics Homework Solutions
Problem
#10284

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

Solution
What is this?
By OTA - Overall OTA Rating
Purchase Cost Now
$2.19 CAD (was ~$3.99)
Included in Download
  • Plain text response
  • Attached file(s):
    • scatter.xls
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
  • Scatter Diagram - Given the following data, how do you make Excel create a scatter diagram for you? If you were to draw a line through the points, how straight would the line be? What is the coefficient of determi ...
  • Determine the coefficient of correlation and the coefficient of determination. - The following sample observations were randomly selected. X: 5 3 6 3 4 4 6 8 Y: 13 15 7 12 13 11 9 5 Determine the coefficient of correlation and the coefficient of determination. Interpret ...
  • Coefficient of non-determination - Find the coefficient of non-determination for the correlation coefficient r=0.37. a. 0.8631 b. 0.1369 c. 0.7549 d. 0.6302
  • Coefficient of correlation and coefficient of determination. - Can someone please help me with how to figure out the COC and the COD, as well as the association of X and Y? The following sample observations were randomly selected: X: 5 3 6 3 ...
  • Calculating the Coefficient of determination - The following results were obtained from a simple linear regression analysis. Total sum of square = 5.7640. Explained sum of squares = 5.5415. Unexplained sum of squares = 0.2225. The coefficient of d ...
Browse