After studying and reviewing the concepts and practices of correlation and simple linear regression, solve the following exercise using Excel:
 
1. 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
 
2. Consider the following aspects when submitting your test:
 
·
 
· Graph the scatter plot or dispersion
 
· Determine the correlation coefficient.
 
· Determine the regression equation.
 
· Find the value of the dependent variable when X = 7.
 
· Is the regression model adequate? Justify your answer. Which test determines this?
 
3. Present your answers with the aspects learned so far about correlation and simple linear regression.
 
 
 
Be sure to review the  academic expectations  for your submission.
 
Submission Instructions:
 
· Submit your assignment by 11:59 PM Eastern on Sunday.
 
· Review the rubric to determine how your assignment will be graded.
 
· Your assignment will be run through Turnitin to check for plagiarism. 
 
· Justify any assumption and show all the steps to solve the exercises.