Stack the data in the Stacked worksheet.

$1$: Preparation

Step $1$: The CRSP Data worksheet has data for the largest

companies in nineteen industries for every month for ten years.

Step $2$: Type your first name and Net ID into Cells A$2$:B$2$ on the

Stacked worksheet.

Step $3$: Replace the inputs in Cells D$10$:J$10$ on the Stacked

worksheet with the names of your industries, keep the order.

Step $4$: Create a formula in Cell D$2$ on the Stacked worksheet that

finds the representative ticker for the industries in D$10.$

Step $5$: Copy$-$Paste this formula such that the representative

tickers appear for Cells E$2$:J$2.$

Step $6$: Change the formatting for the months, Cells C$11$:C$82,$ to

match that on the CRSP Data worksheet.

$2$: Complete Table

Step $1$: Use the Data Table tool to fill in the table, Cells D$11$:J$82,$

with the returns for the industry in the months given.

Step $2$: Make the formatting display for the returns $0\mathrm{.}0\%.$

B$)$ Paste the data in the Betas worksheet

Step $1$: Use the Data Validation tool to create a drop$-$down menu

for Cell C$2$ on the Betas worksheet to select from, and only from, one

of the months in $2023.$

Step $2$: Change the formatting for Cell C$2$ to match that on the

CRSP Data worksheet.

Step $3$: Create a formula in Cell D$2$ that will get the beta for the

Industry in D$10$ for the five years immediately preceding the month

selected in Cell C$2.$ To receive full credit, this formula needs to adjust

automatically for any of the twelve possible months in Cell C$2.$

Step $4$: Copy$-$Paste this formula from Cell D$2$ to E$2$:J$2.$

Step $5$: The formatting for the betas needs to be as they are

normally displayed.

B$)$ Performance Evaluation

Step $1$: Create a formula for Cell D$3$ that computes the Alpha for

the Industry in Cell D$10$ for the five years immediately preceding the

month selected in Cell C$2.$ To receive full credit, this formula needs to

adjust automatically for any of the twelve possible months in Cell C$2.$

Step $2$: Create a formula for Cell D$4$ that computes the Treynor

Ratio for the Industry in Cell D$10$ for the five years immediately

preceding the month selected in Cell C$2.$ To receive full credit, this

formula needs to adjust automatically for any of the twelve possible

months in Cell C$2.$

Step $3$: Copy$-$Paste these formulas from Cells D$3$:D$4$ to E$3$:J$4.$

Step $4$: The formatting for the two performance evaluation

measures must be as they are normally displayed.