data management and analysis using Microsoft Excel
Budget: $10 – $30 USD
1- using a data sheet , calculate the following using Microsoft Excel skills.
1- High Value Customer (HV) - Number of clients and total amount.
2- Middle Value Customer (MV) - Number of clients and total amount.
3- Low Value Customer (LV)
4- No Value Customer (NV)
B- Which two companies are at the top of the HV list
2. Create suitable chart(s) to indicate the company service regions and their magnitude of services. Refer to the regions in which the company. should get more in-house/outsourced technicians. This information will best serve the management of the service (after-sale) department.
3. Create suitable chart(s) to indicate the company sales regions and their magnitude of sales. Indicate which regions are the most lucrative for the company. This information will best serve the management of marketing and sales departments.
4. Create suitable chart(s) with insights you deem necessary for the top management of the company.
5. Was there any problem with the data? If so, please list them below.
1- High Value Customer (HV) - Number of clients and total amount.
2- Middle Value Customer (MV) - Number of clients and total amount.
3- Low Value Customer (LV)
4- No Value Customer (NV)
B- Which two companies are at the top of the HV list
2. Create suitable chart(s) to indicate the company service regions and their magnitude of services. Refer to the regions in which the company. should get more in-house/outsourced technicians. This information will best serve the management of the service (after-sale) department.
3. Create suitable chart(s) to indicate the company sales regions and their magnitude of sales. Indicate which regions are the most lucrative for the company. This information will best serve the management of marketing and sales departments.
4. Create suitable chart(s) with insights you deem necessary for the top management of the company.
5. Was there any problem with the data? If so, please list them below.