all the links of the historical data are put feel free touse them thank you for your needed help

1) Go to Yahoo FINANCE. Obtain two years worth of daily stock rates of return for PepsiCo: https://finance.yahoo.com/quote/PEP/history?p=PEP, Coca Cola:https://finance.yahoo.com/quote/KO/history?p=KO , and for the S&P 500: https://finance.yahoo.com/quote/%5EGSPC/history?p=%5EGSPC, index. Use a spreadsheet to compute PepsiCos and Coca-Colas historical market betas. (Note: For future market betas, you should further shrink towards 1.)

2) Download 3 years of historical daily (dividendadjusted) prices for Intel (INTC) and the S&P 500 from Yahoo FINANCE. here are the links for the 3 years INTC :https://finance.yahoo.com/quote/intc/history/. S&P 500: https://finance.yahoo.com/quote/%5EGSPC/history?p=%5EGSPC.

1. Compute the daily rates of return.

2. Compute the average rates of return and risk of portfolios that combine INTC and the S&P 500 in the following proportions: (0.0,1.0), (0.2,0.8), (0.4,0.6), (0.6,0.4), (0.8,0.2), (1.0,0.0). Then plot them against one another. What does the plot look like?

3. Compute the historical market beta of Intel.