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: Bachelor of Information Technology Data Analytics Assignment, HU, Malaysia

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 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

Malaysia Assignment is the leading cheap assignment help provider to college or university students. we have hired Ph.D. and master's degree experts from the reputed university.  our writers work round the clock to serve the first-class answers on it assignments at a low-cost price.

Answer

Recent Solved Questions

Online Exam & Assignment Writing Services

11770+ Orders Delivered

4.9/5
5 Star Rating

Confidential & Secure Assignment Help For

Group Assignment Help

Online Exam -Test & Quiz

Cheapest Price Quote

Diploma & Certificate Levels

Semester & FYP Papers

Summative & Individual

GBA & Reflective

Last Minute Assistance

Sample Assignment Download

IMU252 Islamic Investment UITM Assignment Sample Malaysia
IMU252 Islamic Investment course is an exclusive opportunity to gain an in-depth comprehension of the principles and models used for making informed decisions for investing under an Islamic framework. Understanding…
Assignment Sample
BSB132 Economics UITM Assignment Sample Malaysia
BSB132 Economics is a great course for students looking to understand the principles of microeconomics and macroeconomics, explore the connections between policy, politics, and markets, and discuss the economic impact…
Assignment Sample

UP TO 15 % DISCOUNT

Instant Paper Writing Services by Native Malaysia Writers

Plagiarism Free Solutions
100% Original Work
24*7 Online Assistance
Native PhD Experts
Hire a Writer Now

Get Assistance for Assignments, online Exam, and Projects Writing