Business Analytics -- 2

Use your datasheet attached to complete this assignment.

For the Stock Close and Financial data, complete the following techniques that were done in class. Create a new sheet named Stock Graphs for the Stock items, and a new sheet named Financial Graphs for the financial items.

Descriptive Analytics (Both columns (DJI and Stock) for Stock page and Rows for Financial Data)

Create a histogram for Stock Close Change and Dow Jones Close Change

Create a time sequence graph for Stock Close

Create a time sequence graph for each financial data row.

Complete any other techniques done during class.

For all the descriptive work done above, find 3 interesting items to discuss. At least 1 item must come from the stock data and 1 from the financial data. The 3rd item can come from either. For each point, do the following.

Insert the output graph and analytics table in your paper

Describe what you see and why it is interesting.

Perform the research to uncover why it happened. Be sure to cite your source.

Each item discussed is worth 15 points (refer to the rubric for details) for a total of 45 pts. The final 5 points are earned by going above and beyond (for example, fixing the data or continuing the analysis as to why the company acted to cause the point) or by doing more complex descriptive analysis.

Excel Word

Nº del proyecto: #9700293

Sobre el proyecto