Sign Up
View All Projects
Correlation Analysis
Julia Maja
Data Analyst
Microsoft Excel
Analyzed monthly data from Bloomberg spanning 10 years (July 2012 to June 2022) to determine the correlation between Exxaro Ltd.’s share price and coal prices, USD/ZAR exchange rates.
• Hypotheses: H0 (No correlation), H1 (Positive correlation), H2 (Negative correlation).
• Executed statistical techniques, including Pearson correlation and simple linear regression.
• Identified a moderate positive correlation (r = 0.55) between Exxaro Ltd.’s share price and coal prices.
• Supported H1 with evidence that higher coal prices correspond to increased share prices.
• Regression analysis reinforced findings with positive coal/ZAR coefficient (0.026) and negative USD/ZAR coefficient (-6.56).
Results: Showcased a statistically significant correlation, rejecting H0 and providing evidence against H2, suggesting a negative correlation.
Partner With Julia
View Services
More Projects by Julia
Exploratory Data Analysis
Financial Analysis and Market Trends
How it Works
Contra For Independents
Contra For Hiring
Success Stories
Commission-Free
Company
Mission
Careers
Newsroom
Resources
FAQ
Tips & Guides
Hire
Support
Dіscover Freelancers
Design
Engineering
Marketing
Music & Audio
Social Media
Video & Animation
Writing
Drops
Freelance Industry Report
Social
Terms & Conditions
Privacy Policy
Cookie Policy
© 2024 Contra.Work Inc All Rights Reserved.