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:
- 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.
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.
- 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 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 by your university at a cheap price and submitted before the deadline
Recent Solved Questions
- Briefly distinguish between ‘the demand for localization’ and ‘the demand for globalization: Strategic management Case study, UMT, Malaysia
- The utilization of fossil fuels has stimulated economic perception and environmental considerations including energy crisis: Inorganic Chemistry Research Paper, UPM, Malaysia
- BRI3114: Describe information resources are available for HR professionals for decisional support: Human Resource Information Systems Assignment, MMU, Malaysia
- BMK310/03: Established in 1957, Corica Pastries from Australia has consistently been delighting customers with their world-famous apple strudels: Retailing Assignment, WOU, Malaysia
- UBAF3023: Sustainability reporting is a report that is published by organizations to give details about the impact a company is having on the environmental: Corporate Reporting and Current Issues, Report, UTAR, Malaysia
- MBSA2233: You have recently been appointed CEO of a company You are asked to implement strategic transformation initiatives: Managing Strategic Transformation in Organizations Assignment, UM, Malaysia
- UEEN1043:you are asked to demonstrate a program that uses the container class in Python :Object-Oriented Concept and Programming Techniques Assignment, UTAR, Malaysia
- LAW 437: Discuss critically the constitutional impact and significance of the following decided cases with special emphasis on the freedom of speech and expression: Constitutional law Assignment, UTM, Malaysia
- BFN20203: You are required to collect the closing MONTHLY share prices of FOUR 4 companies from the main market: Financial Management Assignment, MMU, Malaysia
- CHE 433: Velocity is an intensive property of a system and One kilogram of water at a temperature of 225°C and 500 kPa has a volume of 0.078405 m3: Thermodynamics Assignment, UiTM, Malaysia