Underlying correlation and regression analysis

Reference no: EM133325662

Case: You are working as junior analyst at Investment.Com and have been asked to undertake some analysis for the senior management team.

Gather historical data on price for a one-year period for an index and one stock of your choice (the equity should be traded on the index selected). This should be downloaded into Microsoft excel.

Carry out a preliminary analysis of the relationship between the stock price and the index using descriptive statistics.

Average price of index = 14366.58947

Average price of stock = 194.8259463
SD of index = 877.0389838
SD of stock = 58.37272886

Correlation = 0.728102076
Covariance = 0.000233851

Using correlation and regression analysis undertake a more detailed analysis of the relationship between the equity and the index.

Correlation = 0.728102076
Covariance = 0.000233851

Regression ----

y = 0.0623x - 699.62
R² = 0.8809

Provide a very in detailed account of the assumptions underlying correlation and regression analysis as well as their limitations in analysis for this task in a big brief and explain the given regression above by explaining the regression equation available.

Reference no: EM133325662

Questions Cloud

How could the instrument division be having a higher return : How could the instrument Division be having a higher return on capital and reducing value for the firm at the same time ( as felt by the activist investor

Explain the porter five forces model : In the AllDrinksSoft, what are the challenges that the company faces with its analytics rollout? How would you address and prioritize these challenges?

What price should goodcoffee inc. set for its new stock : the dividends will grow at a constant rate of 7% indefinitely. Investors require a 10% return from holding GoodCoffee stock and What price should GoodCoffee In

What is social engineering : List three best practices that you follow to prevent your computer from becoming a victim of a cyber attack? What is social engineering?

Underlying correlation and regression analysis : Provide a very in detailed account of the assumptions underlying correlation and regression analysis as well as their limitations in analysis for this task

What must the implied volatility of the european call be : Given a European call has the same non-dividend underlying stock, strike, and maturity, what must the implied volatility of the European call be

Write a code of volley library and add custom built-in apis : Write a code of Volley library and add custom/built-in API's to show the data and test the API's using API's tester (Postman).

How would prioritize the problems of food production : Should environmental concerns be an issue in meeting the immediate needs of starving people? Can this choice be avoided? Explain.

What is the cost of common equity : You have been provided with the following data: D0 = $0.85; P0 = $22.80; and g = 7.00% (constant). Based on the DCF approach, what is the cost of common equity

User Account

All Pages