PLEASE EXPLAIN VIA CORRECT EXCEL SET UP

Best Invest seeks to allocate $$10,000$ between three funds A$,$ B$,$ and

C$.$ Best Invest's goal is to achieve an expected portfolio return of

$10\%$ at the lowest possible risk level. Best Invest has ten quarters of

annualized performance data on the three funds that are shown

below and provided in the Excel workbook for this quiz.

Which of the following statements are true regarding funds $A,B,$ and

C$?$

$($Note: Round answers to two significant digits except for covariance

values which are rounded to $5$ significant digits.$)$

The $10-$quarter average performance for fund $A$ is $7\mathrm{.}40\%.$

The $10-$quarter standard deviation in performance for fund $B$ is

$5\mathrm{.}37\%.$

The $10-$quarter covariance in performance between funds A and $C$ is

$0\mathrm{.}00316$

The $10-$quarter correlation in performance between funds $B$ and $C$ is

$0\mathrm{.}45$

Exactly two answers are correct.

Exactly three answers are correct.