Listed below are the overhead widths (in cm) of seals measured from photographs and the weights (in kg) of the seals. Construct a scatterplot, find the value of the linear correlation coefficient r,...

There has GOT to be an easier way or something I can plug this into a calculator or an excel spreadsheet.

Please demonstrate with this example.

Thanks

The value of correlation coefficient is r =

The critical value is {r_c} =

Fail to reject {H_o}Ho​ there is no sufficient evidence to conclude that there is a linear correlation between overhead widths of seals from photographs and the weights of the seals.

Extracted text: Listed below are the overhead widths (in cm) of seals measured from photographs and the weights (in kg) of the seals. Construct a scatterplot, find the value of the linear correlation coefficient r, and find the critical values of r using a= 0.05. Is there sufficient evidence to conclude that there is a linear correlation between overhead widths of seals from photographs and the weights of the seals? Overhead Width 7.6 9.7 245 8.9 8.2 D 7.1 110 9.3 Weight 172 201 209 183