How to solve the problem

[Mbaug]

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.

[ballardw · Accepted solution]

Which step are you having problems with?

   Describe what you have attempted and any result.