Group Assignment

Group: Form a group comprises of four members to work on this assessment component. Use the dataset given in the Dataset.zip to answer Q1 Q5 of this assessment component. Perform suitable function to perform the following tasks.

ASSIGNMENT QUESTIONS

Q1. Demographic Trends

Use the demographics_data.csv data set available in the Dataset.rar to perform the following tasks.

You are employed as a Data Scientist by the World Bank and working on a project to analyze the Worlds demographic trends.

You are required to produce a scatterplot illustrating Birth Rate and Internet Usage statistics by Country. The scatterplot also needs to be categorized by Countries Income Groups. You have received an urgent update from your manager.

You must produce a second scatterplot illustrating Birth Rate and Internet Usage statistics by Country. However, the scatterplot needs to be categorized by Countries Regions this time.

Tips

1. Import library/API
2. Read Dataset
3. Data Information
4. Visualize/produce plot
   1. Birth Rate against Internet Usage
   2. Country regions
   3. Countries Income group
5. Conclude your finding!

Q2 Countries Regions Analysis.

Use the region_data.csv data set available in the Data set.rar to perform the following tasks.

The World Bank was very impressed with your deliverables, and they have a new project for you. You must produce a scatterplot depicting Life Expectancy (y-axis) and Fertility Rate (x-axis) statistics by Country. The scatterplot also needs to be categorized by Countries Regions. You have been supplied with data for 1960 and 2013, and you are required to produce a visualization for each of these years. Some data has been provided in a CSV file. The CSV file contains combined data for both years. All data manipulations must be performed in python (not in excel) because this project may be audited later.

You have also been requested to provide insights into how the two periods compare.

Note: Data for this section was sourced from data.worldbank.org

Tips

1. Import library/API
2. Read Dataset
3. Data Information
4. Visualize/produce plot of Life Expectancy (y-axis) and Fertility Rate by country
   Note: use data that Ive provided.

5. Conclude your finding!

Formula for Life Expectancy

qx = Mx / (Bx + (Mx/2))

where Mx = the number of deaths at the age of x to under x+1 years in the reported period;

Bx = average population aged x to under x+1 in the base period;

qx = death probability from age x to x+1.

Additional Data:

Q3. Movie Rating Analysis

Use the Movie_Ratings.csv data set available in the Dataset.rar to perform the following tasks.

You have been approached as an analytics consultant by a movie reviews website. They are writing up an article analyzing movie rating by critics, audience, and movie budgets for 2007-2011.

This is the first time they have done this analysis, and they dont know exactly what they need. They have asked you to look into the data and provide five graphs that tell a story about the data. However, there is one chart the CEO specifically requested - a diagram showing how the correlation between audience and critic ratings has evolved throughout the years by genre.

Tips:

1. Import library/API
2. Read Dataset
3. Data Information
4. Visualize/produce plots ofmovie rating by critics, audience, and movie budgets for 2007-2011
5. Conclude your finding!

Q4. Loan Analysis

You have been approached as an analytics consultation by a Bank in Malaysia for analyzing the customer loan. Youre required to write a program using python to perform the following tasks:

1. Read the dataset loans_data.csv into python and assign it to a variable called df.
2. What was the most significant amount of loan instalment?
3. What was the average (mean) interest rate?
4. Which purpose had the highest average (mean) loan amount?
5. Create a new variable risk, which is equal to high when the interest rate is 10% or above and normal when the interest rate is less than 10%
6. Find the average loan amount for each purpose with at least 1000 loans made. Arrange from the highest average loan amount to the lowest.
7. Looking only at loans for credit cards and debt consolidation, what is the average loan amount in high-risk and low-risk loans?
8. Visualize the plot for each category of purpose

Formula to calculate Loan Amount:

Loan Amount = (Monthly payment x log.annual) + (Interest Rate * log.annual)

Example: (829.10*11) + (0.119 * 11) = 9120.10 + 1.309 = $9,121.41

• OBJECTIVES OF THIS COURSEWORK

