Coursework and mini project (25%)
Question:
Obtain open data via online database in your majoring field (business / accounting / finance / economic related data) consists of TWO independent variable and ONE dependent variable. The data must contains at least 40 set observations. (Eg: x1 = Weight (kg), x2 =Height, y = calories intake)
Task assigned:
Question 1
Find the mean, median, mode and standard deviation for each independent variables and dependent variable. Hence, interpret each of the answer accordingly.
(24 marks)
Question 2
Obtain the regression analysis between the variables using excel and interpret the summary table, fitted line plot and normal probability plot.
(28 marks)
Question 3
a) Find the correlation for each independents and dependent. Interpret the results obtain.
(20 marks)
b) Consider evaluating whether or not a linear relationship exists between the independent and dependent variable. Using the t-test for testing the existence of a linear relationship by two tail test of correlation coefficient. (manual working only)
(16 marks)
Question 4
Obtain and interpret bar chart graph for each variable using excel only.
(12 marks)
(Total: 100 marks)
Note:
Question 1 and 3(a) should use manual and excel command calculation.
Refer Appendix 1 for the remaining marks allocation.
The total marks for this assignment is 100% but it carries 25% of overall assessment for this module.
- The detailed marking criteria’s for the allocation of 100 marks is provided in Appendix 1
LENGTH REQUIRED
1500 words +/- 10%. Any deviation from this will be penalized.
FORMATTING AND LAYOUT
• A Microsoft Office Word Document or other relevant applications as permitted by module lecturer/ typed using computer. Usage of typewriter or hand - written is STRICTLY not allowed.
• 12 font size, Time New Roman font and bold title and sub titles
• A4 sized paper
• Fully justified alignment
• 1½ line spacing
• Margins of 1” at top and bottom; left and right
Appendix 1: Marking Criteria for Coursework and Mini Project (25%)
No.
Assessment Criteria Weightage Marks Allotted by Lecturer
Questions
1
Manual calculation for mean, median, mode and standard deviation
24%
Excel calculation for mean, median, mode and standard deviation and comment 12%
2 Interpret the summary table, fitted line plot and normal distribution curve (Excel working)
16%
3(a) Find the correlation between two different correlation (manual calculation)
12%
Interpret the correlation from excel calculation
8%
3(b) t-test by one tail test of correlation coefficient
16%
4 Obtain and interpret bar graph for each variable
12%
Sample Solution