Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

QSM 2463

Quantitative & Statistical Method

COURSEWORK QUESTION

Coursework and mini project (25%)

Question:

Obtain an open data via online database in regards to your majoring field (business/accounting/finance/economic). Data must consists of TWO independent variable and ONE dependent variable. It must also contains at least 40 set observations. (Eg: x₁ = Weight (kg), x₂ =Height, y = calories intake, of 40 patients)

Task assigned:

Question 1

Calculate 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 descriptive statistics, correlation matrix and regression analysis between the variables using excel and interpret the descriptive statistics, correlation matrix, summary table, fitted line plot and normal probability plot.  (28 marks)

Question 3

a) Compute a regression for each independent variable separately. 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 polygon/histogram/line chart graph for each variable using excel only. (12 marks)

          (Total: 100 marks)

Note:

Question 1 and 3(a), students 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

1500 words +/- 10%.  Any deviation from this will be penalized.

· 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%)