This assignment will help you to explore and analyse a set of data and reconstruct it into meaningful representations for decision making.

• TYPE

Group Assignment

• COURSEWORK DESCRIPTION

GENERAL REQUIREMENTS

• The python program should compile and be executed without errors.
• Validation should be done for each entry from the users to avoid logical errors.
• No duplication is allowed in dataset.
• You should;
  • Include good programming practice such as comments, variable naming conventions and indentation.
  • Carried out additional research from Internet to comprehend the knowledge and information on the given dataset when examine the data.
• The analysis should be meaningful and effective in providing the information for the decision making.
• Any additional features implemented must improve the retrieval effects.
• In a situation where a student:
  • Found to be involved plagiarism, the offence and will be dealt in accordance to SEGi and UCLAN University regulations on plagiarism.

DELIVERABLES:

• The complete ipynb (source code) and report must be submitted to Blackboard
• ipynb (Program Code):

o Name the file under your name and ID number.

o Start the first two lines in your program by typing your name and ID number. For example:

# NAME

#SUCKD123456

• For each question example, give an id and explain what you want to discover. For example:

# Question 1: Why staff would leave the company.

# Analysis 1-1: Find the relationship between job position with attrition

# Analysis 1-2: Find the relationship between job age and .

# Analysis 1-3: Find the relationship between

• For each extra feature example, give an id and provide the explanation.

# Extra feature 1

# comments about the extra feature

DOCUMENTS: COURSEWORK REPORT

• As part of the assessment, you must submit the project report in printed and softcopy form, which should have the following format:

Cover Page:

All reports must be prepared with a front cover. A protective transparent plastic sheet can be placed in front of the report to protect the front cover. The front cover should be presented with the following details:

• Module
• Coursework Title
• Intake
• Student name and id
• Date Assigned (the date the report was handed out).
• Date Completed (the date the report is due to be handed in).

Contents:

• Introduction and assumptions (if any)
• Data import / Cleaning / pre-processing / transformation
• Each question must start in a separate page and contains:
  • Analysis Techniques - data exploration / manipulation / visualization
  • Screenshot of source code with the explanation.
  • Screenshot of output/plot with the explanation.
  • Outline the findings based on the results obtained.
• The extra feature explanation must be in a separate page and contains:
  • Screenshot of source code with the explanation.
  • Screenshot of output/plot with the explanation.
  • Explain how adding this extra feature can improve the results.

References

• The font size used in the report must be 12pt and the font is Times New Roman. Full source code is not allowed to be included in the report. The report must be typed and clearly printed.
• You may source algorithms and information from the Internet or books. Proper referencing of the resources should be evident in the document.
• All references must be made using the APA (American Psychological Association) referencing style as shown below:

The theory was first propounded in 1970 (Larsen, A.E. 1971), but since then has been refuted; M.K. Larsen (1983) is among those most energetic in their opposition.

/**

* Following source code obtained from (Danang, S.N. 2002)

*/

int noshape=2;

noshape=GetShape();

• List of references at the end of your document or source code must be specified in the following format:
  Larsen, A.E. 1971, A Guide to the Aquatic Science Literature, McGraw-Hill, London.
  Larsen, M.K. 1983, British Medical Journal [Online], Available from http://libinfor.ume.maine.edu/acquatic.htm
  (Accessed 19 November 1995) Danang, S.N., 2002, Finding Similar Images [Online], The Code Project, *Available from http://www.codeproject.com/bitmap/cbir.asp, [Accessed 14th *September 2006]

• Further information on other types of citation is available in Petrie, A., 2003, UWE Library Services Study Skills: How to reference [online], England, University of Western England, Available from
  http://www.uweac.uk/library/resources/general/info_study_skills/harvard2.htm, [Accessed 4th September 2003].

ASSIGNMENT ASSESSMENT CRITERIA

The assignment assessment consists of three components: Coding (60%), Documentation (30%) and Format of Report (10%). Details of the division for each component are as follows:

DEVELOPMENT TOOLS

The program written for this assignment should be written in Jupyter Notebook