Question

QUESTION 2 In a recent survey, a 17-year old gave a movie a score of 9, while a 72-year old gave it a score of 3, a 48-year old gave it a score of 5 and a 42-year old gave it a score of 5. Based on these four surveys, what is the correlation between age of movie-goer and score for the movie? O 0.51 0.72 0.76 0.01 -0.97

Answer 1

Correct Answer: Option E. -0.97

Explanation: I am using Excel to solve the correlation between the data sets of the age and movie rating by copying the data into the Excel sheet. Take any empty cell, put the formula =CORREL(E7:E10,F7:F10) for selecting both columns as the data array, and the function CORREL() will give us the correlation between these two arrays of variables which comes out to be -0.970440837 which is almost equal to the -0.97.

The calculations should look like the following screenshot of the EXCEL:

S = Q = FILE HOME INSERT PAGE LAYOUT FORMULAS DATA % Cut Calibri 11 A À == LE Copy Paste Format Painter BIU, - A, EEE Clipboard Font C E13 : x fc =CORREL(E7:E10,F7:F10) A B C E REVIEW On E Book1 - Excel VIEW DEVELOPER ACROBAT Wrap Text General Merge & Center - $ % , D D ? - OX Nikhil Pratap Singh AutoSum - A # Fill Sort & Find & Clear Filter - Select X B u Insert Delete Format - Cells Conditional Format as Cell Formatting Table Styles Styles Alignment Number Editing F G H I J K L M N O P R S Age 17 Rating 9 3 5 48 42 5 Correlation between Age and Rating = -0.970440837 Sheet2 Sheet1 + S 100% READY H O @ op U -- ^ 0 + 1» 5713/2020 Type here to search

This means that age and movie ratings are negatively correlated. In other words, the higher the age the lower will be rating given by the individual for the same movie.

I hope the above solution satisfies your query given in the question.

“If you liked my answer, please don’t forget to give an UPVOTE!”

“That will be very helpful and encouraging for me for my time and efforts!”

THANK YOU!