Chapter 2, Problem 1.12CP

Q2. What is the algorithm distinguishing whether customers who use a product leave about a certain product? 1) Classification analysis 2) Regression analysis 3) Cluster analysis 4) Discriminant analysis

Draw decision table for Bookstores that get trade discount of a. 15% for orders from libraries and individuals b. 5%% extra allowed on orders of 6-19 copies per book titles c. 10% extra on orders of 20 -49 copies per book title d. 15% extra on orders of 50 or more copies per book title.

The sales person gets bonus pay if their amount exceeds a certain tier level for each year. Who    would be getting a bonus, and for how much? how can i do this on excel

A clustered bar chart to examine the method of payment by customer type  A chart to examine whether the relationship between net sales and age depends on the marital status of the customer Customer Type of Customer Items Net Sales Method of Payment Gender Marital Status Age 1 Regular 1 39.50 Discover Male Married 32 2 Promotional 1 102.40 Proprietary Card Female Married 36 3 Regular 1 22.50 Proprietary Card Female Married 32 4 Promotional 5 100.40 Proprietary Card Female Married 28 5 Regular 2 54.00 MasterCard Female Married 34 6 Regular 1 44.50 MasterCard Female Married 44 7 Promotional 2 78.00 Proprietary Card Female Married 30 8 Regular 1 22.50 Visa Female Married 40 9 Promotional 2 56.52 Proprietary Card Female Married 46 10 Regular 1 44.50 Proprietary Card Female Married 36 11 Regular 1 29.50 Proprietary Card Female Married 48 12 Promotional 1 31.60 Proprietary Card Female Married 40 13 Promotional 9 160.40 Visa Female Married 40 14 Promotional 2…

- Find the employee in each department who makes the highest salary in their departments

Calculate the Theil index and the Atkinson index (use   = 1) of house-hold income for all households and by race (in other words, calculate the inequality measures within racial categories).   what would be the code for the above question in stata?

Roughly, what is tile difference in the typical salaries for these different groups?

Suppose that you want to increase all three of the resource availabilities in the product mix model simultaneously by the same percentage. You want this percentage to vary from 225% to 50% in increments of 5%. Modify the spreadsheet model slightly so that this sensitivity analysis can be performed with a one- way SolverTable, using the percentage change as the single input. Keep track of the computers produced in row 21, the hours used in the range B26:B28, and the total profit. Discuss the results.

1. Find total number(Employees) of Accountant (Job Title)-> HR schema (Employees and Jobs): 6 2. Find all the employees who has a 's' in their name and who started their job after Jun 17th 2003. HR schema: 3 3. Show all the employees who get more than average salary. → HR schema:3 4. Show how many employees working on each department where salary is more than 6000. HR schema: 5 5. .Find all the orders made on 16th Sep 2018. > CO schema (bonus):3