Analyze and Summarize using Excel (data set/file is way to the bottom):

1) Is each variable in the file, Numeric/Discrete, Numeric/Continuous, Categorical/Nominal, or Categorical/Ordinal?

2) What is the mean, median, and standard deviation for annual salary and age. Based on these values for each variable, is the distribution of the data for annual salary and age symmetric or skewed (positive or negative)?

3) Create two histograms, one for annual salary and one for age. Do these distributions appear to be symmetric or skewed (positive or negative)? For both annual salary and age, does the shape of the distribution confirm #2 regarding symmetric versus skewed?

4) Make a scatterplot of age (x-axis) and annual salary (y-axis). Display the least squaresregressionline (in Excel, Linear Trend Line) on the chart. Calculate the Pearson correlation coefficient (r). Based on the value of the correlation coefficient, what is the strength of the relationship (weak, moderate, strong, or very strong)?

5) Make a boxplot of Prior experience and Beta experience (side by side).What do these boxplots reveal about these two types of experience?

6) Make a bar chart for average annual salary by level of education (by creating a pivot table and pivot chart). Make a frequency chart for education level (using a pivot table/pivot chart). What is the highest and lowest paying education levels? What is the most frequently occurring education level? What is the least frequently occurring education level?

7) This table contains the descriptive statistics for customer service times in minutes for the local coffee shop. Are the empirical rules applicable in this case? If so, apply them and interpret the results. If not, explain why the empirical rules are not applicable here.

Count

50

Mean

0.632

Median

0.623

Standard deviation

0.302

Minimum

0.077

Maximum

1.108

Variance

0.187

Skewness

-0.003

Employee Education Level Gender Age Prior Experience Beta Experience Annual Salary

1 4 1 39 5 12 57,700

2 5 0 44 12 8 76,400

3 3 0 24 0 2 44,000

4 2 1 25 2 1 41,600

5 6 0 56 5 25 163,900

6 5 1 41 9 10 72,700

7 4 1 33 6 2 60,300

8 4 0 37 11 6 63,500

9 5 1 51 12 16 131,200

10 1 0 23 0 1 39,200

11 4 0 31 5 4 62,900

12 1 1 27 0 8 26,200

13 4 0 47 11 9 74,500

14 4 1 35 5 5 64,800

15 1 1 29 5 4 21,600

16 5 0 46 4 15 81,900

17 6 1 50 10 17 115,400

18 4 0 30 3 6 57,800

19 4 1 34 10 1 55,800

20 5 1 42 11 8 76,100

21 6 1 51 10 15 135,700

22 6 0 63 16 20 140,400

23 3 0 28 0 5 55,400

24 4 1 32 4 1 49,700

25 5 0 55 11 16 134,800

26 5 1 45 20 2 76,900

27 2 0 34 2 12 28,700

28 4 0 33 2 7 58,800

29 3 1 23 0 1 43,100

30 5 0 40 4 13 82,400

31 5 1 48 6 15 80,100

32 2 1 27 0 6 27,000

33 4 1 36 5 5 58,800

34 6 0 58 9 22 133,100

35 3 0 31 1 1 53,700

36 1 1 21 0 1 26,700

37 5 0 47 5 16 81,300

38 4 1 35 3 7 55,400

39 6 1 52 12 14 139,900

40 3 0 29 3 3 33,200

41 5 1 42 11 7 75,000

42 6 0 60 10 21 128,200

43 5 1 50 8 13 76,800

44 4 1 33 1 2 54,200

45 3 0 26 0 5 32,600

46 4 0 38 6 6 59,200

47 5 1 44 7 12 74,800

48 3 0 25 0 3 45,500

49 4 1 37 8 5 46,500

50 6 0 53 13 13 136,300

51 5 0 46 7 18 86,900

52 1 1 20 0 1 23,900

53 4 1 34 5 1 52,700

54 5 1 60 12 13 92,700

55 4 1 36 6 7 59,500

56 4 0 41 6 3 69,400

57 3 1 33 3 1 46,600

58 5 0 29 3 8 61,700

59 5 0 48 11 9 88,200

60 3 1 43 0 4 45,000

61 4 1 61 10 5 52,200

62 4 0 30 5 1 61,400

63 5 1 36 5 19 87,500

64 6 1 48 7 23 103,700

65 3 1 29 5 6 54,000

66 6 0 26 11 23 125,100

67 3 1 49 5 11 45,900

68 5 0 28 10 2 79,300

69 5 1 44 20 5 108,600

70 4 1 48 0 13 68,200

71 4 0 50 0 21 65,200

72 5 1 48 12 14 95,600

73 5 1 30 16 12 103,100

74 6 1 41 20 23 143,500

75 4 0 35 11 5 78,200

76 3 1 28 3 3 40,200

77 4 1 33 8 5 60,500

78 3 1 61 0 7 40,500

79 4 1 53 10 8 73,800

80 3 1 48 4 4 45,300

81 4 0 47 9 1 61,400

