COMPUTER BASICS

https://canvas.anglia.ac.uk/courses/19774/assignments/131299 1/7
Check your results on evision (https://e-vision.anglia.ac.uk/) Analysis)
Task 1a – LO 1, LO 2, LO 3
You are required to choose any time series data of any company for 10 years from reliable
sources such as company annual report. The data must consist of two variables (Independent and
Dependent variables). Student may choose any variable from list below:
https://canvas.anglia.ac.uk/courses/19774/assignments/131299 2/7
Independent Variable Dependent Variable

  1. Number of Employee 1. Revenues / Sales
  2. Corporate Social Responsibility Expenses 2. Profits
  3. Research & Development Expenses
  4. Assets
  5. Liabilities
    By using the data, you are required to:
  6. Show raw data in appropriate table.
  7. Construct a Frequency Table of the dependent variable, using a maximum of 6 groups.
  8. Prepare descriptive analyses of the independent and dependent variable by using Microsoft
    Excel which include:
    Mean
    Median,
    Mode
    Variance
    Standard deviation
  9. By using Mean, Median and Mode values, determine the types of distribution independent and
    dependent variables.
  10. Prepare correlation and regression analyses by using Microsoft Excel which include:
  11. 1. Identify the coefficient of correlation (r) value.
  12. Plot scatter graph.
  13. Based on the findings in (a) and (b), identify the relationship between independent and
    dependent variable.
  14. Identify the value of the slope of the regression line (m)?
  15. Identify the value of the intercept of the regression line (c)?
  16. State the regression equation for the model.
  17. Identify the coefficient of determination (r ) value and comments.
    2
    3/5/2021 010 COMPUTER BASED ASSIGNMENT
    https://canvas.anglia.ac.uk/courses/19774/assignments/131299 3/7
  18. Forecast a value of dependent variable with an assumption value of independent variable.
    (35 marks)
    Task 1b – LO 1, LO 2, LO 3
    You are required to choose any time series data of any company for 3 consecutive years from
    reliable sources such as company annual report. The data is Sales / Revenue and must
    be quarterly data.
    By using the data, you are required to:
  19. Show raw data in appropriate table.
  20. Identify the components involved in time series analysis.
  21. By using Microsoft Excel, identify trend and seasonal components.
  22. Forecast the Sales / Revenue for a following year.
    (35 marks)
    Task 1c – LO 1, LO 2, LO 3
    You are required to:
  23. Complete the project cash flow in table A with maximum of 6 years by an assumption.
    Year Cash Flow Project A (RM) Cash Flow Project B (RM)
    0 – 22 000 – 30 000
    1 1200 2000
    3/5/2021 010 COMPUTER BASED ASSIGNMENT
    https://canvas.anglia.ac.uk/courses/19774/assignments/131299 4/7
    Table A: Cash Flow
  24. Choose a discount rate within 1% to 20%.
  25. Conduct investment appraisal techniques by using Microsoft Excel, which include:
    Net Present Value
    Average Rate of Return
    Internal Rate of Return
    Payback Period
  26. Compare and contrast the projects. In a case of mutually exclusive projects, identify the best
    project to be chosen with justification.
    (30 marks)
    Assignment Created 23 Jul 2019 15:25:20
    Module Code: MOD001021 Level: 4
    Academic Year: 2019/20 Trimester: 2
    Module Leader: Naowarat Lewis
    Assessment Element: 010 Assignment – Computer based element (50%)
    Submission Date: Check your evision. This assignment must be submitted via Turnitin
    GradeMark (see module guide on VLE for further information) by no later than 2pm of your
    submission date via evision.
    Report must be submitted in Microsoft Word together with MS Excel (Data
    Analysis)
    Task 1a – LO 1, LO 2, LO 3
    3/5/2021 010 COMPUTER BASED ASSIGNMENT
    https://canvas.anglia.ac.uk/courses/19774/assignments/131299 5/7
    You are required to choose any time series data of any company for 10 years from reliable
    sources such as company annual report. The data must consist of two variables (Independent and
    Dependent variables). Student may choose any variable from list below:
    Independent Variable Dependent Variable
  27. Number of Employee 1. Revenues / Sales
  28. Corporate Social Responsibility Expenses 2. Profits
  29. Research & Development Expenses
  30. Assets
  31. Liabilities
    By using the data, you are required to:
  32. Show raw data in appropriate table.
  33. Construct a Frequency Table of the dependent variable, using a maximum of 6 groups.
  34. Prepare descriptive analyses of the independent and dependent variable by using Microsoft
    Excel which include:
    Mean
    Median,
    Mode
    Variance
    Standard deviation
  35. By using Mean, Median and Mode values, determine the types of distribution independent and
    dependent variables.
  36. Prepare correlation and regression analyses by using Microsoft Excel which include:
  37. Identify the coefficient of correlation (r) value.
  38. Plot scatter graph.
    3/5/2021 010 COMPUTER BASED ASSIGNMENT
    https://canvas.anglia.ac.uk/courses/19774/assignments/131299 6/7
  39. Based on the findings in (a) and (b), identify the relationship between independent and
    dependent variable.
  40. Identify the value of the slope of the regression line (m)?
  41. Identify the value of the intercept of the regression line (c)?
  42. State the regression equation for the model.
  43. Identify the coefficient of determination (r ) value and comments.
  44. Forecast a value of dependent variable with an assumption value of independent variable.
    (35 marks)
    Task 1b – LO 1, LO 2, LO 3
    You are required to choose any time series data of any company for 3 consecutive years from
    reliable sources such as company annual report. The data is Sales / Revenue and must be
    quarterly data.
    By using the data, you are required to:
  45. Show raw data in appropriate table.
  46. Identify the components involved in time series analysis.
  47. By using Microsoft Excel, identify trend and seasonal components.
  48. Forecast the Sales / Revenue for a following year.
    (35 marks)
    Task 1c – LO 1, LO 2, LO 3
    You are required to:
  49. Complete the project cash flow in table A with maximum of 6 years by an assumption.
    Year Cash Flow Project A (RM) Cash Flow Project B (RM)
    0 – 11 000 – 20 000
    1 700 1000
    2
    3/5/2021 010 COMPUTER BASED ASSIGNMENT
    https://canvas.anglia.ac.uk/courses/19774/assignments/131299 7/7
    Points
    Submitting
    0
    Nothing
    Due For Available from Until
  • Everyone – –
    Table A: Cash Flow
  1. Choose a discount rate within 1% to 20%.
  2. Conduct investment appraisal techniques by using Microsoft Excel, which include:
    Net Present Value
    Average Rate of Return
    Internal Rate of Return
    Payback Period
  3. Compare and contrast the projects. In a case of mutually exclusive projects, identify the best project to be chosen with justification.

This question has been answered.

Get Answer