ons s for Success Select a publicly traded company that trades on the NYSE or NASDAQ. Using AT LEAST three years worth of data, import their stock closing prices into Excel. Also import the closing prices of something that represents the market. (This should probably be something that represents the performance of the NASDAQ or NYSE, depending on which market your stock trades in). Calculate the monthly return for both the stock and the market. Create an XY scatter plot with the market return on the horizontal axis, and the stock return on the vertical axis. Fit a linear trendline to the data, and display the equation fr that trendline ents nd 3 Once you've created the chart, please answer the following questions: 1. From your graph, determine what the beta is for your stock. 2. How does your calculation compare to the published beta? 3. Why is your beta similar to, or different from the published values? 4. What is the y-intercept on your chart? 5. What does this value represent, and what does it mean to us? ons s for Success Select a publicly traded company that trades on the NYSE or NASDAQ. Using AT LEAST three years worth of data, import their stock closing prices into Excel. Also import the closing prices of something that represents the market. (This should probably be something that represents the performance of the NASDAQ or NYSE, depending on which market your stock trades in). Calculate the monthly return for both the stock and the market. Create an XY scatter plot with the market return on the horizontal axis, and the stock return on the vertical axis. Fit a linear trendline to the data, and display the equation fr that trendline ents nd 3 Once you've created the chart, please answer the following questions: 1. From your graph, determine what the beta is for your stock. 2. How does your calculation compare to the published beta? 3. Why is your beta similar to, or different from the published values? 4. What is the y-intercept on your chart? 5. What does this value represent, and what does it mean to us