• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 10 out of 51 pages
Exam (elaborations)

Practical Business Statistics (8th Edition, 2023) – Solutions Manual – Siegel

Document preview thumbnail
Preview 10 out of 51 pages

INSTANT PDF DOWNLOAD — Solutions Manual for Practical Business Statistics (8th Edition, 2023) by Andrew F. Siegel and Michael R. Wagner. Covers all chapters with complete, step-by-step solutions for data analysis, regression, hypothesis testing, probability, and business forecasting using Excel and statistical tools. Ideal for business and data analytics students. business statistics solutions manual, Andrew Siegel statistics book, practical business statistics answers, business data analysis workbook, regression and correlation problems, probability and hypothesis testing guide, Excel statistics exercises, quantitative business analysis manual, applied business statistics workbook, statistics for MBA students, data analytics with Excel solutions, business forecasting examples, statistical decision making manual, applied probability workbook, business research methods statistics, business quantitative methods guide, statistical computing for business, step-by-step business statistics, Wiley business statistics solutions, business statistics practice problems

Content preview

ALL CHAPTERS COVERED




SOLUTIONS MANUAL

, Contents



1. Introduction: Defining the Role of 11. Correlation and Regression:
Statistics in Business 1 Measuring and Predicting
Relationships 27
2. Data Structures: Classifying the
Various Types of Data Sets 2 12. Multiple Regression: Predicting
One Variable from Several
3. Histograms: Looking at the Others 31
Distribution of the Data 3
13. Report Writing: Communicating
4. Landmark Summaries: Interpreting the Results of a Multiple
Typical Values and Percentiles 6 Regression 34

5. Variability: Dealing with Diversity 10 14. Time Series: Understanding
Changes Over Time 35
6. Probability: Understanding
Random Situations 13 15. ANOVA: Testing for Differences
among Many Samples, and
7. Random Variables: Working with Much More 38
Uncertain Numbers 16
16. Nonparametrics: Testing with
8. Random Sampling: Planning Ahead Ordinal Data or Nonnormal
for Data Gathering 18 Distributions 42

9. Confidence Intervals: Admitting 17. Chi-Squared Analysis: Testing
that Estimates are not Exact 20 for Patterns in Qualitative Data 45

10. Hypothesis Testing: Deciding 18. Quality Control: Recognizing and
between Reality and Coincidence 22 Managing Variation 47




iii

, Chapter 1


Introduction
Defining the Role of Statistics in Business


Odd Problem Solutions
1. Exercise for student.
3. Exercise for student.
5. Exercise for student.
7. Designing the study (to produce the needed numbers).
9. Exploring the data (looking through the accounting
information).
11. Designing the study (while you would like, ultimately, to
estimate, the initial phase involves design because no
data are yet available).
13. Modeling the data (identifying the model and its para-
meters before the model is used for estimation and
hypothesis testing).
15. Exploring the data (looking at the data).
17. Hypothesis testing (deciding whether or not the defect
rate has increased).
19. Modeling the data (developing a system of equations
with model parameters).




Practical Business Statistics, Student Solutions Manual. DOI: 10.1016/B978-0-12-387722-2.00001-9 1
© 2012 Andrew F. Siegel. Published by Elsevier, Inc. All rights reserved.

, Chapter 2


Data Structures
Classifying the Various Types of Data Sets

advertising, (b) last year’s spending for radio advertising,
Odd Problem Solutions
and (c) last year’s spending for newspaper advertising.
1. Exercise for the student. Elementary units are competitors.
3. Exercise for the student.
17. a. Bivariate.
5. a. Exercise for the student.
b. Cross-sectional.
b. Exercise for the student.
19. a. Qualitative.
7. Multivariate analysis could be used to predict one vari-
b. Ordinal.
able (your profit) based on several others (competitors’
21. a. Models (of cell phones) are elementary units.
performance, state of the economy, and time of year).
b. Multivariate.
9. This is a multivariate cross-sectional data set consisting
of secondary data. c. Cross-sectional.
11. a. The individual employee is the elementary unit for d. Nominal.
this data set. e. Quantitative.
b. Multivariate. f. Ordinal.
c. Salary and years of experience are quantitative. 23. Ordinal.
Gender and education are qualitative. 25. a. Vacuum cleaners are the elementary units.
d. Education is ordinal qualitative because the cate- b. Multivariate.
gories can be put in a meaningful order from least c. Quantitative: price and weight. Qualitative: quality
to most education. and type.
e. Cross-sectional. d. Quality is ordinal. Type is nominal.
13. a. Months are the elementary units. e. Cross-sectional.
b. Bivariate. 27. a. The elementary units are days.
c. Both of these variables are quantitative. b. Multivariate.
d. Time-series. c. All variables are quantitative.
15. Multivariate cross-sectional data. All variables are quan- d. No variables are qualitative.
titative. Variables are (a) last year’s spending for TV e. Time-series.




