The file DJIA Monthly Close.xlsx contains monthly values of the Dow Jones Industrial Average from1950 through 2009.

Question:

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.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Data Analysis and Decision Making

ISBN: 978-0538476126

4th edition

Authors: Christian Albright, Wayne Winston, Christopher Zappe

Question Posted: