Statistical Programming

Assignment Brief

You are to create and critically evaluate a software tool in Python for the exploration and analysis of a dataset.

Task 1

A new bank has decided to give some of its best customers access to a new gold credit card. Receiving an offer for one of these cards is reliant on some criteria below. First, you are expected to show as much information about the data as possible and then show the clients that are eligible for the card.

The bank’s owners want you to show them (visualise) the data, you must use a variety of graphs to show and explain the data. This means finding as much information about the data as possible. This will be in the form of box plot averages, frequency tables, histograms etc. You must have a minimum of 10 visual aids describing different details of the data.

The next part of the program is to display information on the number of customers who are eligible for the gold card. The following criteria must be satisfied to be offered a card:

1.    Is_active = true

2.    Credit_product = true

3.    Avg_Account Balance must be greater than 8000000

4.    Occupation = Salaried

The bank also wants to understand the relationship between ages and the average amount of money in the account. Using linear regression, create a graph with a line of best fit. You must then predict the amount for each age: 30, 50 and 80 (using the line of best fit). Briefly describe what the line of best shows (500 words)

Notes:

·         The dataset is on Moodle (under the assessment tab) named: CreditCard.csv.

·         You will require a menu so the tasks can be separated (as a minimum: data visualisation, credit card acceptance and line of best fit).

·         You can group activities into multiple menus e.g., section 1 can include all graphs for the data

·         Additional formatting on visualisation will gain extra marks.

·         More complex visualisation methods will gain extra marks.

·         You are expected to use exception handling.

·         Add comments to your code.

·         All graphs must have an index and labels.

·         All the above must use Python only. You are not to use external programs or websites to create the data you present. Therefore, your Python must generate all of the above.

Task 2

You are to create a short report critically evaluating your created tool.

You should evaluate the effectiveness of your tool and how well it displayed the results. You should comment on improvements that can be backed up by research and examples.

The report should be no more than 1000 words.

Assessment Criteria

70%+ will be awarded for:

• Demonstrating in-depth knowledge

• Showing excellent knowledge of the topic area

• Excellent command and understanding of areas covered

• A very sophisticated critical evaluation and new insights informing situations.

60-70% will be awarded for:

• Demonstrating extensive knowledge

• Showing good knowledge of the topic area

• Sound command, understanding, and usage of relevant tools

• A sound critical evaluation and new insights informing situations

50-60% will be awarded for:

• Demonstrating some knowledge

• Showing relevant knowledge of the topic area

• Showing good command, understanding of areas covered

• A critical evaluation, and some insights informing situations

Answers that fall below the criteria for a pass will receive a failure mark