Practical Business Statistics, Student Solutions Manual. DOI: 10.1016/B978-0-12-387722-2.00002-0 2
© 2012 Andrew F. Siegel. Published by Elsevier, Inc. All rights reserved.

, Chapter 3


Histograms
Looking at the Distribution of the Data


Odd Problem Solutions b. Typically, CREF has invested $0 to $200 million in
each firm, with one exceptions around $350 million.
1. Approximately normal. c. The distribution is skewed (with a long tail toward
3. Skewed (with a long tail towards higher values). high values).
5. a. 2 contracts. d. The following table gives the base 10 logarithm
b. 3 contracts. of the dollar amounts, so that the first number is
c. No, you can only tell that it lost more than 50% of log10(2,035,000) = 6.309. Other correct answers are
its value but not more than 100%. possible, either using base e logarithm or else using
d. 24 contracts. the numbers in thousands as given: for the first com-
e. Skewed (with a long tail towards high values) with 3 pany listed, you would find log10(2,035) = 3.309,
outliers. loge(2,035,000) = 14.526, or loge(2,035) = 7.618.
7. a. 6

5 Market Log10 of
Number of companies




Value Market
4 Company (Thousands) Value
3 AAR Corp. 2,035 6.309
Alliant Techsystems, Inc. 5,133 6.710
2 Armor Holdings, Inc. 1,758 6.245
BAE Systems PLC 31,984 7.505
1 Boeing Co. 364,299 8.561
Echostar Communications Corp. 14,464 7.160
0 Empresa Brasileira
−15 −5 5 15 25 de Aeronautica S.A. 317 5.501
3-month percentage price change
General Dynamics Corp. 150,671 8.178
b. 0 General Motors Corp. 183,967 8.265
9 Heico Corp. 740 5.869
4 Hexcel Corp. 1,162 6.065
3 Kaman Corp. 2,141 6.331
4
7 2 Lockheed Martin Corp. 81,234 7.910
1 7 6 Moog, Inc. 745 5.872
+ + + + Motient Corp. 784 5.894
−0 0 1 2 Northrop Grumman Corp. 29,878 7.475
3-month percentage price change
Orbital Sciences Corp. 770 5.886
c. Shares have appreciated typically by about 10% to Panamsat Corp. 4,861 6.687
20%. Pegasus Communications Corp. 4,640 6.667
Perkinelmer, Inc. 28,371 7.453
9. a.
Number of companies




20 Precision Cast Parts Corp. 9,822 6.992
Raytheon Co. A 31,952 7.504
15 Raytheon Co. B 25,787 7.411
Remec, Inc. 2,147 6.332
10 Rolls-Royce PLC 40,110 7.603
Smith Group PLC 9,263 6.967
5
Teledyne Technologies, Inc. 4,009 6.603
0 Thales (Ex Thomson CFS) 45,169 7.655
0 100,000 200,000 300,000 400,000 Triumph Group, Inc. 2,875 6.459
Portfolio value ($ thousands) Zodiac S.A. 13,429 7.128



Practical Business Statistics, Student Solutions Manual. DOI: 10.1016/B978-0-12-387722-2.00003-2 3
© 2012 Andrew F. Siegel. Published by Elsevier, Inc. All rights reserved.

,4 Student Solutions Manual



e. 7 19. a. 12


Number of companies
6 10




Number of firms
5 8
4
6
3
2 4
1 2
0 0
4 5 6 7 8 9 10 0 20 40 60 80
Log of portfolio value Revenue loss in millions

Note that the scale may differ according to the type b. The distribution is skewed (toward high values), and
of logarithm used and whether dollars or thousands shows two large gaps with three outliers. In particu-
are used, but the shape of the distribution will be lar, 13 of the 16 data values are crammed into the
basically the same in each case. first two columns of the display.
f. Approximately normal and fairly symmetric. 21. a. 32
11. a. 8,000 28
Number of donots




7,000 24




Frequency
6,000 20
5,000
16
4,000
3,000 12
2,000 8
1,000 4
0
0 20 40 60 80 100 120 0
0 20 40
Number of gifts Number of defective motors
in each batch of 250
b. Very skewed towards high values.
b. The distribution is markedly skewed (with a long tail
13. 5 1
towards high values), with two extreme outliers.
0 8 7
8 7 2 8 c. The outliers are at 25 & 41.
6 6 3 4 d. Outliers removed
9 5 8 2 3 1 12
3 9 7 4 7 1
Frequency




10 20 30 40 50 60 70 8

Average hospital charge
4
15. a. 8
Number of firms




6 0
0 2 4 6 8
Number of defective motors
4 in each batch of 250

