Bachelor of Information Technology Data Analytics Assignment, HU, Malaysia Describe the data set in the Introduction in terms of where this data set came from, what the data is about, and what you plan to do analyze
University | HELP University (HU) |
Subject | Bachelor of Information Technology Data Analytics |
Assignment
This is an individual assignment. The objective of this assignment is to demonstrate the Excel and analytical skills that you have learned throughout this course using a real dataset (download from Kaggle). The content of the report should include a Cover Page. Table of Contents, Introduction, Methodology and Results, Discussion, and Conclusion.
1. Describe the data set in the Introduction in terms of where this data set came from, what the data is about, and what you plan to do analyze (Objective and Problem Statement).
2. Download a data set from Kaggle.com. You can trim the dataset, but it must consist of at least 200 observations. In order to avoid duplication, please register your dataset using the link below.
3. In the Methodology and Results section. conduct the following analysis:
- Design TWO different queries using logical functions
- Design a retrieval application using a combination of VLOOKUP/MATCH/INDEX/IF functions
- Design a PivotTable, and use this Table to show/extract TWO different information and visualize this information using PivotChart
- Create THREE different charts and ONE combination chart • Create data visualization with either data bars, color scales, or customized icon sets
- Comment on the frequency distribution and histogram of a categorical variable • Comment on the frequency distribution and histogram of a numerical variable
- Comment on the statistical measures using the Descriptive Statistics Tool of one of the variables
- Investigate the correlation between two variables, and interpret the coefficient
- Build a regression model, and use this model for a prediction.
4. In the Discussion section, discuss the results above. and how it relates back to your objective and problem statements.
5. Provide your conclusion about the project outcome
Stuck in Completing this Assignment and feeling stressed ? Take our Private Writing Services.
Get Help By Expert
Looking for expert assistance? Our skilled online assignment experts at Assignment Helper My offer tailored assistance to HELP University (HU) students pursuing a Bachelor of Information Technology in Data Analytics. With a deep understanding of the subject and university requirements, we provide top-notch support to enhance your academic journey. Trust us to deliver insightful assignments that stand out. You also avail our skilled writers for top MBA Assignment Help.
Recent Solved Questions
- EBQ2054: Business Research Method Essay, UM, Malaysia Describe the theoretical contribution in your research with the consideration of the relevant social theories that are supported by the specified arguments
- Assume you are the human resources director of a multinational corporation dealing with employee skill shortages: Training And Development Assignment, UON, Malaysia
- Data Mining Case Study, UOM, Malaysia- Choose any dataset and present the comparative analysis between clustering and association analysis, keeping in mind all the stages of SEMMA
- CT047-3-M: Discuss the benefits of weather forecasting towards the improvement of human life: Big Data Analytics And Technology Assignment, AUTI, Malaysia
- Business Economic Case Study, SU, Malaysia The following table lists the cross-price elasticities of demand for several goods, where the percent quantity change
- NBHS1112: Puan Suba adalah perempuan berumur 52 tahun yang diagnosis dengan Diabetis Mellitus Jenis II: BIOKIMIA TUGASAN, OU, Malaysia
- 380CT: Theoretical Aspects of Computer Science Assignment, CU, Malaysia You are assigned to the problem stated above and you are required to develop a computer program to try and solve it
- Analytics/justifications/pros and cons – for the improvement of human life?: Data Assignment, HWU, Malaysia
- Business Statics Assignment, SU, Malaysia In 2004, ratings are compiled concerning the performance of new cars during the first 100 days of use
- BBF201: Introduction To Financial Management Assignment, WOU, Malaysia In order to prepare to send his child to a medical school in the future, Encik Ishak wants to accumulate RM1.5 million