Internet usage (Gigabytes) last month

55

65

56

97

72

92

58

77

59

67

92

86

92

95

87

92

60

59

94

62

54

66

74

75

58

90

97

88

55

51

75

59

66

69

57

74

54

63

50

97

63

78

89

81

62

90

80

79

61

79

All work for this question must be done in the worksheet named Question 1.

This worksheet can befound in the data fileAssignment Data.

1. Using Excel, obtain a Descriptive Statistics output of the internet usage from a random sample of 50 people during the previous month. (Mean, Mode, Range and Standard Deviation) * [1]

1. Using Excel, construct a histogram with appropriate bin widths

(with 7 classes). * [2]

1. Using the information from the descriptive statistics output and the histogram, write one paragraph describing the data set. You must include information about the mean, mode, range, standard deviation and the shape of the distribution, of the data in your answer. [2]