You are required to collect the total expenses per month for ten consecutive months. This can be easily done using your online/paper bank

You are required to collect the total expenses per month for ten consecutive months. This can be easily done using your online/paper bank

Assignment brief:

You are required to collect the total expenses per month for ten consecutive months. This can be easily done using your online/paper bank statements. Once you have collected the data for ten months, you are required to prepare a report undertaking followings:

1. Arrange the data in a table format. (5 marks)

2. Present the data using any two types of charts of your choice. Example: Column chart, bar chart, scatter plot, line chart etc. (10 marks)

3. Calculate and discuss the followings. Please provide the steps for the calculation and highlight the final value.

  1. Mean                           (8 marks)
  2. Median                        (8 marks)
  3. Mode                           (8 marks)
  4. Range                          (8 marks)
  5. Standard Deviation     (13 marks)

4. For your data, use the linear forecasting model which is y = mx + c to calculate and discuss the followings:

  1. Show the steps of calculation of m value and discuss the answer.   (15 marks)
  2. Show the steps of calculation of c value and discuss the answer.     (15 marks)
  3. Using the calculated ‘m’ and ‘c’ values, forecast the total expenditure for month 11 and month 12.  (10 marks)

Answer preview for You are required to collect the total expenses per month for ten consecutive months. This can be easily done using your online/paper bank

APA

850 Words