Republic of the Philippines
CATANDUANES STATE UNIVERSITY
Virac, Catanduanes
College of Business and Accountancy
FINAL EXAMINATION in BUSINESS STATISTICS
Name: _____________________________ Course/Blk: ________ Date: __________ Score: _______
Direction: For problem solving, use excels in computing the answers. For items no. 1-2, one to three
sentences is enough as long as it is direct to the point or straightforward.
1. The second major area of inference is hypothesis testing. Here are some of important
details that you need to explain or describe(11 points):
Statistical hypothesis (3 points)
Null hypothesis (3 points)
Alternative hypothesis (3 points)
Level of significance at 0.05 (2 points)
2. What is Chi-square and its use (7 points)?
3. Examination scores for 18 employees(16 points)
Plant 1 Plant 2 Plant 3
85 71 59
75 75 64
82 73 62
76 74 69
71 69 75
85 82 67
Solve the Sum of Squares, Mean Squares, and set up ANOVA Table at alpha level .05 level of
significance. And compare it with the P values .003.
4. Given are five observations for two variables, x and y (8 points).
X 1 2 3 4 5
Y 3 7 5 11 14
Develop the estimated regression equation (8 points).
5. The test scores of 8 students are shown below. What can you say about the strength of the
correlation between these sets of scores in Biology and in Chemistry? Uses the formula not
excel to compute for (Sxy) (8 points).
Student 1 2 3 4 5 6 7 8
Biology 33 31 40 37 25 23 40 23
Chemistry 38 35 37 33 23 18 38 21
Prepared by: MARIA ISABEL L. DE LA HOSTRIA, Ed.D. Noted by: JONAH DEE T. TUGANO, MBA
Associate Professor III Chairman, BEM
Republic of the Philippines
CATANDUANES STATE UNIVERSITY
Virac, Catanduanes
FINAL EXMINATION (KEY TO CORRECTION)
BUSINESS STAISTICS
Direction. For problem solving, use excel in computing the answers.
1. The second major area of inference is hypothesis testing. Here are some of important
details that you need to explain or describe (11 points):
Statistical hypothesis (3 points) – is an assertion concerning one or more
populations.
Null hypothesis (3 points) – is a hypothesis of no difference.
Alternative hypothesis (3 points) – also called research hypothesis. The rejection
of null hypothesis leads to the acceptance of the alternative hypothesis.
Level of significance at 0.05 (2 points) – is the probability that the null hypothesis
will be rejected in error when it is true.
2. What is Chi-square and its uses (7 points)? A chi-square is used to determine the
differences between the observed and expected frequencies.
3. Examination scores for 18 employees(16 points)
Plant 1 Plant 2 Plant 3
85 71 59
75 75 64
82 73 62
76 74 69
71 69 75
85 82 67
Solve the Sum of Squares, Mean Squares, and set up ANOVA Table at alpha level .05 level of
significance. And compare it with the P values.
Answer:
Source of Sum of Degrees of Mean F p-value
Variation Squares Freedom Square
Treatments 516 2 258 9.00 .003
Error 430 15 28.67
Total 946 17
4. Given are five observations for two variables, x and y (8 points).
X 1 2 3 4 5
Y 3 7 5 11 14
Develop a scatter diagram (4 points) and develop the estimated regression equation (4
points).
Republic of the Philippines
CATANDUANES STATE UNIVERSITY
Virac, Catanduanes
Y= 0.2 – 2.6 x
5. The test scores of 8 students are shown below. What can you say about the strength of the
correlation between these sets of scores in Biology and in Chemistry? Use the formula not
excel to compute (8 points).
Student 1 2 3 4 5 6 7 8
Biology 33 31 40 37 25 23 40 23
Chemistry 38 35 37 33 23 18 38 21
Answer:
Biology (X) Chemistry (Y) XY X2 Y2
33 38 1254 1089 1444
31 35 1085 961 1225
40 37 1480 1600 1369
37 33 1221 1369 1089
25 23 575 625 529
23 18 414 529 324
40 38 1520 1600 1444
23 21 483 529 441
252 243 8032 8302 7865
Republic of the Philippines
CATANDUANES STATE UNIVERSITY
Virac, Catanduanes
Prepared by: MARIA ISABEL L. DE LA HOSTRIA, Ed.D. Noted by: JONAH DEE T. TUGANO, MBA
Associate Professor III Chairman, BEM
