An individual is planning the allocation of investments for 2022. The rate of returns for the various investments in 4 different years are s given in the table below.

Due to the high demand in the housing market, the investment in this sector cannot exceed 30% of the total available funds.

The investor is a tech enthusiast and wants to allocate at least 10% of the funds to crypto.

How should their investment of 50,000$ be allocated to maximize the return?

What is the minimum variance associated with return on investment of 9%?

*****Please solve using Excel and thoroughly show each step/formula*********

Rate of return TYPE \"f Tear1 Year 2 Year 3 Year in investment \"\"- m-W M m