A sociologist theorized that people who watch television frequently are exposed to many commercials, which in turn lead

[answerhappygod]

A sociologist theorized that people who watch television
frequently are exposed to many commercials, which in turn lead them
to buy, resulting in increasing debt. To test this belief, a sample
of 420 families was drawn. For each, the total debt ($) and the
number of hours the television is turned on per week were
recorded.
a) Calculate the covariance and the coefficient of correlation
between the two variables. Is the theory true based on this
sample?
b) Construct a scatter diagram on Excel with the number of hours
the television is turned on per week on the horizontal axis in
order to find the slope of the regression line and the coefficient
of determination. Check the relationship between the covariance
matrix, the correlation matrix, and the scatter diagram.