2 e. In two particular batches, a large numbers of motors
were rejected for poor quality. Otherwise quality
0 has been approximately normally distributed,
$0 $1 $2 $3 $4 extending from about 0 to 8 rejections, and with a
CEO compensation (millions)
typical value approximately 4.
b. Approximately normal, possibly with an outlier. 23.
17. a. 6
Number of companies




18
16 5
Frequency




14
12 4
10 3
8
6 2
4
2 1
0 0
0 50,000 100,000 150,000 9% 10% 11%
Net income ($ thousands) Interest rate

b. Skewed with an outlier (possibly two outliers). Approximately normal.

,Chapter | 3 Histograms 5



25. a. 29. a. 9
12 8
10 7




Frequency
Frequency 6
8 5
6 4
3
4 2
2 1
0 0
−20% −10% 0% 10% 20% 30% 40%
0 50 100 150 200 250
Change in value of dollar
Salary (thousands)
b. Approximately normal with an outlier.
31. a. 0 4
b. Skewed (with a long tail towards high values).
1 4
c. Typical salaries were from about $40,000 to about 1 3
$100,000, with some even higher. The skewness 1 2
indicates that lower salaries are more likely than 1 1 8
higher salaries in general. 5 2 1 8
0 6 2 0 6
1 7 3 0 5
27. 10 1 8 3 0 5
+ + + + + +
−10 −0 −0 0 0 10
8
Percent change in DJIA companies
Frequency




6 b.


Number of companies
10
4 8
6
2
4

0 2
3 4 5 0
Price (dollars) −20% −10% 0% 10% 20%
Percent change in DJIA companies
Approximately normal. c. Approximately normal.

, Chapter 4


Landmark Summaries
Interpreting Typical Values and Percentiles


Odd Problem Solutions i. The 90th percentile is 30 defects per day.
1. a. Average is 15.6 defects per day. j. The percentile ranking is approximately 87%, as can
b. Median is 14 defects per day. be seen from the cumulative distribution function,
c. 5
as follows:
100%
4 90%
Number of days




80%
3 70% 29 defects is the




Percent of total
60% 87th percentile
2 50%
40%
1 30%
20%
0 10%
0 10 20 30 40
0%
Daily number of defective cars 0 10 20 30
Number of defects
d. Mode is 7.5 defects per day. (With quantitative data 90th percentile
the mode is defined as the value at the highest point is 30 defects
of the histogram, perhaps as the midpoint of the 3. The mean (also called the average) should be used because
highest bar). With a different histogram (different total amounts are important. While skewness can be a
bar widths, for example) a different value of the problem, there is only a small amount of skewness.
mode could be found. 5. a.
e. Lower quartile is 6, upper quartile is 24.5 defects
Number of countries




15
per day.
f. Smallest is 0, largest is 34 defects per day. 10
g. 35
Number of defects per day




5
30
25 0
0% 10% 20% 30% 40%
20
Vat rate
15
Approximately normal (perhaps slightly skewed
10
with a longer tail towards low values).
5 b. 18.18% average.
0 c. 19.6% median.
h. d. They are close to one another, as we expect for an
100%
90% approximately normal distribution.
80% e. 100%
Percent of total




70%
Cumulative percent




80%
60%
50% 60%
40%
30% 40%
20%
20%
10%
0% 0%
0 10 20 30 0% 10% 20% 30%
Number of defects Vat rate




Practical Business Statistics, Student Solutions Manual. DOI: 10.1016/B978-0-12-387722-2.00004-4 6
© 2012 Andrew F. Siegel. Published by Elsevier, Inc. All rights reserved.

,Chapter | 4 Landmark Summaries 7



f. 15.0% and 22.0% (these are the 20 th and 80 th c. 7
percentiles respectively).
6
g. About the 23rd percentile, for a VAT tax of 16%).




Number of samples
7. a. Beta = 0.981. This is a weighted average of the betas 5

(2.4, 0.6, and 1.2) weighted according to the market 4
values (shares times price: 3,500; 17,600, and 7,950).
3
b. Selling all shares of Spec. Comp. will realize $35 ×
100 = $3,500. This will buy $3,500/53 = 66 shares 2

of Dependable Conglomerate. Added to the origi- 1
nal, gives 216 shares of Dependable Conglomerate.
0
The new portfolio would consist of: 40 60 80 100 120 140 160 180 200 220 240

200 shares Conservative Industries Breaking strength in pounds
at $88 per share, beta = 0:6 Median Average
216 shares Dependable Conglomerate
The average and the median are not the same. The
at $53 per share, beta = 1:2
average is larger than the median due to skewness
The beta of this new portfolio, 0.836, has indeed of the distribution.
decreased from 0.981.
9. $13.80, computed as the weighted average. d. 100%

11. a. 80%




Cumulative percent
Per capita
income
60%


Median 40%
household
income
20%

$0 $50,000 $100,000 $150,000 $200,000
Income 0%
75 100 125 150 175 200
b. The distribution of median household income is Breaking strength (pounds)
generally higher than that of per capita income. e. The 10th percentile is 79 pounds, i.e. 10% have a
(This may be explained by the fact that the income breaking strength of 79 pounds or less. The 90th
of a household often combines the income of more percentile is 177 pounds.
than one person). f. No, these supplies do not qualify. These supplies
13. Overall market penetration of 19.75%, using a weighted can provide a breakage value of 100 pounds or
average. more only about 50% of the time. Since manage-
15. Per capita tax burden is $2,288.46, the weighted aver- ment would like the breakage value to be less
age per-capita-tax, weighted by population. than 100 pounds a maximum of 10% of the time,
17. The upper quartile is 75. you would compare to the 10th percentile. This
19. a. The five number summary is $49,489, $59,872, would need to be at least 100 pounds for these
$84,777, $163,220, and $189,058. conditions to be met.
b. 25. a. The average share is 8.19%. The median share
is 4.90%.

$0 $50,000 $100,000 $150,000 $200,000
b. 100%
Revenues 90%
80%
Cumulative percent




21. a. Average loan fee is 1.61%. 70%
b. Median loan fee is 1.75%. 60%
c. The mode is 2.00%, with 7 out of the 14 cases 50%
40%
having this value. Alternately, the midpoint of the
30%
highest bar of a histogram might be used to find a 20%
value close to 2%. 10%
d. It might be argued that the mode is the most useful 0%
description of the typical loan fee, since half the 0% 5% 10% 15% 20% 25% 30%
Share
banks are charging this amount. However, the mode
is also the largest value, an extreme value, and so c. The 80th percentile is 17.2%
one of the other summaries might be preferable. 27. a. The average is −1.09%.
23. a. The average is 115.35. b. On average the dollar weakened (because the average
b. The median is 100. percent change is negative).

, 8 Student Solutions Manual



c. The median is −2.80%. The average is higher d. The five-number summary is $317,000; $2,035,000;
primarily due to the outlier (Brazil). $7,198,000; $31,952,000; $364,299,000.
d. 30% e.
25%
20%
Percent change




15%
10%
5%
0%
−5%
−10%
$0 $100,000 $200,000 $300,000 $400,000
29. a. The average yield is 5.22%. Portfolio value ($ thousands)

b. The median yield is 5.21%. There are two suggestions of skewness here: (1) the
c. The lower quartile is 5.13%. The upper quartile is median is not at the center of the box and (2) the
5.27%. line to the largest value is much longer than
d. The five-number summary is 4.91%, 5.13%, 5.21%, the line to the smallest value.
5.27%, 5.83%. f. Yes. With skewness like this (with a long tail
e. towards large values) we expect the average to be
larger than the median.
33. a. 42.1% (this is 8/19).
b. Law of Desire.
c. They are the same.
35. a. There are 5 outliers: Oracle Corp at 56.81, Bmc
Software Inc at 10.9, Nuance Communications Inc
at 9.91, Rosetta Stone Inc at 9.51, Sybase Inc at
9.29. These are all larger than 1.5 times the inter-
4.8% 5.0% 5.2% 5.4% 5.6% 5.8% 6.0%
quartile range, which is 8.915.
Yield

f. There are two upper outliers: MI StrgcFnd Itd Rf Rv
at 5.64% and HghlndCoHlthFcs FL hospRv at
5.83%. Here is the detailed box plot:
0 10 20 30 40 50 60
CEO compensation ($ millions)

b. Sybase Rosetta stone Nuance BMC




0 2 4 6 8 10 12
CEO compensation ($ millions)
4.8% 5.0% 5.2% 5.4% 5.6% 5.8% 6.0%
Yield 37. a. $4,000,000
Archer-Daniels-Midland
CEO compensation




g. 100%
$3,000,000
75%
$2,000,000 Campbell soup
50%
$1,000,000
25%
Wrigley
$0
0%
4.8% 5.0% 5.2% 5.4% 5.6% 5.8% 6.0% b. $850,000.
Yield
39. a. The average is 4.39. The median is 3.
h. 5.40% is the 90th percentile. b. The average is now 2.92. The median is still 3.
i. The 60th percentile is 5.2% (or 5.23%). c. The average is very sensitive to the presence of out-
31. a. The average is $36,483,900. liers. Removing them reduced the average value
b. The median is $7,198,000. from 4.39 to 2.92; this is a sizable percentage change
c. The average is larger than the median. for the average value. The median is unchanged by

Document information

Uploaded on
November 5, 2025
Number of pages
51
Written in
2025/2026
Type
Exam (elaborations)
Contains
Questions & answers
$20.99

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
TestBanksStuvia
3.9
(331)
Sold
3246
Followers
1210
Items
2232
Last sold
1 hour ago



Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions