what would the beta of the portforlio be?

need excel formula

Portfolio Calculation- Forcefully Delicious cookies is expanding into new businesses- 1. A Hot Chocolate company, 2. a Candy Company. Based on the following information, calculate the expected return and standard deviation for a $100.000 total investment, where $47.000 is invested in the hot chocolate store; $53,000 is invested in the Candy company: Weather condition Probability of Weather Hot Chocolate Possible Rates of Return (%) 18 Candy Possible Rates of Return (%) + 0.65 Global Warming Mini Ice Age Same as it ever was 6 0.2 0.15 5 30 BETA 5 IF 6 Hot Chocolate's Bcta in 7 Candy's Betais 18 2.3 0.78 10