You will examine the examination scores for the two training centers, using spreadsheet data – ExamScore

$1.49 Excluding Tax

Complete Solution:

Solution Available in PDF File.

-
+

Description

QUESTION:

You will examine the examination scores for the two training centers, using spreadsheet data – ExamScore.xlsx. The label Center A is in Cell A1 and the label Center B is in cell B1. The examination scores for Center A are in cells A2:A31 and examination scores for Center B are in cells B2:B41. The population standard deviations are assumed known with, and. The excel routine will request the input of variances which are, and. The following steps can be used to conduct a hypothesis test about the difference between the two population means (20 points).

Step 1. Click the Data tab on the Ribbon

Step 2. In the Analysis group, click Data Analysis

Step 3. When the Data Analysis dialog box appears:

Choose z-Test: Two-Sample for Means

Step 4. When the z-Test: Two-Sample for Means dialog box appears:

Enter A1:A31 in the Variable 1 Range box

Enter B1:B41 in the Variable 2 Range box

Enter 0 in the Hypothesized Mean Difference box

Enter 100 in the Variable 1 Variance (Known) box

Enter 100 in the Variable 2 Variance (Known) box

Select Labels

Enter .05 in the Alpha box

Select Output Range and enter C1 in the box

Click OK

Interpret the results from this hypothesis test using at least 50 words

Center A………………..Center B

97……………………….64

95……………………….85

89……………………….72

79……………………….64

78……………………….74

87……………………….93

83……………………….70

94……………………….79

76……………………….79

79……………………….75

83……………………….66

84……………………….83

76……………………….74

82……………………….70

85……………………….82

85……………………….82

91……………………….75

72……………………….78

86……………………….99

70……………………….57

91……………………….91

82……………………….78

73……………………….87

96……………………….93

64……………………….89

74……………………….81

88……………………….84

88……………………….63

60……………………….78

73……………………….66

………………………….84

………………………….85

………………………….85

………………………….84

………………………….59

………………………….62

………………………….91

………………………….83

………………………….80

………………………….76


Reviews

There are no reviews yet.

Be the first to review “You will examine the examination scores for the two training centers, using spreadsheet data – ExamScore”

Your email address will not be published. Required fields are marked *