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
- Number of Employee 1. Revenues / Sales
- Corporate Social Responsibility Expenses 2. Profits
- Research & Development Expenses
- Assets
- Liabilities
By using the data, you are required to: - Show raw data in appropriate table.
- Construct a Frequency Table of the dependent variable, using a maximum of 6 groups.
- Prepare descriptive analyses of the independent and dependent variable by using Microsoft
Excel which include:
Mean
Median,
Mode
Variance
Standard deviation - By using Mean, Median and Mode values, determine the types of distribution independent and
dependent variables. - Prepare correlation and regression analyses by using Microsoft Excel which include:
- 1. Identify the coefficient of correlation (r) value.
- Plot scatter graph.
- Based on the findings in (a) and (b), identify the relationship between independent and
dependent variable. - Identify the value of the slope of the regression line (m)?
- Identify the value of the intercept of the regression line (c)?
- State the regression equation for the model.
- 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 - 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: - Show raw data in appropriate table.
- Identify the components involved in time series analysis.
- By using Microsoft Excel, identify trend and seasonal components.
- Forecast the Sales / Revenue for a following year.
(35 marks)
Task 1c – LO 1, LO 2, LO 3
You are required to: - 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 - Choose a discount rate within 1% to 20%.
- Conduct investment appraisal techniques by using Microsoft Excel, which include:
Net Present Value
Average Rate of Return
Internal Rate of Return
Payback Period - 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 - Number of Employee 1. Revenues / Sales
- Corporate Social Responsibility Expenses 2. Profits
- Research & Development Expenses
- Assets
- Liabilities
By using the data, you are required to: - Show raw data in appropriate table.
- Construct a Frequency Table of the dependent variable, using a maximum of 6 groups.
- Prepare descriptive analyses of the independent and dependent variable by using Microsoft
Excel which include:
Mean
Median,
Mode
Variance
Standard deviation - By using Mean, Median and Mode values, determine the types of distribution independent and
dependent variables. - Prepare correlation and regression analyses by using Microsoft Excel which include:
- Identify the coefficient of correlation (r) value.
- Plot scatter graph.
3/5/2021 010 COMPUTER BASED ASSIGNMENT
https://canvas.anglia.ac.uk/courses/19774/assignments/131299 6/7 - Based on the findings in (a) and (b), identify the relationship between independent and
dependent variable. - Identify the value of the slope of the regression line (m)?
- Identify the value of the intercept of the regression line (c)?
- State the regression equation for the model.
- Identify the coefficient of determination (r ) value and comments.
- 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: - Show raw data in appropriate table.
- Identify the components involved in time series analysis.
- By using Microsoft Excel, identify trend and seasonal components.
- Forecast the Sales / Revenue for a following year.
(35 marks)
Task 1c – LO 1, LO 2, LO 3
You are required to: - 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
- Choose a discount rate within 1% to 20%.
- Conduct investment appraisal techniques by using Microsoft Excel, which include:
Net Present Value
Average Rate of Return
Internal Rate of Return
Payback Period - Compare and contrast the projects. In a case of mutually exclusive projects, identify the best project to be chosen with justification.