preview

Assignment 2013

Better Essays

SQQS1033 DATA EXPLORATORY AND GENERALISATION
GROUP PROJECT (15%)
FIRST SEMESTER 2013/2014

INSTRUCTIONS

Instruction:
1. The total mark for this group assignment is 460 and it contributes about 15% of total evaluation of this course.
2. You are limited to use EXCEL to complete the given tasks.
3. You are required to answer all questions and to compile all the answers in a well prepared report.
4. Your report must begin with Page Title (List of group’s member, lecturer etc.), Answer for Questions (following orders of questions) and reference.
5. This assignment must be handed in BEFORE 5th December 2013 by 3.00pm. Any late submission will get mark 0.

Case study
Title: Bank Marketing

1. Background of the case study
This case study …show more content…

of variables) b) Construct a suitable graphical display for each qualitative variable that can answer the tasks are given by your immediate superior as below:

i) The criteria among clients who subscribed the product, and do not subscribed the product.

Division marks for each graphical display
Choose suitable variable to relate/compare with number of clients who subscribed the product. (2 mark)
Suitable graphical display for the variable (2 marks)
(4 marks no. of variables)

ii) The effectiveness of the promotion.

Division marks for each graphical display
Choose suitable variable that can show the effectiveness of the promotion (2 mark)
Suitable graphical display for the variable (2 marks)
(4 marks no. of variables)

iii) The general acceptance towards the new product.

Division marks for each graphical display
Choose suitable variable that can show the general acceptance towards the new product (2 mark)
Suitable graphical display for the variable (2 marks)
(4 marks no. of variables)

Question 3 (292 marks)

a) Based on data for each quantitative variable, compute the followings:
i) arithmetic mean, mode, median; (3 marks) ii) standard deviation; (1 mark) iii) skewness and kurtosis. (2 marks) iv) What would you recommend about the distribution of the data? (4 marks)

(hint: Do not use the build in function)
(10 marks no. of variables)

b) Construct a frequency distribution that summarizes

Get Access