Oil vs Dollar Value
Data Sources
This file is maintained by the Team Oil vs Dollar group for the purpose of calculating the correlation between oil prices and the U.S. dollar value. The correlation between oil prices and the value of the dollar will also examine how external factors such as elections, natural disasters and pandemics will impact oil prices and by association, the value of the dollar.
Machine Learning: https://github.com/skotagiri95/Oil-and-Dollar-Value-Analysis-/tree/master/LINEAR%20REGRESSION_OIL
Master Brach Braches: Sheela - Sheela Kotagiri Role: Square Rita - Rita Ramos Role: Triangle Juan - Juan M. Pacheco Nájar https://github.com/skotagiri95/Oil-and-Dollar-Value-Analysis-/tree/Juan
Role: Circle
Repository: https://github.com/skotagiri95/Oil-and-Dollar-Value-Analysis-/ README.MD
Google Slides Presentation: https://docs.google.com/presentation/d/16hNtvrhtdxZFnWzaExROaLSNE727WatZV_IeYfpbAK0/edit#slide=id.g76e9fc699e_0_0
Data Sources:
-
Energy Information Administration http://www.eia.gov/oil_gas/petroleum/data_publications/wrgp/mogas_history.html Data 4: Midgrade Conventional
-
US Dollar Index 43 years "www.macrotrends.net".
-
WTI Crude Oil Prices - 10 Year Daily Chart "www.macrotrends.net".
-
Standard and Poor's (S&P) 500 Index Data DataHub.io https://datahub.io/collections/stock-market-data
-
Harvard Business School https://www.hbs.edu/behavioral-finance-and-financial-stability/data/banking-system/Pages/default.aspx Global Financial Crisis
Using join to query data in the tables, analysis
Entity Relashionship Diagram (ERD)
Segment 2: Dashboard: https://github.com/skotagiri95/Oil-and-Dollar-Value-Analysis-/blob/master/UCB%20SEGMENT%202-Oil%20and%20Dollar%20Value%20Analysis%20Dashboard.pdf
Weekly Oil vs Gasoline Linear Regresion Model https://github.com/skotagiri95/Oil-and-Dollar-Value-Analysis-/blob/master/LINEAR%20REGRESSION_OIL/OIL%20ML-Weekly.ipynb
Tableau Oil vs Gasoline Linear Regresion Dashboard interactive on Month and Year
Oil Analysis Public Link
\Resources\Tableau Oil Analysis Dashboard.png
https://public.tableau.com/views/OilAnalysis_15884725810310/Dashboard?:display_count=y&publish=yes&:origin=viz_share_link
Describe Trend Line
\Resources\Describe Oil Trend Model.png
Describe Model Line
\Resources\Describe Oil TrendLine.png
