MKT571 Week 1 QUIZ NEW

Question: #1125

BA 1605: Midterm Recap

Name _____________________________

50

Student ID _____________________________
Section 01B 10:00~11:20 am
Section 02B 01:00~02:20 pm

[Questions 4 ~ 7] The following table displays some of the data collected by the above research firm in
their study on online shopping.
Age

Gender

Household
Income

Participated in
online auction?

Monthly amount
spent online

hours /week browsing
online retailers

25
47
38
30

Male
Female
Female
Male

$55,000
$60,000
$110,000
$62,000

Yes
No
No
No

$250
$50
$120
$75

6
4
10
4

a) In the given data collection, which variables are categorical (or qualitative)? &
b) What will be the annual amount spent online for the second respondent?
c) The above data collection is based on ( ) data.
Which one is correct: cross-sectional or time-series?
d) What type of data collection method was most probably used here? And why do you think?

--------------------[Questions 8 ~ 10] Guests staying at Best Eastern Inn, NB. were asked to rate the quality of their
accommodations as being excellent, above average, average, below average, or poor. The ratings
provided by a sample of 30 guests are shown below. (Note: Rows 9-31 are not shown.)
A

1
2
3
4
5
6
7
8

Quality Rating
Above Average
Below Average
Above Average
Average
Average
Above Average
Above Average

B

C

Quality Rating
Poor
Below Average
Average
Above Average
Excellent
Total

D

E

Frequency
3
5
9
11
2
30

Relative Frequency

a) In Excel, which formula should be applied to D3 to find the frequency of poor?
b) If you copy the formula = D2/D$7 in Cell E2 and paste it to cell F4, what will be the formula in F4?
c) If they have the survey result about quality rating and location of hotel, which is the proper method to
analyze this dataset in Excel? (It asks about the command (or icon) in Excel.)

(BA1605 W15 Midterm Recap)

Page 2 of 4
Gender
Brand

[Questions 11 ~ 15] A large national retailer of electronics conducted a
survey to determine consumer preferences for various brands of digital
cameras. The table summarizes responses by camera brand and gender.

Sony
Canon
Nikon
Others
Total

a) List quantitative variables in the table:
List Categorical variables in the table:

Female Male
70
80
60
80
50
60
90
50
270
270

Total
150
140
110
140
540

b) What is the probability that a randomly selected respondent is a
female preferring Canon?
c) What is the marginal probability of brands Canon?
d) What is the probability that the male responses prefer Canon? (Given condition: MALE)
e) Does the data indicate that brand preference is independent of gender?
--------------------[Questions 16 ~ 25] Use the following data set:
a) [1] Medium=

Q1=

1

3

5

6

6

6

7

8

9

10 10 15 18

Q3=

b) [4] Central locations?
Calculation

Value

mean
median
mode
mid-hinge
mid-range
c) [4] Spread?
Calculation

Value

range
IQR
(sample) variance
standard deviation
coefficient of variation
d) [4] Sketch the boxplot, including fences?

e) [1] What is closest to the z-value for the largest data? (z =

)

You may use this
table for calculation.
x ( )2

1
3
5
6
6
6
7
8
9
10
10
15
18

(BA1605 W15 Midterm Recap)

Page 3 of 4

[Questions 27 ~ 33] Three airlines serve in Halifax International Airport. American Airline (AA) has
20% of all the scheduled flights, British Airline (AB) has 10%, and Air Canada (AC) has the remaining
70%. Their delayed (= not on-time) departure rates are 25%, 15%, and 10% respectively. We do not
consider the joint operation among airliners. Lets define the event as follows: Airline (A) A1: AA,
A2: AB, A3: AC; On-time (B) B1: On-time, B2: Not on-time.
P(Bj|Ai)
Airline

P(Bj and Ai)

Total
B1:
B2:
On-time Delayed

A1: AA

0.25

0.2

A2: AB

0.15
0.1

0.1

A3: AC

B1:

0.7

Total

B2:

A1
A2

P(Ai|Bj)
Total

B1:

B2:

A1
A2

A3

A3

Total

Total

A. What is the probability that
a) the plane selected at random is either AB or AC?
b) If we picked two planes at random, both of them were AB?
c) the plane selected randomly is AB and departs on-time?
d) the plane selected at random is AC or departs on-time?
e) a plane just leaving on time was AC?
f) a plane just leaving after delaying from the schedule was AC?
B. Are event A1 and event A2 independent?
--------------------[Questions 34 ~ 36] Suppose a supermarket is conducting a survey to find out the busiest time and day
for shoppers. Survey respondents are asked
1) whether they shopped on a weekday or on the weekend and
2) whether they shopped at the store before or after 5 pm.
It revealed that: 40% of shoppers visited the store
Weekday
before 5 pm. 30% of shoppers visited the store on a
Time
A1 (Yes) A2 (No)
Total
weekday ( Mon. Fri.) . 20% of shoppers visited the
B1 (Before 5)
store after 5 pm on a weekday.
B2 (After 5)
Start from making the contingency table for the joint
Total
probability.
a) What is closest to the probability that a randomly selected shopper who shops before 5 pm also shops
on a weekend?

b) What is the probability that a randomly selected shopper shops after 5 pm on weekend?

c) Are time and day of the week mutually exclusive events?

(BA1605 W15 Midterm Recap)

Page 4 of 4

[Questions 37 ~ 42] A commuter must
pass through five traffic lights on his way
to work and will have to stop at each one
that is red. After keeping record for 100
days, he is developing the probability
model for the number of red lights he hits:
a) What is the probability that a commuter
has only ONE red light?
b) What is the expected value of the given
data X? [E(X) = X*P(X).]

# of Red
Light (X)

Number
of Days

0

9

1

27

2

35

3

18

4

6

5

5

Sum

100

P(X)

X P(X)

[X - E(X)]2 [X - E(X)]2 * P(X)

c) What is the value for [X - E(X)]2 for X = 3?
d) What is the value for [X - E(X)]2* P(X) for X = 3?
e) What is the variance of X? [Var(X) = [X - E(X)]2*P(X).]
f) What is the standard deviation of X?

<Formulas>
Binomial Distribution
Poisson Distribution

P(x)
!

! ( )!

!

E(X)

Var(X)

np

npq

Remarks
0

=

1

a = 1, 0!=1,

0.5 =

[Questions 43 ~ 47] 35% of people have Type A blood. A bloodmobile has 5 vials of blood on a rack.
a) What is the probability that they dont find any A blood out of the 5 vials?
b) What is the probability that they find at least 1 sample of A blood out of the 5 vials?
c) What is the excel formula for the previous question?
d) How many A blood samples do you expect to get from 5 vials?
e) What is the standard deviation of the number of A blood samples in 5 vials?
--------------------[Questions 48 ~ 50] Snow storms occur randomly and independently over the course of winter in a Saint
John. The average is two snow storms every month. Assume that there are 4 weeks in a month.
a) What is the probability of only TWO snow storms in 2 weeks?
b) What is the probability of at least two snow storms this week?
c) What is the standard deviation of for the number of snow storm in one week?