Create a summarized price and price movement by year

Assignment Help Database Management System

Reference no: EM132239001

Data Science Project -

Provide the analysis based on the instructions below.

1) Use a SQL database, R, Python, Excel, or any tool of your choosing to complete the analysis.

2) The analysis should include insights as slides in a Keynote, PowerPoint, PDF or similar document.

3) Please share the code work as well (i.e. SQL code, R script, Python code, etc.).

4) Please include a slide that explains your process and where you spent your time.

Answer the following Questions:

1. Find 5 insights/observations from the data.

2. Identify some possible link between the price of the petroleum products and external factors. Explain your observation.

3. Create column to find price changes month over month.

4. Create a summarized price and price movement by year.

5. Predict the crude oil price for next 6 months.

6. Identify the correlation between Conventional Gasoline prices between New York Harbor and U.S. Gulf Coast.

7. Is there a month/quarter/year where prices of all Products were lower than prior data points?

Attachment:- Assignment Files.rar

Reference no: EM132239001

Questions Cloud

Do you think there is anything else the nypd could add : Which units within the NYPD would you consider operational, and which are administrative?Do you think any of the units or assignments are unnecessary?

Explain the influence of organizational buyer segments : Explain the influence of organizational buyer segments on marketing strategy. In your discussion, provide an example of how your organization

Price of the company stock today : What should be the price of the company's stock today (December 31, 2017)? Round your answer to the nearest cent. Do not round intermediate calculations.

Foreign markets entry decision for singaporean firm : What is the nature of the product: brand new high technology consisting of a computerized CAD system.

Create a summarized price and price movement by year : Use a SQL database, R, Python, Excel, or any tool of your choosing to complete the analysis. Create a summarized price and price movement by year

Set aside in real terms at the end : How much does Bart need to set aside in real terms at the end of each of the next 46 years to meet his retirement goal?

Describe attributes of activity performance measurement : Describe three attributes of Activity Performance Measurement.

Compute the price per share of widget stock : Based on this information, compute the price per share of Widget stock.

Cataloged and entered into video database. : A Video Store runs series of fairly standard DVD video stores. Before a video can be put on shelf, it must be cataloged and entered into video database.

User Account

All Pages