The 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 changes into six categories: Large negative (< -3%), Medium negative (< -1%, ≥ -3%), Small negative (<0%, ≥ -1%), Small positive (<1%, ≥ 0%), Medium positive (<3%, ≥1%), and Large positive (≥3%). Then create a column chart of the counts of this categorical variable. Comment on its shape.
Answer to relevant QuestionsThe file S02_06.xlsx lists the average time (in minutes) it takes citizens of 379 metropolitan areas to travel to work and back home each day.a. Create a histogram of the daily commute times.b. Find the most representative ...The file S02_11.xlsx contains data on 148 houses that were recently sold in a (fictional) suburban community.The data set includes the selling price of each house, along with its appraised value, square footage, number of ...The file S02_21.xlsx contains monthly interest rates on 30-year fixed-rate mortgages in the United States from 1977 to 2009. The file also contains rates on15-year fixed-rate mortgages from late 1991 to 2009. What ...There is no consistent way of defining an outlier that everyone agrees upon. For example, some people refer to an outlier that is any observation more than three standard deviations from the mean. Other people use the box ...The Wall Street Journal CEO Compensation Study analyzed CEO pay from many U.S. companies with fiscal year 2008 revenue of at least $5 billion that filed their proxy statements between October 2008 and March 2009. The data ...
Post your question