 | Kvanli, Pavur, and
Guynes CD files (no longer available) |
| Chapter 1 (none) |
| Chapter 2
|
| Chapter 3
 | box_dot_plot.xls
- Side-by-side 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 |
| EX3-76_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
1980-1 and 1981-2 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
t-distribution 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 |
| Ex9-71_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 |
|
