 Kvanli, Pavur, and
Guynes CD files (no longer available) 
 Chapter 1 (none) 
 Chapter 2

 Chapter 3
 box_dot_plot.xls
 Sidebyside box and
dot plots template for
up to 4 variables 
 CV_ex.xls
 Shows how to calculate
the CV 
 data_summary.xls
 Chris
Malone's summary
statistics, histogram,
box plot, and dot plot
for one variable
spreadsheet 
 EX376_new.xls
 Exercise 3.76 
 fg_data.xls
 A random sample of 399 field goals attempted during the 1995 NFL regular
season 
 invest.xls
 June 1991 to April
2001 historical returns
for the Dow Jones
Industrial's Average,
S&P 500 Index, and
Russell 2000 Index 
 NU_OSU.xls
 NU and OSU football
series scores; summary
statistics are
calculated 
 NU_OSU_box_dot.xls
 Example of using the box_dot_plot.xls
file with the NU and OSU
scores data 
 simple_GPA.xls
 Shows how to calculate
the population and
sample means, medians,
standard deviations, and
variances 
 variation_ex.xls
 Example histograms
used to show differences
in variation 

 Chapter 4
 Bird.xls
 Contingency table of
Larry Bird's first and
second free throw
attempts during the
19801 and 19812 NBA
seasons. 

 Chapter 5
 binomial_dist.xls
 Interactive
spreadsheet showing the
shape of the binomial
distribution 
 fg.xls
 Field goal kicking and
the binomial
distribution 
 fifty_numbers.xls
 50 numbers drawn at
random with equal
probability from 0, 1,
..., 9. 
 plinko.xls
 Probability
distributions for Plinko 
 Plinko
JAVA applet  This
was written by Chris
Malone at Kansas
State University.
Note that this is a
smaller board than the
regular Plinko
board. To view all
100 trials, open this is
in Netscape. 
 pois.xls
 Interactive
spreadsheet showing the
shape of the Poisson
distribution 
 tele.xls
 Telephone calls and
the Poisson
distribution 

 Chapter 6
 exp.xls
 Interactive
spreadsheet showing the
shape of the exponential
distribution 
 gen_norm.xls
 1,000 MPG generated
from a normal
distribution 
 grade_bell.xls
 Find probabilities for
grades using a normal
distribution assumption 
 grand_am_normal.xls
 Find probabilities for
the MPG of a Grand Am
using a normal
distribution assumption 
 normal_dist.xls
 Interactive
spreadsheet showing the
shape of the normal
distribution 
 stand_norm_prob.xls
 Interactive
spreadsheet showing probabilities
for the standard normal
distribution 
 stand_norm_tables.xls
 Shows how to find a
table of values from the
standard normal
distribution 
 uniform.xls
 Interactive
spreadsheet showing the
shape of the uniform
distribution 

 Chapter 7
 CI_ex.xls
 Based on CLT_GPA_ex.xls;
calculates 1,000
confidence intervals and
finds the proportion of
intervals that contain
the population mean 
 CLT_GPA_ex.xls
 Central Limit Theorem
example with GPAs 
 healthy_choice.xls
 Finding probabilities
using the distribution
of the sample mean; the
data involves Health
Choice cereal box weight 
 light_bulb.xls
 Finds a confidence
interval for the
population mean light
bulb lifetime 
 pizza.xls
 Finds the sample size
needed for the pizza
sales example 
 obtain_rs.xls
 Random sample of size
10 from numbers 1,...,20
and random sample of
size 120 from numbers
1,..., 21000 
 T_stand_norm.xls
 Interactive template
comparing the
tdistribution to a
standard normal
distribution 

 Chapter 8
 hyp_1sample_pic.xls
 Interactive
spreadsheet performing a
one sample hypothesis
test for the mean using
Excel's functions 
 hyp_volleyball_data.xls
 Volleyball data set
used for a one sample
hypothesis test for the
mean; gives output from
using Excel's Data
Analysis tool 

 Chapter 9
 cpt.xls
 Shows how to perform a
hypothesis test for the
difference between 2
means with dependent
samples; the data are
hits from the Continuous
Performance Test 
 div_yield.xls
 Shows how to perform a
hypothesis test for the
difference between 2
means with independent
samples; the data are
dividend yields for the
NYSE and NASDAQ 
 Ex971_new.xls
 Exercise 9.71 

 Chapter 10
 m_m.xls
 Template to perform a
hypothesis test for a
population proportion;
the data are M&M's
color proportions 
 pat.xls
 Template to find a
confidence interval for
a population proportion;
the data are PATs for
the 1995 NFL season 

 Chapter 14
 CI_PI_calc.xls
 Template that
calculates a confidence
interval and predication
interval in simple
linear regression 
 HS_college_GPA.xls
 High school GPA is
used to predict college
GPA 
 invest_ch14.xls
 June 1991 to April
2001 historical returns
for the Dow Jones
Industrial's Average,
S&P 500 Index, and
Russell 2000 Index 
 Least_squares_demo.xls
 Demonstration
of how the least squares
method works for the GPA
data set 
