COMM 214 Business Analytics Final Exam Prep – Questions and Answers |
2026 Updated | 100% Correct - Concordia University.
Section A: Questions 1–25
Question 1: Descriptive Analytics
A company recorded monthly sales (in $000):
12, 15, 18, 20, 25
a) Find the mean
b) Find the median
✅ Solution:
Mean:
[
\frac{12 + 15 + 18 + 20 + 25}{5} = \frac{90}{5} = 18
]
Median (middle value):
= 18
✅ Answer:
Mean = 18
Median = 18
Question 2: Range
Given data: 10, 22, 35, 40, 50
✅ Solution:
[
Range = Max - Min = 50 - 10 = 40
]
✅ Answer:
,Range = 40
Question 3: Variance
Data: 2, 4, 6, 8
✅ Solution:
Mean:
[
\frac{2+4+6+8}{4} = 5
]
Variance:
[
\frac{(2-5)^2+(4-5)^2+(6-5)^2+(8-5)^2}{4}
= \frac{9+1+1+9}{4} = \frac{20}{4} = 5
]
✅ Answer:
Variance = 5
Question 4: Standard Deviation
[
\sqrt{5} \approx 2.24
]
✅ Answer:
Standard deviation ≈ 2.24
Question 5: Probability
Probability of getting heads on a fair coin?
✅ Answer:
,[
\frac{1}{2} = 0.5
]
Question 6: Conditional Probability
P(A|B) = 0.3, P(B) = 0.5
Find P(A ∩ B)
✅ Solution:
[
P(A \cap B) = P(A|B) \times P(B) = 0.3 \times 0.5 = 0.15
]
✅ Answer:
0.15
Question 7: Correlation
If r = 0.9, what does it mean?
✅ Answer:
Strong positive relationship
As one variable increases, the other increases
Question 8: Regression Equation
Y = 5 + 2X
Find Y when X = 3
✅ Solution:
, [
Y = 5 + 2(3) = 11
]
✅ Answer:
Y = 11
Question 9: Break-even Analysis
Fixed cost = 1000
Price = 50
Variable cost = 30
✅ Solution:
[
BE = \frac{1000}{50-30} = \frac{1000}{20} = 50
]
✅ Answer:
50 units
Question 10: Time Series
Trend component represents?
✅ Answer:
Long-term movement in data
Question 11: Moving Average
Data: 10, 20, 30, 40
2-period MA:
2026 Updated | 100% Correct - Concordia University.
Section A: Questions 1–25
Question 1: Descriptive Analytics
A company recorded monthly sales (in $000):
12, 15, 18, 20, 25
a) Find the mean
b) Find the median
✅ Solution:
Mean:
[
\frac{12 + 15 + 18 + 20 + 25}{5} = \frac{90}{5} = 18
]
Median (middle value):
= 18
✅ Answer:
Mean = 18
Median = 18
Question 2: Range
Given data: 10, 22, 35, 40, 50
✅ Solution:
[
Range = Max - Min = 50 - 10 = 40
]
✅ Answer:
,Range = 40
Question 3: Variance
Data: 2, 4, 6, 8
✅ Solution:
Mean:
[
\frac{2+4+6+8}{4} = 5
]
Variance:
[
\frac{(2-5)^2+(4-5)^2+(6-5)^2+(8-5)^2}{4}
= \frac{9+1+1+9}{4} = \frac{20}{4} = 5
]
✅ Answer:
Variance = 5
Question 4: Standard Deviation
[
\sqrt{5} \approx 2.24
]
✅ Answer:
Standard deviation ≈ 2.24
Question 5: Probability
Probability of getting heads on a fair coin?
✅ Answer:
,[
\frac{1}{2} = 0.5
]
Question 6: Conditional Probability
P(A|B) = 0.3, P(B) = 0.5
Find P(A ∩ B)
✅ Solution:
[
P(A \cap B) = P(A|B) \times P(B) = 0.3 \times 0.5 = 0.15
]
✅ Answer:
0.15
Question 7: Correlation
If r = 0.9, what does it mean?
✅ Answer:
Strong positive relationship
As one variable increases, the other increases
Question 8: Regression Equation
Y = 5 + 2X
Find Y when X = 3
✅ Solution:
, [
Y = 5 + 2(3) = 11
]
✅ Answer:
Y = 11
Question 9: Break-even Analysis
Fixed cost = 1000
Price = 50
Variable cost = 30
✅ Solution:
[
BE = \frac{1000}{50-30} = \frac{1000}{20} = 50
]
✅ Answer:
50 units
Question 10: Time Series
Trend component represents?
✅ Answer:
Long-term movement in data
Question 11: Moving Average
Data: 10, 20, 30, 40
2-period MA: