Details: Read in the Price and Volume Excel sheets. On you price data, decide on three companies that you want to work with. Create a new variable Price_Change to reflect the closing price minus the opening price. Create a new variable Percent_Change to reflect the Price_Change divided by the Open price. Format this new variable percent7.2. Generate a PDF list data report in the Journal format containing Company, Date, Open, Close, Price_Change and Percent_Change - in that order. Generate a PDF summary statistics report for Percent_Change for each company including only the mean, minimum, maximum, median and standard deviation. Create a line chart of the Close price by company over time. All companies should be on the same graph, each represented by its own respective line. Be sure to include a legend. Deliverables: - Submit an Enterprise Guide Project (.egp file) including all of your steps. The project should run start to finish and not include any unnecessary steps. - Create appropriate titles and footnotes for the listing report, summary statistics report and line chart. - Rename task nodes to be descriptive of what they are accomplishing. -Submit a screenshot of the process flow and the pdf copies generated.
... View more