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.
Recent Solved Questions
- KNC6013: Sustainable Development Decision Making Decision making for sustainable project management can be a very arduous task: Sustainable Project Management Assignment, USM, Malaysia
- You are tasked to demonstrate the feasibility and complexity of the IATA information system in terms of the data structures to be deployed for their operations and database storage: Data Structure and Algorithm Report, MUM, Malaysia
- FIT3155: Write a program in C++ to demonstrate your ability to apply stack or queue data structures: Advanced data structures and algorithms Report, MUM, Malaysia
- CHE5884: Calculate the hourly feed rate of the feedstock for the plant to produce the product assigned to your group: Process modelling and optimisation Case Study, MUM, Malaysia
- Malaysia’s national debt to gross domestic product (GDP) ratio is at a worrying high of 63.8%. In your opinion, what should the Malaysian: Economics Assignment, UMS, Malaysia
- STA404: A random sample of employees was selected from three different types of stores at the mall and their ages were recorded: Statistics for Business and Social Sciences Assignment, UiTM, Malaysia
- FIN 302: Which economic and legal factors have been affecting your selected financial institutions? Give appropriate reasons to justify your arguments: Financial Environment Assignment, MRSB, Malaysia
- Let X be an exponential random variable, Show that for a > 0 and b > 0: Statistics Assignment, USM, Malaysia
- China has emerged as a major player in international affairs in the last few decades with global interests and the ability: International Relations Dissertation, UITM, Malaysia
- BFW2341: Explore the international financial environment and the importance of foreign exchange risk management: International Financial Management Essay, MUM, Malaysia