Fall Semester 2026 UNISA Assignment: Automation and Data
Analysis (AIN3701) – Complete Solved Assignment with Step-by-
Step Answers, Marking-Guideline Alignment & Exam-Focused
Study Guide (Updated 2026 Edition)
,Question 1:
Which of the following programming languages is primarily used for data analysis?
• A) Java
• B) Python
• C) Ruby
• D) C++
Correct Option: B) Python
Rationale: Python is a versatile programming language widely used in data analysis due
to its simplicity and the availability of numerous libraries such as Pandas and NumPy.
Question 2:
What is the main purpose of automation in data analysis?
• A) To increase the workload
• B) To improve efficiency and reduce human error
• C) To complicate processes
• D) To eliminate the use of data
Correct Option: B) To improve efficiency and reduce human error
Rationale: Automation streamlines data analysis processes, allowing for quicker
results and minimizing the risk of human mistakes.
Question 3:
Which of the following tools is best suited for automating workflows in data
analysis?
• A) Excel
• B) Apache Airflow
• C) SQL
• D) Google Analytics
Correct Option: B) Apache Airflow
Rationale: Apache Airflow is a powerful platform used to programmatically author,
schedule, and monitor data workflows, making it ideal for automation.
, Question 4:
Which statistical method is often employed to identify trends in large datasets?
• A) Random Sampling
• B) Regression Analysis
• C) Hypothesis Testing
• D) Descriptive Statistics
Correct Option: B) Regression Analysis
Rationale: Regression analysis is a statistical method that examines the relationship
between variables and is commonly used to identify trends in data.
Question 5:
In data visualization, which chart is most effective for comparing parts of a whole?
• A) Line Chart
• B) Pie Chart
• C) Scatter Plot
• D) Histogram
Correct Option: B) Pie Chart
Rationale: Pie charts are designed to show the proportion of different categories in
relation to the whole, making them effective for comparison.
Question 6:
Which library is most commonly used for data manipulation and analysis in
Python?
• A) Matplotlib
• B) Scikit-learn
• C) Pandas
• D) TensorFlow
Correct Option: C) Pandas
Rationale: Pandas is a powerful and flexible library specifically designed for data
manipulation and analysis, offering data structures like DataFrames.
Question 7:
Analysis (AIN3701) – Complete Solved Assignment with Step-by-
Step Answers, Marking-Guideline Alignment & Exam-Focused
Study Guide (Updated 2026 Edition)
,Question 1:
Which of the following programming languages is primarily used for data analysis?
• A) Java
• B) Python
• C) Ruby
• D) C++
Correct Option: B) Python
Rationale: Python is a versatile programming language widely used in data analysis due
to its simplicity and the availability of numerous libraries such as Pandas and NumPy.
Question 2:
What is the main purpose of automation in data analysis?
• A) To increase the workload
• B) To improve efficiency and reduce human error
• C) To complicate processes
• D) To eliminate the use of data
Correct Option: B) To improve efficiency and reduce human error
Rationale: Automation streamlines data analysis processes, allowing for quicker
results and minimizing the risk of human mistakes.
Question 3:
Which of the following tools is best suited for automating workflows in data
analysis?
• A) Excel
• B) Apache Airflow
• C) SQL
• D) Google Analytics
Correct Option: B) Apache Airflow
Rationale: Apache Airflow is a powerful platform used to programmatically author,
schedule, and monitor data workflows, making it ideal for automation.
, Question 4:
Which statistical method is often employed to identify trends in large datasets?
• A) Random Sampling
• B) Regression Analysis
• C) Hypothesis Testing
• D) Descriptive Statistics
Correct Option: B) Regression Analysis
Rationale: Regression analysis is a statistical method that examines the relationship
between variables and is commonly used to identify trends in data.
Question 5:
In data visualization, which chart is most effective for comparing parts of a whole?
• A) Line Chart
• B) Pie Chart
• C) Scatter Plot
• D) Histogram
Correct Option: B) Pie Chart
Rationale: Pie charts are designed to show the proportion of different categories in
relation to the whole, making them effective for comparison.
Question 6:
Which library is most commonly used for data manipulation and analysis in
Python?
• A) Matplotlib
• B) Scikit-learn
• C) Pandas
• D) TensorFlow
Correct Option: C) Pandas
Rationale: Pandas is a powerful and flexible library specifically designed for data
manipulation and analysis, offering data structures like DataFrames.
Question 7:
