#### Description of this paper

##### Let's assume that the Student_Data.xls file was the entire-(Answered)

Description

Step-by-step Instant Solution

Question

Let's assume that the Student_Data.xls file was the entire population. We know the mean ans standard deviation of student ages to be 42.3 and 8.9 respectively. Using the Normal_Probability_xls file, compute the percentage of students that are older than 50, younger than 40, between 41 and 46 and oldest 10% are at what age? Then compare to the truth as found in the actual file.

ID

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

Gender

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Employ

Unemployed

Full Time

Part Time

Full Time

Full Time

Unemployed

Full Time

Full Time

Part Time

Full Time

Part Time

Full Time

Full Time

Full Time

Part Time

Full Time

Full Time

Part Time

Full Time

Unemployed

Full Time

Part Time

Full Time

Full Time

Part Time

Full Time

Part Time

Unemployed

Part Time

Full Time

Full Time

Unemployed

Full Time

Full Time

Part Time

Part Time

Full Time

Unemployed

Full Time

Part Time

Full Time

Full Time

Full Time

Unemployed

Full Time

Full Time

Part Time

Age

39

55

43

56

38

54

30

37

38

42

52

35

37

53

51

40

33

53

43

35

57

32

59

48

34

53

35

38

37

46

44

31

51

47

56

42

44

54

51

42

45

55

47

43

57

36

58

MBA_GPA

2.82

3.49

3.28

3.25

3.26

2.87

3.16

3.4

2.84

3.72

3.22

3.44

3.65

3.02

3.03

3.8

3.23

3.26

3.53

3.75

3.15

3.66

3.36

3.79

2.85

3.74

3.23

3.52

3.32

2.89

2.83

2.93

3.71

3.47

3.52

2.83

3.64

2.96

3.59

3.33

3.38

3.44

3.31

3.03

3.26

3.04

2.98

BS GPA

3.05

3.45

3.5

3.55

3.3

3.05

3.35

3.35

3.05

3.7

3.5

3.55

3.9

3.3

3.25

3.8

3.5

3.5

3.75

3.9

3.2

3.75

3.45

3.85

3.05

3.9

3.25

3.7

3.45

3.1

3.05

3.1

3.8

3.75

3.65

3.05

3.55

3.1

3.8

3.55

3.6

3.35

3.45

3.25

3.4

3.25

3.1

Hrs_Studying

3

7

7

7

6

4

6

6

3

7

7

7

8

6

6

8

7

7

8

8

6

8

7

8

3

8

6

7

7

4

3

5

8

8

7

3

7

4

8

7

7

6

7

6

7

6

5

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Marketing

Marketing

Marketing

Marketing

Marketing

Marketing

Marketing

Marketing

Marketing

Marketing

Full Time

Full Time

Full Time

Full Time

Full Time

Full Time

Unemployed

Full Time

Part Time

Full Time

Full Time

Part Time

Full Time

Full Time

Full Time

Full Time

Full Time

Full Time

Unemployed

Full Time

Part Time

Full Time

Part Time

Full Time

Part Time

Full Time

Full Time

Full Time

Full Time

Full Time

Full Time

Full Time

Unemployed

Full Time

Full Time

Full Time

Full Time

Full Time

Full Time

Full Time

Part Time

Full Time

Full Time

Full Time

Full Time

Full Time

Part Time

Full Time

46

53

59

49

34

46

46

33

56

39

51

55

38

33

34

31

37

46

31

47

54

52

43

44

34

59

45

30

32

32

40

48

51

30

31

35

33

35

31

38

46

45

59

58

46

35

53

31

2.8

3.75

3.64

3.65

3.18

3.44

3.06

3.51

3.33

2.81

3.64

3.05

2.85

3.56

2.92

3.35

3.46

3.59

3.11

3.65

3.17

2.97

3.77

3.21

3.17

3.65

2.94

3.53

3.65

3.61

3.7

2.91

3.09

3.77

3.79

3.59

3.38

3.57

2.97

3.44

3.64

3.48

2.99

3.73

2.91

3.78

3.4

3.13

3.05

3.75

3.65

3.8

3.3

3.4

3.15

3.75

3.4

3.05

3.8

3.4

3.05

3.6

3.1

3.5

3.35

3.75

3.2

3.7

3.5

3.1

3.9

3.2

3.15

3.65

3.1

3.7

3.6

3.7

3.9

3.1

3.25

3.95

3.8

3.6

3.5

3.5

3.1

3.65

3.55

3.4

3.1

3.8

3.05

3.95

3.4

3.15

2

8

7

8

6

7

6

8

7

2

8

7

3

7

5

7

6

8

6

8

7

5

8

6

6

7

5

8

7

8

8

5

6

9

8

7

7

7

5

7

7

7

5

8

4

9

7

6

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

1

1

1

1

1

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

No Major

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Full Time

Full Time

Full Time

Full Time

Full Time

Unemployed

Full Time

Part Time

Full Time

Full Time

Full Time

Full Time

Part Time

Full Time

Full Time

Part Time

Full Time

Full Time

Unemployed

Full Time

Full Time

Part Time

Unemployed

Full Time

Part Time

Full Time

Full Time

Part Time

Full Time

Unemployed

Part Time

Full Time

Part Time

Full Time

Unemployed

Part Time

Full Time

Full Time

Full Time

Full Time

Unemployed

Full Time

Part Time

Full Time

Full Time

Part Time

Full Time

Part Time

50

38

50

48

53

53

30

32

42

56

46

49

32

36

