Type the Excel formula that draws one random ticker from a named range Tickers, using COUNTA so the draw covers the whole list.
Type the Excel formula that draws one random ticker from a named range Tickers, using COUNTA so the draw covers the whole list.
Answer
=INDEX(Tickers,RANDBETWEEN(1,COUNTA(Tickers)))
RANDBETWEEN(1, n) draws a row number; INDEX returns the ticker in that row. Fill twelve cells, then paste as values before anything else is typed.
The course’s project brief (research.md §4 — 12 chosen, 12 random, two indices, weekly tracking, five-minute presentation); OpenStax Principles of Finance §11.5 — efficiency, reference only; original hypothesis wording and simulation