82 4 1 48 4 7 64,800

83 4 1 55 11 3 75,600

84 5 0 32 1 19 95,800

85 6 0 60 11 4 126,700

86 5 0 50 10 2 67,000

87 5 1 49 16 12 102,600

88 3 0 22 4 3 52,000

89 4 1 51 9 10 76,000

90 5 1 22 0 3 83,000

91 4 1 47 8 13 80,800

92 5 1 41 10 10 91,100

93 2 0 24 3 1 30,100

94 4 1 64 5 7 55,700

95 3 1 43 0 11 51,400

96 3 0 22 3 1 43,800

97 2 1 59 0 1 25,000

98 4 0 32 10 15 80,600

99 3 1 45 8 5 39,600

100 1 0 47 0 1 13,400

101 5 1 29 6 18 88,200

102 6 0 61 9 15 109,100

103 1 1 57 3 1 34,200

104 4 1 65 4 9 57,800

105 4 0 34 6 7 68,100

106 5 0 54 6 13 94,900

107 4 1 30 5 5 63,200

108 4 1 39 6 16 82,700

109 5 0 32 7 8 85,600

110 2 1 24 2 7 27,100

111 4 0 40 10 3 69,800

112 5 0 52 13 4 81,300

113 5 0 28 11 5 78,400

114 6 0 53 20 9 127,300

115 6 0 43 0 24 93,700

116 4 0 30 5 6 74,400

117 3 0 46 3 3 48,300

118 5 1 38 10 13 98,900

119 4 0 28 0 16 73,300

120 6 1 46 11 19 117,300

121 3 1 30 5 5 37,800

122 4 1 43 6 14 77,400

123 6 1 29 11 1 111,200

124 5 0 48 11 4 75,300

125 6 0 42 7 17 96,900

126 6 0 18 10 19 123,600

127 4 0 35 6 2 55,200

128 1 1 22 0 1 12,400

129 4 1 44 4 15 73,900

130 5 1 47 20 4 94,100

131 4 1 34 10 8 74,300

132 4 1 37 11 4 66,900

133 1 1 49 0 4 12,500

134 5 0 32 0 18 90,200

135 3 1 37 5 8 59,000

136 6 1 29 10 19 114,700

137 4 0 24 7 15 71,700

138 6 0 43 20 18 125,500

139 5 1 54 11 17 100,200

140 3 1 26 0 4 45,400

141 4 0 47 10 4 72,200

142 4 1 31 5 12 69,500

143 4 0 33 11 1 67,900

144 4 0 42 2 7 67,500

145 2 1 34 2 1 31,800

146 2 1 59 0 10 27,800

147 3 1 43 5 4 60,200

148 3 1 30 2 2 34,500

149 5 1 45 7 12 87,000

150 1 1 50 0 4 12,500

151 6 0 23 0 15 122,700

152 4 1 44 5 7 56,200

153 4 0 48 10 6 56,900

154 4 1 47 4 12 66,000

155 5 0 20 11 4 76,000

156 4 1 31 0 16 44,100

157 5 0 30 0 18 78,500

158 5 1 42 5 13 71,800

159 5 1 25 9 7 80,700

160 4 1 24 2 15 47,800

161 6 0 36 13 13 105,000

162 6 0 32 6 15 100,700

163 1 1 27 2 1 18,300

164 6 0 55 12 12 110,600

165 3 0 36 0 2 36,800

166 3 1 22 0 4 45,500

167 4 1 25 0 14 71,400

168 4 1 47 5 14 74,300

169 6 0 43 16 11 160,600

170 3 1 53 0 7 52,500

171 4 0 38 5 7 65,000

172 6 0 39 12 14 104,500

173 5 1 35 5 18 85,000

174 6 1 23 3 10 110,200

175 5 0 43 10 7 80,100

176 3 1 33 3 3 40,000

177 4 1 44 10 1 55,900

178 4 1 33 0 16 64,600

179 4 1 31 0 13 68,600

180 4 1 36 7 8 65,100

181 6 1 45 13 19 111,700

182 4 1 45 12 1 62,000

183 4 0 39 2 7 55,800

184 4 0 45 5 11 54,600

185 3 0 25 1 1 37,600

186 3 1 34 0 7 41,200

187 4 1 53 0 6 49,900

188 4 0 35 4 6 59,400

189 4 1 52 3 13 65,500

190 4 1 33 10 3 73,200

191 3 1 49 0 3 30,500

192 5 1 59 6 17 84,800

193 5 1 35 16 9 95,200

194 5 1 44 11 11 84,900

195 6 1 61 11 18 102,600

196 4 1 43 11 1 59,000

197 3 0 30 0 5 44,800

198 5 0 32 11 2 70,500

199 5 0 57 10 4 83,700

200 5 1 44 10 18 100,000

201 3 1 44 2 4 39,300

202 2 1 45 0 7 20,400

203 4 0 43 0 12 74,300

204 5 0 33 11 19 114,500