Pregunta: Construya distribuciones de frecuencia e histogramas utilizando la herramienta Histograma de Excel para los datos de Ventas brutas y Ganancia bruta en el archivo de Excel. Proporcione instrucciones o una hoja de cálculo de Excel sobre cómo duplicar. Gracias. Cliente Utilidad bruta porcentual

Cliente

Utilidad bruta porcentual

Ventas brutas

Beneficio bruto

1

51,0%

$170.00

$86.70

2

32,0%

$181.00

$57.92

3

20,0%

$203.00

$40.60

4

22,0%

$249.00

$54.78

5

21,0%

$476.00

$99.96

6

21,0%

$476.00

$99.96

7

22,0%

$635.00

$139.70

8

34,0%

$856.00

$291.04

9

26,0%

$1,062.00

$276.12

10

16,6%

$1,110.00

$183.71

11

20,0%

$1,153.00

$230.60

12

36,0%

$1,392.00

$501.12

13

18,0%

$1,743.00

$313.74

14

20,0%

$2,307.00

$461.40

15

5,0%

$2,534.00

$126.70

dieciséis

29,0%

$2,683.00

$778.07

17

10,0%

$2,780.00

$278.00

18

37,0%

$3,272.00

$1,210.64

19

60,0%

$3,864.00

$2,318.40

20

24,0%

$3,988.00

$957.12

21

9,0%

$4,072.00

$366.48

22

50,0%

$4,190.00

$2,095.00

23

17,0%

$4,219.00

$717.23

24

32,0%

$4,711.00

$1,507.52

25

15,0%

$4,824.00

$723.60

26

10,0%

$4,878.00

$487.80

27

13,0%

$5,157.00

$670.41

28

22,0%

$5,552.00

$1,221.44

29

17,0%

$5,876.00

$998.92

30

19,0%

$5,888.00

$1,118.72

31

6,0%

$7,632.00

$457.92

32

23,0%

$8,058.00

$1,853.34

33

23,0%

$12,056.00

$2,772.88

34

14,0%

$12,981.00

$1,817.34

35

22,0%

$13,406.00

$2,949.32

36

14,0%

$15,882.00

$2,223.48

37

28,0%

$16,343.00

$4,576.04

38

27,0%

$19,985.00

$5,395.95

39

3,0%

$20,160.00

$604.80

40

46,0%

$26,616.00

$12,243.36

41

26,0%

$28,018.00

$7,284.68

42

11,0%

$28,950.00

$3,184.50

43

18,0%

$29,646.00

$5,336.28

44

37,0%

$31,019.00

$11,477.03

45

20,0%

$31,305.00

$6,261.00

46

21,0%

$34,769.00

$7,301.49

47

10,0%

$34,817.00

$3,481.70

48

14,0%

$38,609.00

$5,405.26

49

9,0%

$38,923.00

$3,503.07

50

16,0%

$40,536.00

$6,485.76

51

22,0%

$54,851.00

$12,067.22

52

21,0%

$54,861.00

$11,520.81

53

17,0%

$58,063.00

$9,870.71

54

11,0%

$62,862.00

$6,914.82

55

7,0%

$78,574.00

$5,500.18

56

14,0%

$92,776.00

$12,988.64

57

15,0%

$112,837.00

$16,925.55

58

13,0%

$115,999.00

$15,079.87

59

21,0%

$120,854.00

$25,379.34

60

14,0%

$179,101.00

$25,074.14