# Question: Apple Dell IBM and Microsoft are well known in the

Apple, Dell, IBM, and Microsoft are well known in the computer industry. If the computer industry is doing well, then we might expect the stocks of all four to increase in value. If the industry goes down, we’d expect all four to go down as well. How strong is the association among these companies? After all, they compete in some areas. For example, Dell and IBM both sell powerful computer systems designed to power Web sites like Amazon or weather.com.

This data set has monthly returns for Apple, Dell, IBM, and Microsoft for January 1990 through September 2011 The returns are calculated as

Rt = Pt – Pt–1 / Pt–1

In this fraction, Pt is the price of the stock at the end of a month and Pt -1 denotes the price at the end of the prior month. If multiplied by 100, the return is the percentage change in the value of the stock during the month. The returns given here have been adjusted for accounting activities (such as dividend payments) that would otherwise produce misleading results. The data are from the Center for Research in Security Prices (CRSP), as are other stock returns used in this book.

Motivation

(a) Investors who buy stocks often buy several to avoid putting all their eggs into one basket. Why would someone who buys stocks care whether the returns for these stocks were related to each other?

(b) Would investors who are concerned about putting all their eggs into one basket prefer to buy stocks that are positively related, unrelated, or negatively related?

Method

(c) How can an investor use correlations to deter-mine whether these three stocks are related to each other? How many correlations are needed?

(d) Correlations can be fooled by patterns that are not linear or distorted by outliers that do not conform to the usual pattern. Before using correlations, how can the investor check the conditions needed for using a correlation?

(e) A key lurking variable anytime we look at a scatterplot of two time series is time itself. How can an investor check to see if time is a lurking factor when looking at stock returns?

Mechanics

(f) Obtain the scatterplots needed to see whether there are patterns that relate the returns of these stocks. Does it matter which stock return goes on the x-axis and which goes on the y-axis? Do you find that the returns are associated? Is the association linear?

(g) Obtain the correlation matrix that has all of the correlations among these four stocks.

(h) Look at timeplots of the returns on each stock. Why are these important when looking at time series?

Message

(i) Summarize your analysis of the association among these returns for an investor who is thinking of buying these stocks. Be sure to talk about stocks, not correlations.

This data set has monthly returns for Apple, Dell, IBM, and Microsoft for January 1990 through September 2011 The returns are calculated as

Rt = Pt – Pt–1 / Pt–1

In this fraction, Pt is the price of the stock at the end of a month and Pt -1 denotes the price at the end of the prior month. If multiplied by 100, the return is the percentage change in the value of the stock during the month. The returns given here have been adjusted for accounting activities (such as dividend payments) that would otherwise produce misleading results. The data are from the Center for Research in Security Prices (CRSP), as are other stock returns used in this book.

Motivation

(a) Investors who buy stocks often buy several to avoid putting all their eggs into one basket. Why would someone who buys stocks care whether the returns for these stocks were related to each other?

(b) Would investors who are concerned about putting all their eggs into one basket prefer to buy stocks that are positively related, unrelated, or negatively related?

Method

(c) How can an investor use correlations to deter-mine whether these three stocks are related to each other? How many correlations are needed?

(d) Correlations can be fooled by patterns that are not linear or distorted by outliers that do not conform to the usual pattern. Before using correlations, how can the investor check the conditions needed for using a correlation?

(e) A key lurking variable anytime we look at a scatterplot of two time series is time itself. How can an investor check to see if time is a lurking factor when looking at stock returns?

Mechanics

(f) Obtain the scatterplots needed to see whether there are patterns that relate the returns of these stocks. Does it matter which stock return goes on the x-axis and which goes on the y-axis? Do you find that the returns are associated? Is the association linear?

(g) Obtain the correlation matrix that has all of the correlations among these four stocks.

(h) Look at timeplots of the returns on each stock. Why are these important when looking at time series?

Message

(i) Summarize your analysis of the association among these returns for an investor who is thinking of buying these stocks. Be sure to talk about stocks, not correlations.

**View Solution:**## Answer to relevant Questions

Companies that manufacture products that conform to a unique specifcation for each order need help in estimating their own costs. Because each order is unique, it can be hard to know for sure just how much it will cost to ...As in Exercise 23, these scatterplots graph a sequence of observations taken under similar conditions. If we could watch these processes longer and longer and accumulate more data, in which cases would the Law of Large ...An airline would like to know the probability of a piece of passenger’s luggage weighing more than 40 pounds. To learn this probability, a baggage handler picks off every 20th bag from the conveyor and weighs it. Do you ...A survey found that 62% of callers in the United States complain about the service they receive from a call center if they suspect that the agent who handled the call is foreign.11 Given this context, what is the probability ...To boost interest in its big sale, a retailer offers special scratch-off coupons. When the shopper makes a purchase, the clerk scratches off the covering to reveal the amount of the discount. The discount is 10%, 20%, 30%, ...Post your question