MGT555: The worksheet in the Excel File Berkat Malaysia Data provides information about 65 sales: Business Analytics Assignment, UiTM, Malaysia

University Universiti Teknologi MARA (UiTM)
Subject MGT555: Business Analytics
  • CHAPTER 1

The worksheet in the Excel File Berkat Malaysia Data provides information about 65 sales. The data include Order ID, Order Date, Customer ID, City, State, Salesperson, Payment Type, Product Name, Category, Unit Price, Quantity, Revenue, and Shipping Fee. Based on the data, find the value of:

  1. Minimum quantity ordered.
  2. Maximum quantity ordered.
  3. Total revenue.
  4. Number of orders with order amount more than RM2000
  5. A number of sales made by Muthu.
  6. Number of orders for coffee
  7. Number of orders from Terengganu
  8. Number of sales of chocolate >RM500
  9. A customer (Order ID: 1375) call up regarding the number of items ordered.
  10. A customer (Order ID: 1375) calls up regarding the type of payment.

Are You Searching Answer of this Question? Request Malaysian Writers to Write a plagiarism Free Copy for You.

  • CHAPTER 2

Based on the data that Credit Risk Management provided, create a pivot table to find the number of loans by different purposes, marital status, and credit risk. Illustrate the result on PivotCharts.

  • CHAPTER 3

This dataset is about the perceptions of gender stereotypes within the beauty industry. Many product advertisements for shampoo, soap, perfume, and cologne promote the idea of gender roles. In an attempt to discourage gender roles and stereotypes in advertisements, a new advertisement strategy was proposed. This strategy is called empowerment advertising, which focuses on representing diversity in the beauty industry. This project is focused on gaining a better understanding of consumer perceptions of the different advertising strategies.

  1. Based on the data, calculate
  2. Total number of males
  3. Total number of females
  4. The average age of respondents
  5. Sum of cost of spending on beauty and hygiene products
  6. The z-score for Ad Per year
  • Calculate descriptive statistics for average consumption
  • Write a report on the demographic section based on the analysis that you have presented

Get Solution of this Assessment. Hire Experts to solve this assignment for you Before Deadline.

Get Help By Expert

If you have no time your assignment deadline will be near you. don’t panic Malaysiaassignmenthelp is here we provide online assignment assistance to academic students. we have a team of reliable and efficient writers who can write your Business Analytics assignment in accordance with your university at a cheap price and submitted before the deadline

Answer

Recent Solved Questions

Online Exam & Assignment Writing Services

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

ACC116 Introduction To Cost Accounting Assignment Example UiTM Malaysia
In this course, you will learn the basic concepts of cost accounting at an operational level. You'll be introduced to key terms and principles in order for us both to…
Accounting
CSC570 XML Programming Assignment Example Malaysia
XML provides a way for computers, mobile devices, and other technological equipment to communicate with each other. This course will provide you with some basic principles of XML that should…
Computer & It

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