We will use Excel formula to find the values of the covariance and correlation coefficient and analyze what the values mean. We will use the Excel Data Analysis Add-in to build a regression model and find the values of the errors in the model. We will identify the value of the coefficient of determination and analyze its meaning. We will use the regression model to make predictions. We will test the claim that there is no relationship between the two variables. We will compare the observed level of significance (p-value) with alpha and decide if we can conclude that there is relationship between the two variable."
Fig: 1
Fig: 2