TED Talk managers are looking for more details on the relationship in their data. They want to mine the data for unknown correlations. Using the data provided on the top $100$ TED Talks, look for the three following possible relationships.

What is the nature of the relationship between the year a video is filmed or published and the number of comments or views it has?

What is the nature of the relationship between the length of a video and the number of views or comments?

What is the nature of the relationship between the number of views and the number of comments?

Detailed Instructions:

Download the spreadsheet TED Talk Activity $5.$xls Download TED Talk Activity $5.$xls$.$

Insert two columns to the right of the Publish Date. Write a formula $(=$year$())$ that will extract the year from the film date and the film year. Label these columns appropriately as $$film year$$ and $$publish year.$$

Run a correlation on the following combinations and discuss your findings.

$($Note: A correlation will only be between $-1($completely negatively correlated$)$ to $+1($completely positively correlated$).$ A correlation coefficient of $0$ indicates no relationship. However, a strong correlation only demonstrates that a relationship exists. It does not indicate causation. Keep this in mind with your findings.$)$

Answer the questions below.

Upload your Excel file.

Film Year

Comments

Film Year

# Views $($million$)$

Publish Year

Comments

Publish Year

# Views $($million$)$

Length $($minutes$)$

Comments

Length $($minutes$)$

# Views $($million$)$

# Views $($million$)$

Comments

Resources

Introduction to Correlation Analysis in ExcelLinks to an external site.

Using Excel to Create a Correlation Matrix $||$ Correlation Matrix ExcelLinks to an external site.

Question at position $1$

$1$

$1$ point

Question at position $1$

The correlation between film year and comments indicates that:

The correlation between film year and comments indicates that:

Older videos do not have as many comments as newer ones.

Total number of comments decreases over time.

Film year and total number of comments are not related at all.

Total number of comments increases over time.

Question at position $2$

$2$

$1$ point

Question at position $2$

The correlation between publish year and total number of views indicates that:

The correlation between publish year and total number of views indicates that:

The older a video is$,$ the fewer comments it will have.

The newer a video is$,$ the fewer comments it will have.

The older a video is$,$ the more comments it will have.

The newer a video is$,$ the more comments it will have.

Question at position $3$

$3$

$1$ point

Question at position $3$

Which correlation demonstrates the strongest relationship?

Which correlation demonstrates the strongest relationship?

Film year to Comments

Publish Year to # Views $($millions$)$

# Views $($millions$)$ to Comments

Length $($minutes$)$ to Comments