Limited Offer Get 25% off — use code BESTW25
No AI No Plagiarism On-Time Delivery Free Revisions
Claim Now
Prices start at $5 per page · plagiarism-free papers · free revisions for 14 days 24/7 support: support@bestwriters.com
Uncategorized

Business Statistics and Data Analysis

  • Posted
  • Authoradmin
  • Length342 words
  • Reading time2 min
Write My Assignment FREE

FIND A SOLUTION  AT  Academic Writers Bay

Major Assignment – Marks -(20) Due week 10
CookMyProject
This assignment will require you to source the share price movements for Five(5) listed companies, graph and statistically analyse the companies and compare your portfolio of five shares to the ASX200.
1- Select 5 companies listed on an International Stock Exchange.
a) One ASX Bank
b) One ASX Mining Company
C) One ASX Food and Staples ie Wooworths
d) One International Share
e) One company you have a particular interest in
2-Write a one paragraph, brief description for each company, At least covering the company’s main activities, Its size (Capital and Total Assets). For the company that you have an interest in,write half a page, explaining why this business is interesting to you.
3- Using “Yahoo Finance”, download to an Excel Spreadsheet the month end share price for each share, for the last five years. ie 60 data points per company.Plus, for the same time period, the ASX200 month end data.
4-Using the first month as the base, calculate the percentage (%) charges each month, for each share and the ASX200.
5- Graph all the percentage data on one graph, ie5 shares and the ASX200.
6- If, 5 Years ago, you invested $100000 evenly ($20000/share) into a portfolio, what would your portfolio be worth now? Calculate and show this on your spreadsheet.
7- Then create another graph comparing the 5 year monthly portfolio charges against the ASX200. Did your portfolio do better than the ASX200 Index?
8- Using Excel, calculate the Standard Deviation and Mean for each share, Your portfolio and the ASX200. Explain what the Standard Deviations are telling you about risk?
Assume you will be presenting your results to management, in a report.
Marks will be awarded for;
1- Overall quantity and presentation of your report to management.
2- Quality of definitions and written analysis
3- Use of Excel Functions,
4 Qualty and Presentation of Graphs.
5- Accuracy.
Marks will be deducted for late submissions.

  • Assignment status: Already Solved By Our Experts
  • (USA, AUS, UK & CA  PhD. Writers)

QUALITY: 100% ORIGINAL PAPER – NO PLAGIARISM – CUSTOM PAPER

Plagiarism Free Assignment Help

Expert Help With This Assignment — On Your Terms

✓ Native UK, USA & Australia writers ✓ Deadline from 3 hours ✓ 100% Plagiarism-Free — Turnitin included ✓ Unlimited free revisions ✓ Free to submit — compare quotes

admin

Academic writer and editor at BestWriters.

Get your paper off your plate tonight

Post your instructions for free. Prices start at $5 per page.

Place an order