Assignment 2013
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 is related with the direct marketing campaign of a Portuguese banking institution. The bank was making a promotion on the product, bank term deposit, to some potential clients. The marketing campaigns were based on phone calls. Often, more than one contact was made to the same clients. The strategy was decided in order to access if the product would be or would not be subscribed by clients.
[Refer to S. Moro, R. Laureano and P. Cortez. Using Data Mining for Bank Direct Marketing: An Application of the CRISP-DM Methodology. In P. Novais et al. (Eds.), Proceedings of the European Simulation and Modelling Conference - ESM '2011, pp. 117-121, Guimaraes, Portugal, October, 2011. EUROSIS.]
2. Task
Imagine that you are the new Marketing Manager whom is responsible to promote the product, bank term deposit. You are instructed by your immediate superior to study the data and to recognize the followings:
i) The criteria among clients who subscribed the product, and do not subscribed the product. ii) The effectiveness of the promotion. iii) The general acceptance towards the new product.
3. The variables
The variables listed in “bankdata.xls” are:
A. Number of clients
# Related with clients’ background
B. age: clients’ age in year
C.
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 is related with the direct marketing campaign of a Portuguese banking institution. The bank was making a promotion on the product, bank term deposit, to some potential clients. The marketing campaigns were based on phone calls. Often, more than one contact was made to the same clients. The strategy was decided in order to access if the product would be or would not be subscribed by clients.
[Refer to S. Moro, R. Laureano and P. Cortez. Using Data Mining for Bank Direct Marketing: An Application of the CRISP-DM Methodology. In P. Novais et al. (Eds.), Proceedings of the European Simulation and Modelling Conference - ESM '2011, pp. 117-121, Guimaraes, Portugal, October, 2011. EUROSIS.]
2. Task
Imagine that you are the new Marketing Manager whom is responsible to promote the product, bank term deposit. You are instructed by your immediate superior to study the data and to recognize the followings:
i) The criteria among clients who subscribed the product, and do not subscribed the product. ii) The effectiveness of the promotion. iii) The general acceptance towards the new product.
3. The variables
The variables listed in “bankdata.xls” are:
A. Number of clients
# Related with clients’ background
B. age: clients’ age in year
C.