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
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
- MGF1010: Introduction to Management Assignment, MU, Malaysia Choose an organisation which you would like to render support in promoting workplace well-being
- PRG2104: The aim of this project is to achieve the learning outcomes: Computer Science Assignment, SU, Malaysia
- Information Technology Assignment, APU, Malaysia List and explain the IT hardware requirements needed in each branch to allow communication between each office
- Accounting and Business Finance Dissertation, HWU, Malaysia It should be read in conjunction with the material available on CANVAS
- GSGM7324 Organisational Development and Change Management Assignment Malaysia
- Human Resource Management Essay, AeU, Malaysia What are the different conceptual approaches International Human Resource Management (HRM) takes when examining HRM
- ABCC1103 Tugasan OUM – Semester Mei 2024 Pengenalan Kepada Komunikas
- Management Information System Assignment, AU, Malaysia Identify and elaborate on what is a competitive advantage that a company may look for through Industry
- Law Equity & Trust Assignment, IIUM, Malaysia Leo Pedersen and Calvin Pedersen are brothers. In 2010, Leo left his job to set up Viking Oak Software Ltd
- Literature Learning in the Malaysian ESL Classroom Assignment, UiTM, Malaysia Explain ONE (1) literary model based on the three main models of literature
