$9)$ After reviewing the compounding model, your Kindergartener has a follow up question about effective annual rates. She figures with more frequent compounding, the effective annual rate cannot be $3\%$ for all the compounding options. Calculate the effective annual rate for each of the compounding options in Question $8,$ using a function. $($round to three decimal places$)$

I need the annual, semi$-$annually, quarterly, and monthly.

I NEED THE EXCEL FORMULAS TOO, PLEASE.

The annual is $3\mathrm{.}000\%.$ The semi$-$annual is $3\mathrm{.}022\%.$ The quarterly $3\mathrm{.}034\%.$ The monthly $3\mathrm{.}042\%.$