Construct a scatter plot using excel for the given data


Section 9.1 : Correlation
1. Construct a scatter plot using excel for the given data. Determine whether there is a positive linear correlation, negative linear correlation, or no linear correlation. Complete the table and find the correlation coefficient r. (References: example 1 - 4 pages 498 - 500; end of section exercises 15 - 22 pages 508 - 509)

The data below are the number of absences and the final grades of 9 randomly selected students from a statistics class.

Absences, x
4
7
10
8
13
6
19
12
9
Final grade, y
99
87
81
83
72
93
56
77
83

Solution Preview :

Prepared by a verified Expert
Accounting Basics: Construct a scatter plot using excel for the given data
Reference No:- TGS01237015

Now Priced at $15 (50% Discount)

Recommended (93%)

Rated (4.5/5)