Use the data from the previous Golf/Stock price study.

You will probably want to assemble yourself a basic codebook on the data set.  The data set contains some constructed variables as well as raw data gathered from several sources.  Plus expanded and updated golf scores on a lot more companies, using 2004 data from Golf Digest.

There are 22 performance measures taken from the S&P 500 report

Company performance:  RankInIndustry_04, OverallSP500Rank_04 , MarketValue, MvOneYearTotalReturn, MvThreeYearTotalReturn, Sales, SalesChangeFrom2002, Sales3YrAverageChange, Profitability, ProfitChangeFrom2002 , Profit3YrAverageChange

Market assessmenmt:  Net_Margin_2003,  Net_Margin_2002,  Return_On_Invested_Capital,  Return_On_Common_Equity,  Recent_Share_Price,  12_Month_High,  12_Month_Low,  P-E_Ratio,  Dividend_Yield,  _Earnings_Per_Share_2003,  Estimated_Earnings_Per_Share_2004

1. As always, the first step is to form a basic understanding of the data and the relationship to it through appropriate descriptive statistics and frequency tabulations.
2. Is there anything odd or noteworthy about these descriptive statistics? 3.
3. Create scatterplots for some of the different performance measures (NOT all 22 -- pick a few and say why you think they're the most applicable) RankInIndustry_04 to Estimated_Earnings_Per_Share_2004 against Handicap_04.
4. Anything interesting in these plots?
5. Following the procedures described in Presentation 8, create a correlation matrix summarizing the various correlations among the performance measures and golf measures.
6. What is the strongest correlation?  The weakest?  Are any of the correlations statistically significant?  Are there any that are statistically significant that seem to you to be not significant in practical terms?
7. Following the procedures described in Presentation 9, create regression analyses: each of your selected dependent variables (the performance measures -- again, NOT all 22!) to be predicted by the independent variable (Handicap_04).
8. What do these analyses tell you that the correlation matrix does not, particularly about effect sizes?
9. Conduct one other analysis of your choice on these data - explore something that interests you (note that there are variables in the data set that relate to things other than golf).  Explain what you did, and why you did it.
10. Present your findings and interpret your results.
11. As usual, transfer your output to Word ^® and format it in an appropriate manner.
12. Conclude your report with a couple of paragraphs or so of analysis, in which you provide an overall interpretation of your data analysis and draw conclusions of appropriate scope about its value and applicability.

Price: $19.76

Solution: The downloadable solution consists of 12 pages, 776 words and 16 charts.
Deliverable: Word Document