Question:Resources:Microsoft Excel, Signature Assignment Databases, Signature Assignment Options, Part 3: Inferential Statistics

Scenario:Upon successful completion of the MBA program, say you work in the analytics department for a consulting company. Your assignment is to analyze one of the following databases:

• Manufacturing
• Hospital
• Consumer Food
• Financial

Selectone of the databases based on the information in the Signature Assignment Options.

Providea 1,600 w word detailed, statistical report including the following:

• Explain the context of the case
• Provide a research foundation for the topic
• Present graphs
• Explain outliers
• Prepare calculations
• Conduct hypotheses tests
• Discuss inferences you have made from the results

This assignment is broken down into four parts:

• Part 1 - Preliminary Analysis
• Part 2 - Examination of Descriptive Statistics
• Part 3 - Examination of Inferential Statistics
• Part 4 - Conclusion/Recommendations

Part 1 - Preliminary Analysis (3-four paragraphs)

Generally, as a statistics consultant, you will be given a problem and data. At times, you may have to gather additional data. For this assignment, assume all the data is already gathered for you.

Statethe objective:

• What are the questions you are trying to address?

Describethe population in the study clearly and in sufficient detail:

• What is the sample?

Discussthe types of data and variables:

• Are the data quantitative or qualitative?
• What are levels of measurement for the data?

Part 2 - Descriptive Statistics (3-four paragraphs)

Examinethe given data.

Presentthe descriptive statistics (mean, median, mode, range, standard deviation, variance, CV, and five-number summary).

Identifyany outliers in the data.

Presentany graphs or charts you think are appropriate for the data.

Note:Ideally, we want to assess the conditions of normality too. However, for the purpose of this exercise, assume data is drawn from normal populations.

Part 3 - Inferential Statistics (2- three paragraphs)

Usethe Part 3: Inferential Statistics document.

• Create (formulate) hypotheses
• Run formal hypothesis tests
• Make decisions. Your decisions should be stated in non-technical terms.

Hint: A final conclusion saying "reject the null hypothesis" by itself without explanation is basically worthless to those who hired you. Similarly, stating the conclusion is false or rejected is not sufficient.

Part 4 - Conclusion and Recommendations (1- two paragraphs)

Includethe following:

• What are your conclusions?
• What do you infer from the statistical analysis?
• State the interpretations in non-technical terms. What information might lead to a different conclusion?
• Are there any variables missing?
• What additional information would be valuable to help draw a more certain conclusion?

Formatyour assignment consistent with APA .

DATASET

Hospital Geog. Region Control Service Census Births Personnel

1 1 2 1 107 312 792

2 1 1 1 198 1077 1762

3 1 2 1 356 1027 2310

4 1 1 1 100 355 328

5 7 1 1 9 168 181

6 4 2 1 159 3810 1077

7 4 4 1 65 735 742

8 4 2 1 48 1 131

9 1 2 1 253 1733 1594

10 1 1 1 21 257 233

11 1 1 1 27 169 241

12 6 3 1 30 430 203

13 6 3 1 43 0 325

14 6 2 1 233 2049 676

15 6 4 1 2 211 347

16 6 1 1 11 16 79

17 6 3 1 84 2648 505

18 6 2 1 219 2450 1543

19 6 3 1 112 1465 755

20 6 3 1 124 0 959

21 6 3 1 50 1993 325

22 6 2 1 142 2275 954

23 6 2 1 111 1494 1091

24 6 1 1 140 1313 671

25 6 3 1 28 451 300

26 6 2 1 154 1689 753

27 6 2 1 150 1583 607

28 6 3 1 144 2017 929

29 6 3 1 42 995 354

30 6 2 1 77 2045 408

31 5 2 1 119 1686 1251

32 5 2 1 27 503 386

33 5 2 1 15 126 144

34 2 2 1 179 2026 2047

35 2 2 1 175 1412 1343

36 2 2 1 461 1517 1723

37 1 3 2 32 0 96

38 1 2 1 74 0 529

39 1 1 1 414 2719 3694

40 1 2 1 253 1074 1042

41 1 3 1 180 1421 1071

42 1 1 1 184 762 1525

43 1 2 1 243 3194 1983

44 1 2 1 115 496 670

45 1 1 1 215 1442 1653

46 1 3 2 48 0 167

47 1 3 1 124 1107 793

48 1 2 1 189 2989 841

49 1 1 1 181 113 316

50 1 1 1 9 0 93

51 1 3 1 28 0 373

52 1 2 1 288 173 263

53 1 1 1 108 1064 943

54 1 2 1 154 759 605

55 7 2 1 76 1317 596

56 7 3 1 165 1751 1165

57 3 1 2 295 0 568

58 3 3 1 101 0 507

59 3 2 1 69 714 479

60 3 2 1 12 99 136

61 3 2 1 185 2243 1456

62 3 2 1 378 3966 3486

63 3 2 1 114 1308 885

64 3 3 2 49 0 243

