Produce a Pareto diagram that shows total spending in a descending order and at the same...

Produce a Pareto diagram that shows total spending in a descending order and at the same time the cumulative percentage curve.
Based on the above, can you estimate which part of visitors accounts for 75% of total revenues in the island.

The data used are:

NATIONALITY	TOT_SPEND
GERMAN	1988
GERMAN	1988
GERMAN	1834
GERMAN	1823
GERMAN	1741
GERMAN	1708
GERMAN	1707
GERMAN	1701
FRENCH	1598
GERMAN	1531
FRENCH	1494
GERMAN	1437
GERMAN	1420
ITALIAN	1416
GERMAN	1414
GERMAN	1391
GERMAN	1358
ITALIAN	1350
GERMAN	1298
GERMAN	1296
GERMAN	1295
GERMAN	1295
FRENCH	1280
FRENCH	1245
BRITISH	1217
FRENCH	1204
GERMAN	1184
ITALIAN	1166
FRENCH	1140
GERMAN	1112
GERMAN	1095
ITALIAN	1088
ITALIAN	1079
FRENCH	1057
BRITISH	1046
FRENCH	1041
GERMAN	1026
GERMAN	1013
GERMAN	1011

Expert Solution

Step 1 : put the values in the descending order (highest first, lowest last)

Step 2: calculate the cumulative sales on the sorted values

cumulative revenue (i) = cumulative revenue (i-1) + sales (i)

where sales (i) is the sales in the ith row in the sorted data

cumulative revenue (1) = sales (1)

Step 3 : % cumulative revenue (i) = cumulative revenue/total revenue

NATIONALITY	TOT_SPEND	Cumulative revneue	Cumulative revneue
GERMAN	1988	1988	4%
GERMAN	1988	3976	7%
GERMAN	1834	5810	11%
GERMAN	1823	7633	14%
GERMAN	1741	9374	18%
GERMAN	1708	11082	21%
GERMAN	1707	12789	24%
GERMAN	1701	14490	27%
FRENCH	1598	16088	30%
GERMAN	1531	17619	33%
FRENCH	1494	19113	36%
GERMAN	1437	20550	39%
GERMAN	1420	21970	41%
ITALIAN	1416	23386	44%
GERMAN	1414	24800	47%
GERMAN	1391	26191	49%
GERMAN	1358	27549	52%
ITALIAN	1350	28899	54%
GERMAN	1298	30197	57%
GERMAN	1296	31493	59%
GERMAN	1295	32788	62%
GERMAN	1295	34083	64%
FRENCH	1280	35363	67%
FRENCH	1245	36608	69%
BRITISH	1217	37825	71%
FRENCH	1204	39029	74%
GERMAN	1184	40213	76%
ITALIAN	1166	41379	78%
FRENCH	1140	42519	80%
GERMAN	1112	43631	82%
GERMAN	1095	44726	84%
ITALIAN	1088	45814	86%
ITALIAN	1079	46893	88%
FRENCH	1057	47950	90%
BRITISH	1046	48996	92%
FRENCH	1041	50037	94%
GERMAN	1026	51063	96%
GERMAN	1013	52076	98%
GERMAN	1011	53087	100%

In the graph the part in the left of the red line corresponds to the 75% of the revenue

In the table pasted above the chart, the part above from the point where 76% in the cumulative percentage appears corresponds to it.

76% of the revenue stands at = 40213

milcah answered 2 months ago

Which of the following statements about Pareto diagrams is correct? The Pareto diagram shows the possible...

Which of the following statements about Pareto diagrams is correct? The Pareto diagram shows the possible root causes of a problem but does not show the frequency of defect occurrences The Pareto diagram shows the defects in order from most commonly occurring to bast commonly The Pareto diagram shows the defects in order from most commonly occuring to hast commonly The Pareto diagram shows the mean of a random sample at various points in time The bars in the Pareto...

Order the following compounds in descending order of frequency for the carbonyl band. 1) 2-propanone, methanal,...

Order the following compounds in descending order of frequency for the carbonyl band. 1) 2-propanone, methanal, ethanal 2) 2- pentonone, ethyl butanoate, pentanamide 3) cyclohexanone, 2-cyclohexenone, 3-cyclohexenone. c) Explain why primary amines and primary amides have two absorption bands d) Explain why the carbonyl band of a carboxylate salt are displaced at frequencies lower than 1710 cm

Explain an example of a scenario where a firm might use the Pareto diagram to focus...

Explain an example of a scenario where a firm might use the Pareto diagram to focus on the largest causes of quality failures in their organization (IN YOUR OWN WORDS). Provide an example(s).

In our simple models, the multipliers are the same for all spending and the same for...

In our simple models, the multipliers are the same for all spending and the same for all taxes. How do real world multipliers differ? How did they impact fiscal policy in the Obama American Recovery and Reinvestment Act of 2008? What does that tell us about fiscal policy in 2020?

Health Care Spending. Table 1.3 shows the 2013 per capita total expenditure on health in 35 countries...

Health Care Spending. Table 1.3 shows the 2013 per capita total expenditure on health in 35 countries with the highest gross domestic product in that year.12 Health expenditure per capita is the sum of public and private health expenditure (in PPP, international $) divided by population. Health expenditures include the provision of health services, family-planning activities, nutrition activities, and emergency aid designated for health but exclude the provision of water and sanitation. Make a stemplot of the data after rounding to...

Java : Modify the selection sort algorithm to sort an array of integers in descending order....

Java : Modify the selection sort algorithm to sort an array of integers in descending order. describe how the skills you have gained could be applied in the field. Please don't use an already answered solution from chegg. I've unfortunately had that happen at many occasion ....... ........ sec01/SelectionSortDemo.java import java.util.Arrays; /** This program demonstrates the selection sort algorithm by sorting an array that is filled with random numbers. */ public class SelectionSortDemo { public static void main(String[] args) {...

Method in C language for inserting in descending order in a single linked list. It has...

Method in C language for inserting in descending order in a single linked list. It has a head and tail variable.

Write and test a Python program to print a set of real numbers in descending order....

Write and test a Python program to print a set of real numbers in descending order. The program should also print out the median of the numbers input and how many numbers were input. The program should read in numbers until a negative number is read. The negative number serves as a sentinel or marker telling the program when to stop reading numbers. The program should then sort the numbers and print them out in order from largest to smallest....

Pareto Chart and A report summarizing the costs, percent of total, and percent of sales by...

Pareto Chart and A report summarizing the costs, percent of total, and percent of sales by appraisal, prevention, internal failure, and external failure cost of quality categories.Cost of Quality Report for a Manufacturing Company The president of Mission Inc. has been concerned about the growth in costs over the last several years. The president asked the controller to perform an The study of employee effort and other business records to determine the cost of activities.activity analysis to gain a better...

The following is a list of 29 Nascar racers, arranged in descending order. 18, 21, 22,...

The following is a list of 29 Nascar racers, arranged in descending order. 18, 21, 22, 25, 26, 27, 29, 30, 31, 33, 36, 37, 41, 42, 47, 52, 55, 57, 58, 62, 64, 67, 69, 71, 72, 73, 74, 76,77 -Find the % for the data value 74. -Find the % for the data value 30 -Calculate the 44th percentile -Calculate the 7th percentile

Question