00:01
For this problem, we are given a table of the rotten tomatoes and metacritic scores for several movies produced in 2017.
00:08
We're asked in part a, now note, i've copied down the data, i haven't copied down the names of the movies, just because that doesn't really matter.
00:15
For part a, we're asked to use technology to make a scatterplot using rotten tomatoes as the independent variable and metacritic as the dependent variable.
00:24
So, in excel, all we need to do is select the data, go to the little quick analysis.
00:31
Charts, scatter.
00:34
So we have metacritic or mc versus rt for rotten tomatoes.
00:45
Then, like, where we're asked, based on our scatter plot, do we think that there is a strong linear association between these variables? i'd say so.
00:53
Like, we can see that it does roughly look like there is a sort of line that everything is grouping about.
01:02
Then for part b, we're asked to compute the correlation coefficient and to write the equation of the regression line.
01:08
Now, if you're doing this in excel, this is super easy...