Part A (Group Work: 2 + 2 + 2 + 2 + 4 + 3 + 3 + 4 = 22 marks; professional report = 8 marks) Locate the data file (Assignment Bus Stats.xls) on...

Part A (Group Work: 2 + 2 + 2 + 2 + 4 + 3 + 3 + 4 = 22 marks; professional report = 8 marks) 

Locate the data file (Assignment Bus Stats.xls) on CANVAS. 

1.     Using the most appropriate type of graph to present weekly closing price of the Bitcoin and provide a general description.  Hint: What are the main features of this graph, is there a trend? [Topic 1]                                  

2.    Calculate the weekly return and construct a histogram. Does the data appear normally distributed?   Is there evidence of outliers?  Hint: the formula for a return is (Current Price - Previous price)/Previous price multiplied by 100  [Topics 1-3]                                                          

3.