65 3 2 1 106 2514 1001

66 3 2 1 460 3714 3301

67 3 2 1 43 126 337

68 3 4 1 29 556 1193

69 3 2 1 125 1327 1161

70 3 2 1 17 415 322

71 3 1 1 10 216 185

72 3 3 1 14 339 205

73 3 1 1 173 1217 1224

74 3 2 1 207 2641 1704

75 3 2 1 223 790 815

76 3 2 1 82 520 712

77 3 1 1 64 35 156

78 3 2 1 139 1168 1769

79 3 2 1 109 793 875

80 3 1 2 298 0 790

81 3 3 1 52 0 308

82 3 1 1 34 14 70

83 3 1 2 168 0 494

84 3 3 2 21 0 111

85 1 4 1 390 0 1618

86 1 1 1 47 0 244

87 1 2 1 80 776 525

88 1 3 1 50 451 472

89 1 3 2 113 0 94

90 1 2 1 45 145 297

91 1 1 1 76 1284 847

92 1 3 1 129 1 234

93 2 2 1 60 319 401

94 2 2 1 418 2154 3928

95 2 2 1 17 295 198

96 2 2 1 138 496 1231

97 2 2 1 64 589 545

98 2 2 1 62 806 663

99 2 1 1 131 701 820

100 2 2 1 265 3968 2581

101 3 4 2 456 0 1298

102 3 2 2 40 0 126

103 3 1 1 310 3655 2534

104 3 3 1 72 0 251

105 3 3 2 19 0 85

106 3 4 1 112 0 432

107 3 1 2 375 0 864

108 3 3 2 15 0 66

109 3 2 1 78 3063 556

110 3 1 1 123 169 347

111 3 2 1 54 66 239

112 3 2 1 96 827 973

113 1 3 1 82 570 439

114 1 1 2 1106 0 1849

115 1 1 1 30 0 102

116 3 1 2 56 0 262

117 3 4 1 36 342 885

118 3 3 1 127 494 549

119 3 1 2 180 0 611

120 3 4 1 59 0 330

121 5 2 1 127 0 1471

122 5 1 1 37 0 75

123 5 4 1 13 286 262

124 5 2 1 100 235 328

125 3 3 1 47 339 377

126 3 1 1 194 398 575

127 3 2 1 172 1275 1916

128 5 3 1 516 5699 2620

129 5 3 1 120 1364 571

130 5 1 1 179 714 703

131 2 4 1 140 0 535

132 2 3 2 78 0 160

133 2 3 2 68 0 202

134 2 2 1 186 779 1330

135 2 2 1 91 0 370

136 2 1 1 340 2202 3123

137 5 1 1 254 3346 2745

138 5 2 1 108 1071 815

139 5 2 1 61 352 576

140 2 2 1 174 254 502

141 2 1 2 306 0 808

142 2 3 2 28 0 50

143 2 2 1 395 699 728

144 2 2 1 923 2462 4087

145 2 1 1 335 3311 3012

146 1 2 1 46 0 68

147 1 1 1 316 4207 3090

148 1 4 2 416 0 1358

149 1 1 1 74 339 576

150 1 2 1 86 130 284

151 3 2 1 38 91 145

152 3 2 1 147 1143 2312

153 3 4 2 232 0 1124

154 3 1 2 138 0 336

155 3 2 1 38 509 415

156 3 2 1 245 1026 1779

157 3 1 2 171 0 338

158 3 3 1 51 447 453

159 3 4 1 28 1161 437

160 3 1 2 797 0 261

161 7 2 1 56 922 609

162 7 1 1 69 562 647

163 7 1 1 40 78 61

164 7 4 1 163 0 2074

165 7 2 1 231 2122 2232

166 2 1 2 523 0 948

167 2 4 1 31 0 409

168 2 2 2 43 0 153

169 2 2 1 66 710 741

170 2 2 1 231 1165 1625

171 1 4 1 11 466 538

172 1 3 1 144 1106 789

173 1 3 1 43 376 395

174 3 4 1 185 0 956

175 3 2 1 82 637 362

176 1 2 2 49 0 144

177 1 3 1 24 352 229

178 1 3 1 63 447 396

179 1 2 1 274 1227 2256

180 1 3 1 93 963 731

181 1 4 1 86 3038 1477

182 1 3 2 28 0 102

183 1 3 2 25 0 106

184 1 3 1 181 868 939

185 5 3 1 39 1189 392

186 5 1 1 302 2849 3516

187 5 2 1 80 1728 785

188 5 2 1 63 2171 607

189 2 2 1 31 364 273

190 2 2 2 170 0 630

191 1 1 1 203 2993 1379

192 1 2 1 296 0 1108

193 1 3 1 83 1964 583

194 7 2 1 84 601 514

195 7 1 1 29 387 216

196 7 2 1 187 1946 1593

197 7 2 1 77 545 1055

198 5 1 2 104 0 399

199 5 1 1 85 838 834

200 5 1 1 47 51 104