Answered: Write a function that categorises sales…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Write a function that categorises sales performance with header:

function [category, performance_data] = sales_performance(sales_data, ID)

Inputs:
sales_data - A 4 column matrix containing Item IDs, Price, Quantity and Revenues
ID - A scalar representing the item ID to categorise.

Outputs:
category - A string indicating the revenue performance category
performance_data - A three element row vector for Price, Quantity and Revenue for the item ID taken from sales_data.

The performance is calculated based on the following criteria based on the revenue:

Revenue outside the top 50% returns: category = 'Low Performing'
Revenue inside the top 50% to 75% returns: category = 'Medium Performing'
Revenue inside the top 75% to 95% returns: category = 'High Performing'
Revenue inside the top 5% return returns: category = 'Top Performing'

If no matching ID found or more than one ID then your function should produce an error - 'Not a unique ID number'

Using matlab

Expert Solution

Step 1

Answer:

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions