Type
Quiz
Book Title
Basic Marketing Research: Using Microsoft Excel Data Analysis 3rd Edition
ISBN 13
978-0135078228

### 978-0135078228 Chapter 12 Solution Manual Part 2

June 7, 2019
CASE SOLUTIONS
Case 12.1The Pets, Pets, & Pets Survey
Case Objective: Students must use the proper formulas and interpretations to perform
the various generalization analyses necessary.
1. How often did Pets, Pets, & Pets customers visit it last year?
3.6 to 5.2 times
2. How much did they typically spend on the last visit?
162
\$16.89 to \$19.51
3. How likely are they to buy a Pets, Pets, & Pets on their next visit?
162
1
5.1 to 5.5
4. What percent are “regular” Pets, Pets, & Pets customers?
p x q
n
44.4 x55.6
162
36.7% to 52.1%
5. What percent has recommended Pets, Pets, & Pets to friends?
p x q
n
82.1 x17.9
162
76.2% to 88.0%
6. The manager at Pets, Pets, & Pets believes that, on average, store customers own
two pets. Is this belief supported by the survey?
s
n
.77
.06
Because -6.0 is greater than -1.96, the hypothesis is not supported. The confidence
interval is:
=¿
2
162
1.5 to 1.8 pets
7. The manager also believes that Pets, Pets, & Pets monthly newspaper advertising
is highly effective and reaches 80% of the store’s customers. Is this belief
supported by the survey?
= –8.49
Because -8.49 is greater than -1.96, the hypothesis is not supported. The
confidence interval is:
n
Case 12.2 Integrated Case: The Advanced Automobile Concepts Survey
Generalization Analysis
Case Objective: Students must use the XL Data Analyst with the Advanced Automobile
Concepts data set to perform and interpret various generalization
analyses.
3
1. What percent of the American public owns the following type of
vehicle?
The “primary vehicle type” variable is categorical, so compute 95%
confidence intervals to the two answer categories of “economy” and
“standard.”
Primary Vehicle Price Type
Category
Frequen
cy Percent
Lower
Boundar
y
Upper
Boundar
y
“SUV or van” is a category in the Primary vehicle type variable, so
compute a 95% confidence interval for it.
Primary Vehicle Type
Category
Frequenc
y Percent
Lower
Boundar
y
Upper
Boundar
y
2. How does the American public feel about the following statements?
a. Hybrid autos that use alternative fuels will reduce fuel
4
The same metric scale is used for all three statements, so compute
95% confidence intervals for the averages.
Variable Sample Average
Standard
Deviation
Lower
Boundary
Upper
Boundary
Hybrid autos that use
alternative fuels will keep
Hybrid autos that use
alternative fuels will reduce
Hybrid autos that use
alternative fuels will slow
3. Prtincipals at Advanced Automobile Concepts fully understand that
there is resistance to change in Zen.There are some senior
executives who grew up during America’s “romance with the
automobile” era of the 1950s and 1960s and who believe that most
Americans want a large and powerful automobile.These executives
point out that SUVs are extremely popular despite global warming
warnings that have been issued for the past decade and numerous
Hybrid Vehicle Type Probabilit
y
Probability of buying a very small (one-seat) hybrid auto within 3 years?
Probability of buying a small (two-seat) hybrid auto within 3 years?
Probability of buying an economy size hybrid auto within 3 years?
5
Probability of buying a standard size synthetic fuel auto within 3 years?
Probability of buying a standard size electric auto within 3 years?
Test these hypotheses with the finding from the survey.
Probability is measured with a metric scale, so use the average
Hypothesis Test for an Average
Variable Description Sample
Sample
Average
Hypoth.
Average
small (one-seat) hybrid auto
Does the sample support the hypothesized average?
At 95% level of confidence, this hypothesis is: NOT SUPPORTED
Variable Sample Average
Standard
Deviatio
n
Lower
Boundary
Upper
Boundar
y
small (1 seat) hybrid auto
Hypothesis Test for an Average
Variable Description Sample
Sample
Average
Hypoth.
Average
(two-seat) hybrid auto within 3
6
years
Does the sample support the hypothesized average?
At 95% level of confidence, this hypothesis is: NOT SUPPORTED
Variable
Sampl
e Average
Standard
Deviation
Lower
Boundary
small (two-seat) hybrid
Hypothesis Test for an Average
Variable Description Sample
Sample
Average
Hypoth.
Average
economy size hybrid auto
Does the sample support the hypothesized average?
At 95% level of confidence, this hypothesis is: NOT SUPPORTED
Variable Sample Average
Standard
Deviation
Lower
Boundary
Upper
Boundary
an economy size
hybrid auto within 3
7
Hypothesis Test for an Average
Variable Description Sample
Sample
Average
Hypoth.
Average
Does the sample support the hypothesized average?
At 95% level of confidence, this hypothesis is NOT SUPPORTED
Variable Sample Average
Standard
Deviation
Lower
Boundary
Upper
Boundary
standard size hybrid
Hypothesis Test for an Average
Variable Description Sample
Sample
Average
Hypoth.
Average
Does the sample support the hypothesized average?
At 95% level of confidence, this hypothesis is: NOT SUPPORTED
8
Variable Sample Average
Standard
Deviation
Lower
Boundary
Upper
Boundary
a large size hybrid
3. Using the finding from the survey, estimate the number of
vehicles of each of the following hybrid types that are expected to
be purchased over the next three years.
One must use the 95% confidence intervals for these averages to estimate the population
averages. The lower boundary percent times “There is an estimated 111,617,402