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
- COM5074: Compose a commentary report focusing on a prevalent issue within your chosen domain in the creative industries: Professional Practice & Ethics Case Study, SU, Malaysia
- Software Engineering Dissertation, UTM, Malaysia Test Case Prioritization Using Swarm Intelligence Algorithm To Improve Fault Coverage And Time For Web Applications
- Advanced process integration Assignment, CU, Malaysia Determine the minimum fresh water and minimum wastewater targets for the above system using water cascade analysis
- ABCR2103: This assignment aims to assess students’ understanding of the roles and functions of corporate communication: Principles Of Corporate Communication Assignment, OUM, Malaysia
- ETMS63020: Economic and Management Sciences Teaching 1 Assignment, SPU, Malaysia Explain with applicable relevant examples how would you apply the following didactical principle
- TP063899: Enhancing User-Interactive Learning: A Gamification Approach to Information Discovery and Exploration: Final Year Project Assignment, AUTI, Malaysia
- You have to select the latest annual report of any one of listed companies in Malaysia: Financial Account and Reporting 2 Assignment, Uitm, Malaysia
- Business Strategy and Leadership Assignment, ASB, Malaysia Multiple problems confront an organization in a fiercely competitive business climate. This means that a company’s
- In 2022, a new Recruitment Manager, Leon was ired at Delton Logistic, a transportation services company: Strategic, HR Planning, Selection and Recruitment Assignment, OUM, Malaysia
- Customers enter the waiting line at a cafeteria’s only cash register on a first-come, first-served basis: Optimization Technique Assignment, UMP, Malaysia