Expert Answers

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)