This assignment is based on textbook material from sections 10-1, 10-2, 10-3. See also Help Files in Course Content section on WebTycho. Assigned any numbers for the first two columns. You should have 5 or 6 rows with numbers in your table
Complete the table, calculate values in next three columns.
Part 1. Coefficient of Linear Correlation Coefficient r (Pearson Coefficient). Hard way: - Calculate values in next three columns. - Find total (Sum) for each column: Σx, Σy, Σx2, Σy2, Σxy, - Use formula 10-1 on page 499 to calculate Coefficient of Linear Correlation Coefficient r. Easy way: open Excel, enter your x- and y-values in the first two columns, then use function =PEARSON(x-array,y-array) or =CORREL (x-array,y-array) and see your Correlation Coefficient r right away. After you have your r value compare it to the critical value from the table A-6 in Appendix A. Use significance level α = 0.05 Make the conclusion, if there is a linear correlation between x and y in your table.
Part 2. Use your data in x-column and y-column to find an Equation of Regression Line: y = b0 + b1x Equation of Regression Line is defined by two parameters: slope b1 and y-intercept b0. You can find these parameters very easy with Excel. To find slope b1 use Excel function =SLOPE(y-array,x-array) To find y-intercept b0 use Excel function =INTERCEPT(y-array,x-array)