The file S02_04.xlsx contains salary data on all Major League Baseball players for each year from 2002 to2009. For each year, create a table of counts of the various positions, expressed as percentages of all players for the year. Then create a column chart of these percentages for each year. Do they remain fairly constant from year to year?
Answer to relevant QuestionsThe file DJIA Monthly Close.xlsx contains monthly values of the Dow Jones Industrial Average from1950 through 2009. It also contains the percentage changes from month to month. Create a new column for recoding the percentage ...The file S02_10.xlsx contains midterm and final exam scores for 96 students in a corporate finance course.a. Create a histogram for each of the two sets of exam scores.b. What are the mean and median scores on each of these ...The Consumer Confidence Index (CCI) attempts to measure people’s feelings about general business conditions, employment opportunities, and their own income prospects. Monthly average values of the CCI are listed in the ...The file S02_28.xlsx contains total monthly U.S. retail sales data for a number of years. There are really two series, one of actual sales and one of seasonally adjusted sales. The latter adjusts for any possible ...The file S02_39.xlsx contains SAT test scores (two verbal components, a mathematical component, and the sum of these three) for each state and Washington DC in 2009. It also lists the percentage of high school graduates ...
Post your question