Step 1: Collect the Data
Randomly select 30 companies listed on the NASDAQ. Make sure that 10 of the companies are “technology” companies; 10 are “transportation” companies; and 10 are “energy” companies. For each company, measure the percent increase in closing price from the first trading day of last year to the first trading day of this year. The percent increase is defined as the raw increase divided by the initial price.
Sector | Symbol | Start | End | % increase |
---|---|---|---|---|
Technology | ANET | 101.28 | 235.58 | 132.603 |
ASUR | 9.37 | 14.89 | 58.911 | |
BKYI | 2.65 | 1.77 | -33.208 | |
BRKS | 16.86 | 23.85 | 41.459 | |
CCMP | 63.79 | 94.08 | 47.484 | |
Transportation | KNX | 33.05 | 43.72 | 32.284 |
CSX | 37.52 | 57.72 | 53.838 | |
DAL | 49.68 | 56.00 | 12.721 | |
HA | 55.50 | 39.10 | -29.550 | |
KSU | 83.81 | 109.19 | 30.283 | |
Energy | CVX | 117.70 | 127.90 | 8.666 |
XEC | 135.90 | 127.82 | -5.946 | |
CRK | 10.50 | 8.46 | -19.429 | |
CRT | 17.97 | 14.69 | -18.253 | |
DWSN | 7.66 | 4.73 | -38.251 |
As an example, here is a data table for my selection of 15 companies You will, of course, sample 30 companies.
Step 2: Analyze the Data
Now that you have collected the data, analyze it. Determine if one of the three sectors has a significantly different return on investment (% increase) than the others… and in which direction.
To do this, make sure you use several appropriate post hoc analyses. Since they were covered in class, I expect you to at least use Fisher’s LSD, Tukey’s HSD, Scheffe’s, and Student-Newman-Keuls multiple comparisons tests.
Draw your conclusions from them as a whole.
Step 3: Illustrate the Data
Use a graphic to illustrate your conclusions. Here is a basic, utilitarian graphic. It is definitely not optimal. In fact, you may want to include several graphics in your submission, making sure you explain each graphic.
Step 4: The Warning
Note: Doing only what is requested above will net you — at most — 80%. The more you add to this assignment, the higher your possible grade. Use this final assignment as your opportunity to show off all you have learned during this course. This includes showing off how you can extend analyses covered in class and explain the statistics underlying those tests.