42

37

31

31

42

39

47

28

28

52

35

38

44

38

52

53

53

31

47

51

37

46

48

54

48

36

39

28

45

31

47

35

52

52

3.14

3.24

3.56

3.16

3.53

3.01

3.3

3.62

3.21

3.39

3.65

3.47

3.44

3.88

3.83

3.53

3.22

3.56

3.2

3.17

3.41

3.56

3.34

3.44

3.76

3.55

3.88

3.31

3.09

3.82

3.01

3.66

3.64

3.59

3.49

3.13

3.83

3.04

3.91

3.56

3.96

3.46

3.22

3.27

3.43

3.85

3.89

3.37

3.25

3.3

3.5

3.25

3.55

3.15

3.35

3.6

3.4

3.4

3.8

3.7

3.6

3.95

3.95

3.6

3.3

3.8

3.25

3.3

3.6

3.7

3.6

3.6

3.8

3.45

3.9

3.45

3.15

4

3.2

3.85

3.7

3.65

3.55

3.2

3.9

3.15

4

3.7

4

3.4

3.15

3.2

3.45

3.95

3.9

3.45

6

6

7

6

7

6

6

7

7

7

8

8

7

9

9

7

6

8

6

6

7

8

7

7

8

7

8

7

6

9

6

8

8

7

7

6

8

6

10

8

9

7

6

6

7

9

8

7

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Finance

Finance

Finance

Finance

Finance

Finance

Finance

Marketing

Marketing

Marketing

Marketing

Marketing

Marketing

Marketing

Marketing

Marketing

Marketing

Marketing

Marketing

Marketing

Marketing

Marketing

Unemployed

Full Time

Part Time

Full Time

Full Time

Part Time

Full Time

Part Time

Full Time

Unemployed

Full Time

Part Time

Full Time

Full Time

Part Time

Unemployed

Part Time

Full Time

Full Time

Full Time

Part Time

Full Time

Full Time

Part Time

Full Time

Full Time

Unemployed

Part Time

Full Time

Full Time

Part Time

Full Time

Full Time

Part Time

Full Time

Unemployed

Full Time

Full Time

Full Time

Full Time

Full Time

Unemployed

Full Time

Full Time

Full Time

Unemployed

Full Time

Full Time

55

52

46

31

33

45

50

33

37

33

46

55

30

51

35

40

29

52

27

51

56

35

46

39

31

52

32

32

44

43

38

54

27

38

45

48

43

34

54

36

45

28

37

27

31

45

48

50

3.32

3.54

3.8

3.74

3.17

3.27

3.32

3.56

3.95

3.56

3.79

3.93

3.79

3.71

3.05

3.22

3.85

3.82

3.23

3.56

3.53

3.62

3.8

3.47

3.64

3.03

3.17

3.22

3.92

3.82

3.26

3.8

3.2

3.46

3.67

3.06

3.66

3.96

3.75

3.83

3.22

3.36

3.21

3.02

3.99

3.07

3.65

3.67

3.3

3.55

3.9

3.85

3.45

3.55

3.3

3.45

4

3.75

3.75

4

3.85

3.85

3.35

3.2

3.95

3.95

3.95

3.65

3.65

4

3.95

3.35

3.65

3.15

3.25

3.2

4

3.95

3.55

3.85

3.2

3.35

3.75

3.4

3.85

4

3.85

3.85

3.2

3.35

3.25

3.15

4

3.15

3.65

3.85

6

7

8

8

7

7

6

7

9

8

8

9

8

8

6

6

9

9

9

7

7

9

9

6

7

5

6

6

10

9

7

8

6

6

8

7

8

10

8

8

6

6

6

5

10

6

7

8

192

193

194

195

196

197

198

199

200

0

0

0

0

0

0

0

0

0

Full Time

Unemployed

Full Time

Unemployed

Part Time

Full Time

Full Time

Part Time

Full Time

32

33

49

27

28

36

35

47

33

3.06

3.98

3.93

3.41

3.43

3.7

3.76

3.9

3.23

3.35

3.7

4

3.3

3.5

3.65

3.75

3.9

3.3

6

8

10

6

7

7

8

8

6

Works FT

0

1

0

1

1

0

1

1

0

1

0

1

1

1

0

1

1

0

1

0

1

0

1

1

0

1

0

0

0

1

1

0

1

1

0

0

1

0

1

0

1

1

1

0

1

1

0

Variable descriptions

Gender = 0 (male), 1 (female)

Major = student's major

Age = age of student in years

MBA_GPA = overall GPA in the MBA program

BS_GPA = overall GPA in the BS program

Hrs_Studying = average hours studied per week

Works FT = 0 (No), 1 (Yes)

1

1

1

1

1

1

0

1

0

1

1

0

1

1

1

1

1

1

0

1

0

1

0

1

0

1

1

1

1

1

1

1

0

1

1

1

1

1

1

1

0

1

1

1

1

1

0

1

1

1

1

1

1

0

1

0

1

1

1

1

0

1

1

0

1

1

0

1

1

0

0

1

0

1

1

0

1

0

0

1

0

1

0

0

1

1

1

1

0

1

0

1

1

0

1

0

0

1

0

1

1

0

1

0

1

0

1

0

1

1

0

0

0

1

1

1

0

1

1

0

1

1

0

0

1

1

0

1

1

0

1

0

1

1

1

1

1

0

1

1

1

0

1

1

1

0

1

0

0

1

1

0

1

Paper#9256275 | Written in 27-Jul-2016

Price : \$22