IBM Data Analyst Capstone Project | Coursera Quiz Answers

Coursera: IBM Data Analyst Capstone Project

IBM Data Analyst Capstone Project | Coursera

Upon completing the final capstone project, participants will apply acquired Data Analytics techniques from preceding IBM Data Analyst Professional Certificate courses. They will simulate the role of an Associate Data Analyst within an organization, tackling a real-world business challenge necessitating comprehensive data analysis. Tasks encompassed include data gathering from diverse sources, data cleaning and preparation, exploratory data analysis, statistical examination and data mining, creation of data visualizations using various charts and plots, and development of interactive dashboards. The project concludes with a comprehensive data analysis report, featuring an executive summary, detailed analysis, and conclusions, serving as a demonstration of proficiency in tools such as Jupyter Notebooks, SQL, relational databases (RDBMS), Business Intelligence (BI) tools like Cognos, and Python libraries including Pandas, Numpy, Scikit-learn, Scipy, Matplotlib, Seaborn, among others. This project significantly enhances one's portfolio and presents a valuable opportunity to exhibit expertise in Data Analytics to potential employers.

Enroll Course

Notice!
Always refer to the module on your course for the most accurate and up-to-date information.

Attention!
If you have any questions that are not covered in this post, please feel free to leave them in the comments section below. Thank you for your engagement.

Graded Quiz: Exploring Data

1. How many rows are in the data set?

11525
11555
11552
11255

2. How many columns are in the data set?

3. What type of column is "Age"?

Categorical
Numerical
Text
Nominal

Graded Quiz: Duplicates

1. How many duplicate rows are there in the dataset?

154
124
145
99

2. How many duplicate values are there in the column Respondent?

99
154
10
96

Graded Quiz: Removing Duplicates

1. After removing the duplicate rows, how many rows are there in the dataset?

9999
11398
13456
12333

2. After removing the duplicate rows, how many unique rows are there in the column Respondent?

11398
11342
11999
11000

Graded Quiz: Missing Values

1. After removing the duplicate rows, how many blank rows are there under the column EdLevel?

0
112
231
280

2. After removing the duplicate rows, how many rows are missing under the column Country?

Graded Quiz: Imputing Missing Values

1. What is the majority category under the column Employment?

Independent contractor, freelancer, or self-employed

Retired
Employed part-time
Employed full-time

2. Under the column " UndergradMajor", which category has the minimum number of rows?

Health Science
Fine Arts
Information Systems
Computer Science

3. The column ‘ConvertedComp’ contains the annual compensation of the survey respondents. What is the best approach to impute the missing values in this column?

median
mean
min
max

Graded Quiz: Normalizing Data

1. How many unique values are there in the CompFreq column?

7
3
11398
5

2. After removing the duplicate rows, how many respondents are being paid yearly?

9999
312
6073
3259

3. What is the median NormalizedAnnualCompensation?

8080
100000
6132520
9000

Graded Quiz: Distribution

1. What is the median Age of survey respondents?

2.Howe What is the median ConvertedComp of respondents who have identified themselves as ‘Woman’?

57708
56453
54678
55467

3. Based on the histogram, which age group has the highest number of survey respondents?

24-32
40-48
32-40
16-24

Graded Quiz: Handling Outliers

1. What is the median ConvertedComp before removing outliers?

55768
55342
78675
57745

2.What is What is the median ConvertedComp after removing outliers?

53564
52704
56456
55672

3. Based on the boxplot of ‘Age’ how many outliers do you see below Q1?

4. What is the mean ConvertedComp after removing outliers?

10000
34567.34
2378.56
59883

Graded Quiz: Correlation

1. Which column has a negative correlation with "Age"?

WorkWeekHrs
CompTotal
Respondent
CodeRevHrs

2. Which column has the highest correlation with "Age"?

CompTotal
WorkWeekHrs
ConvertedComp
Respondent

Graded Quiz: Visualizing Relationship

1. Based on the scatter plot of Age and WorkWeekHrs , what kind of correlation do you see between them?

Very High negative correlation.
No correlation
Very high positive correlation
Difficult to clearly identify from the scatter plot.

Graded Quiz: Visualizing Composition of Data

1. In the pie chart of top 5 databases, respondents wish to learn next year, what is the percentage of Mongodb?

19.1
18.8
20.9
16.4

2. In the list of most popular languages respondents wish to learn next year, what is the rank of Python?

3. How many respondents indicated that they currently work with 'SQL'?

5132
5012
5321
7106

4. How many respondents indicated that they work on 'MySQL' only?

474
876
657
736

Graded Quiz: Visualizing Comparison of Data

1. Majority of the survey responders are

Developer - back-end
Developer - full-stack
Developer - mobile
Developer - front-end

2. Based on the Line Chart of Age and median ConvertedComp for the age group 25-30, what kind of correlation do you see between Age and median ConvertedComp?

Highly Negative
No Correlation
Negative
Positive

Graded Quiz: Collecting Data

1. Which python module helps you to easily access an API?

Pandas
Requests
NumPy
Matplotlib

2. How many job postings exist for the Python programming language?

1173
2089
None of the above
4025

3. Of all the locations in the list below, which has the maximum number of job postings?

L= ["Los Angeles", "New York", "San Francisco", "Washington DC", "Seattle"]

Seattle
New York
Washington DC
Log Angeles

Graded Quiz: Web Scraping

1.Of Which language are developers paid the most according to the output of the web scraping lab?

C
Java
Swift
C++

2. Which of the following code segments will help to scrape all images from a html page?

soup.findall(“pic”)
soup.findall(“img”)
soup.find_all(“img”)
soup.find_all(“image”)

TeamsCloud