Question

Data

46.66

28.73

39.37

22.99

49.58

8.58

91.38

26.57

87.73

20.22

6.43

13.30

42.44

83.19

27.79

66.91

89.26

68.39

45.61

23.34

76.10

60.64

27.11

36.69

35.00

2.60

15.75

0.32

66.52

28.59

50.77

14.61

2.59

94.35

68.31

10.71

42.50

65.44

53.38

5.85

1.01

50.65

68.33

58.47

49.33

50.76

26.15

61.90

8.49

70.07

63.22

48.20

34.63

77.22

16.57

9.02

39.21

47.14

8.34

38.81

94.75

18.34

80.02

44.15

78.32

21.08

47.54

9.74

94.28

72.48

28.78

46.55

66.84

88.48

6.95

35.38

58.66

21.53

84.72

96.34

93.22

70.43

63.24

35.77

10.91

57.01

2.76

32.05

65.13

72.60

84.20

68.03

80.46

33.69

81.16

11.39

99.32

62.75

95.38

32.69

36.00

60.49

3.04

56.62

61.01

85.07

52.45

25.08

95.53

10.22

58.01

23.54

78.82

17.59

54.68

9.63

39.10

86.38

63.57

13.57

68.87

29.06

69.71

5.54

79.68

4.33

85.16

83.42

46.04

78.28

21.84

27.06

24.39

69.72

40.88

34.06

74.66

71.41

26.61

74.49

44.99

85.96

22.61

47.31

90.88

1.72

68.08

1.06

31.89

79.70

12.80

64.60

85.50

90.33

62.48

93.46

5.30

54.05

63.21

85.06

32.04

33.81

3.00

58.22

50.62

7.93

17.67

36.01

4.39

56.59

47.15

92.74

81.26

2.20

12.85

22.81

47.48

37.33

14.14

37.60

36.06

99.39

13.61

47.94

55.05

84.15

77.10

45.65

1.08

64.70

60.84

26.57

0.30

69.39

31.30

94.86

11.59

66.55

98.51

7.78

60.41

0.42

3.65

46.78

49.87

13.09

92.00

54.00

91.38

52.80

68.64

18.09

32.02

4.96

54.58

81.54

40.91

71.02

93.02

26.21

65.24

23.64

22.76

52.42

74.06

69.61

69.98

49.99

48.85

77.19

62.17

62.20

21.89

50.42

7.27

27.91

37.82

77.55

13.45

18.80

87.45

69.11

82.63

11.61

24.35

53.14

31.74

17.89

66.66

7.45

create frequency distribution chart on excel using formula.

create a proper histogram using excel using formula.

Answer 1

The given data was inputted in EXCEL and the BAR Plot function was used to get the required frequency distribution plot of the data as:

Similarly the Histogram Plot was used to obtained the histogram as:

answered by: anonymous