Part $2$: Complete the following exercise: Instructions:

You are preparing to have dinner with an old family friend who works in Finance. He sent you a dataset with the aggregate statistics on

Dividends, Dividend Payouts, Market Capitalization, and Institutional holdings by Industry. He heard that you're in college and

learning how to visualize data. He said he's always wondered whether firms with higher institutional investors pay more in dividends.

He asked you to provide him with a visualization that helps him see the relationship and any calculations that you can think of$.$

There are three parts to this problem. Use Excel to perform the following:

a$.$ Format the data as a Table. Sort from smallest to largest institutional holdings. Insert a combination chart that shows

institutional holdings $($line$)$ and Total Dividends $($bar$).$ Add a trendline for the dividends. Be sure to put a proper heading, use a

secondary axis, and have a legend.

b$.$ Use the r$-$squared formula to see if there is a relationship between Institutional Holdings $(x)$ and Total Dividends $(Y).$

c$.$ Discuss your results in the chart and the $r-$squared calculation.

$($a$)$

Which company has the lowest institutional holdings?

Electronics $($consumer$)$

Precious metals

Entertainment

R$.$E$.$I.T$.$

$($b$).$

The value for $R-$squared is:

None of these are correct

Less than $1$

Greater than $1$

Cannot be determined based on the data provided

$($c$).$

R$-$square determined there is:

a$.$ A relationship between institutional holdings and dividends

b$.$ There is no relationship between institutional holdings and dividends

c$.$ Institutional holdings explain less than $1\%$ of the variation in dividends

d$.$ Both $B$&$C$