Question: The file S03 63 xlsx contains financial data on 85 U S companies
The file S03_63.xlsx contains financial data on 85 U.S. companies in the Computer and Electronic Product Manufacturing sector (NAICS code 334) with 2009 earnings before taxes of at least $10,000. Each of these companies listed R&D (research and development) expenses on its income statement. Create a table of correlations between all of the variables and use conditional formatting to color green all correlations involving R&D that are strongly positive or negative. Then create scatter plots of R&D (Y axis) versus each of the other most highly correlated variables. Comment on any patterns you see in these scatter plots, including any obvious outliers, and explain why (or if) it makes sense that these variables are highly correlated with R&D. If there are highly correlated variables with R&D, can you tell which way the causality goes?
Answer to relevant QuestionsThe file S03_64.xlsx lists monthly data since 1950 on the well-known Dow Jones Industrial Average (DJIA), as well as the less well-known Dow Jones Transportation Average (DJTA) and Dow Jones Utilities Average (DJUA). Each of ...The term “churn” is very important to managers in the cellular phone business. Churning occurs when a customer stops using one company’s service and switches to another company’s service. Obviously, managers try to ...In a large accounting firm, the proportion of accountants with MBA degrees and at least five years of professional experience is 75% as large as the proportion of accountants with no MBA degree and less than five years of ...The National Football League playoffs are just about to begin. Because of their great record in the regular season, the Colts get a bye in the first week of the playoffs. In the second week, they will play the winner of the ...The possible annual percentage returns of the stocks of Alpha, Inc. and Beta, Inc. are distributed as shown in the file S04_24.xlsx.a. What is the expected annual return of Alpha’s stock?What is the expected annual return ...
Post your question