Saudi Electronic University Crime Dataset Worksheet

College of Computing and InformaticsIT445
Decision Support Systems
Project/Case Study
Deadline: Sunday 12/2/2023 @ 23:59
[Total Mark is 14]
Student Details:
CRN:
Name:
Name:
Name:
ID:
ID:
ID:
Instructions:
• You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on
Blackboard via the allocated folder. These files must not be in compressed format.
• It is your responsibility to check and make sure that you have uploaded both the correct files.
• Zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between
words, hide characters, use different character sets, convert text into image or languages other than English
or any kind of manipulation).
• Email submission will not be accepted.
• You are advised to make your work clear and well-presented. This includes filling your information on the
cover page.
• You must use this template, failing which will result in zero mark.
• You MUST show all your work, and text must not be converted into an image, unless specified otherwise by
the question.
• Late submission will result in ZERO mark.
• The work should be your own, copying from students or other resources will result in ZERO mark.
• Use Times New Roman font for all your answers.
Pg. 01
Learning Outcome(s):
CLO 1, 2, 5
Project
Description and Instructions
1, Demonstrate an
understanding of the
concepts of decision
analysis and decision
support systems (DSS)
including probability,
modelling, decisions
under uncertainty, and
real-world problems.
Students can form groups consisting of three students and send their names to
2, Describe advanced
Business Intelligence,
Business Analytics,
Data Visualization, and
Dashboards.
hypothesis. Perform the following tasks. You should use visualization to aid your
5, Improve hands-on
skills using Excel, and
Orange for building
Decision Support
Systems.
==========================================================
instructor before 3rd January and select one dataset from the datasets provided in the
bellow link.
https://www.coursera.org/articles/data-analytics-projects-for-beginners
“10 free public datasets for EDA”
Use only one dataset and analyze the data using Microsoft Excel to discover the
structure of data, trends, patterns, or any anomalies in the data based on your own
answer.
The final project report which must incorporate all the following 5 tasks and written
using the provided template. (14 marks distributed among the below tasks).
Task 1: Understand and describe the nature and structure of the selected
dataset. (3 marks)
• A brief description about the dataset.
• Identify the features of dataset.
• Propose hypothesis / assumptions (between 2 variables) to validate.
Task 2: Reduce the dimension of the datasets to support the hypothesis
validation. If necessary, do data preprocessing on any missing values, duplicate
values, etc. You can also generate new feature from the any of the provided
features that may support your hypothesis. Due to the limitation of processing
power of some devices, you can reduce your dataset to 1000 tuples. (3 marks)
Pg. 02
Project
Task 3: Provide descriptive statistics for some feature using statistical
method to understand the dataset more and answer the following analysis
questions :(4 marks)

Compare different attributes (features). What trend did you find?

Include any of the measure of central tendency such as the mean,
median, and mode.

Describe the spread of your data. This may include the measure of
variance, standard deviation, skewness, and kurtosis.
(You are encouraged to impose other analysis questions based on any
trend you notice in the dataset).
Task 4: Validate the hypothesis in Task 3 by investigating the relationship
between two quantitative variables you have chosen using correlation,
regression and R-squared with possible conclusions. (3 marks)
Task 5: Show visual representation of your analysis (hint: use the right
chart/graph for your data analysis). (1 mark)

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Order a unique copy of this paper

600 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
Top Academic Writers Ready to Help
with Your Research Proposal

Order your essay today and save 25% with the discount code GREEN