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

School

Universiti Teknologi MARA (UiTM)

*We aren't endorsed by this school

Assignment Type

Individual Assignment

Subject

MGT555: Business Analytics

Uploaded by Malaysia Assignment Help

Date

01/31/2022

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:

Minimum quantity ordered.
Maximum quantity ordered.
Total revenue.
Number of orders with order amount more than RM2000
Several sales were made by Muthu.
Number of orders for coffee
Number of orders from Terengganu
Number of sales of chocolate >RM500
A customer (Order ID: 1375) call up regarding the number of items ordered.
A customer (Order ID: 1375) calls up regarding the type of payment.

Stuck in This Assignment? Deadlines Are Near?

Hire Assignment Helper Now!

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.

Based on the data, calculate
Total number of males
Total number of females
The average age of respondents
Sum of cost of spending on beauty and hygiene products
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 30% Discount on This Assignment Answer Today!

Take Expert Help Now!

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 by your university at a cheap price and submitted before the deadline

Answer