The links below contain Excel97 files,
Word97 files, or
executable zip versions of the files. If you are using Internet
Explorer 4.0 or above, the files are listed in as a collapsible outline.
To expand the outline, click on the bullet to the left of the chapter's
files you would like to see.
 Chapter 11
 baseball_FA: Contains
the baseball free agency data set and Excel hypothesis test output for a dependent sample
hypothesis test for two means. 
 box_dot_plot: Creates
sidebyside box and dot plots for up to 4 groups. This is the same file as listed
for chapter 14. 
 conagra_SP500:
Contains the ConAgra and S&P 500 weekly returns from 10/20/97 to 10/12/98. A
hypothesis test for the ratio of two variances is performed. 
 chi_square_dist:
Shows how to calculate a critical value from the c^{2} distribution and the effect that different degrees of
freedom has on the c^{2} distribution. This is the same file as listed for Chapter 17.

 hand_grenades:
Contains the hand grenades data set. Shows how to construct a spreadsheet to perform
a hypothesis test for s^{2}. 
 hyp2_divyield:
Contains the dividend yield data and Excel hypothesis test output for an independent
sample hypothesis test for two means. 
 hyp2_drug: Contains the
drug clinical trial data and Excel hypothesis test output for a dependent sample
hypothesis test for two means. 

 Chapter 12
 3_stocks.xls: Contains the
Yahoo!, ConAgra, KPL and S&P 500 Index returns from 1/2/98 to 12/31/98. 
 Amazon_assign1.xls:
Shows an example of how to find regression models and plots for a Beta
coefficient analysis (similar to problem 12.79). The data used is Amazon.com's returns from 1/2/98 to 12/31/98.

 cba_courses:
College of Business Administration courses offered for the Fall 1999 semester. 
 CI_PI_Calc: Calculates
one confidence and prediction interval for a specific value of X. These intervals
are only for simple linear regression models. 
 HS_College_GPA:
Contains the high school and college data set, regression output, confidence and
prediction intervals, and sum of squares calculations. 
 invest: Investment data
set with scatter plots and correlation matrix. 
 least_squares_demo:
Demonstration of how the least squares method works for the GPA data set. 
 stability_testing:
Used to determine the shelflife of the drug data. Included is the regression output
and C.I. & P.I. bands on a scatter plot with an estimated regression line. 

 Chapter 13 (Test 1)
 Ad_responses: Contains
the number of advertisement responses data set, scatter plot holding circulation constant,
scatter plot holding advertisement size constant, and 3D scatter plot with estimated
regression plane. 
 body_fat: Contains the
body fat data set and homework questions. 
 ci_pi_mult_reg:
Calculates C.I.s and P.I.s for the dependent variable with up to five
independent variables. 
 F_Distribution:
Shows how to calculate a critical value from the Fdistribution and the effect that
different degrees of freedom has on the Fdistribution. 
 NBA_example: Contains
the NBA data set which is used for inclass examples. 

 Chapter 13 (Test 2)
 add_line_to_plot:
This is a Word file that contains screen captures illustrating how to
add a linear line to an Excel XY plot. 
 car_mpg_data: Contains
the car highway miles per gallon (MPG) data set. The data source is http://www.eren.doe.gov/feguide/. 
 ft_cm_age:
Shows how to convert feet and inches to centimeters. Also shows
how to find the age in years of a person. 

NBA_model_building:
Contains
the regression output and plots for the complete analysis of the NBA data set using all
independent variables. 
 stability_testing_13_11:
Contains the data for the stability testing example used in Sections 13.11 and 13.13.
Included are Excel regression outputs and scatter plots with estimated regression
lines for different levels of lot. 
 stemandleaf:
Constructs a stemandleaf plot. 
 unequal_variances:
Example of using the natural logarithm transformation to solve an unequal variances
problem. 

 Chapter 14
 box_dot_plot: Creates
sidebyside box and dot plots for up to 4 groups. This is the same file as listed
for chapter 11. 
 CRD_mult_comp: Finds
the ANOVA table and performs the Bonferroni multiple comparison procedure for CRDs. 
 golf_balls: Contains the
golf ball distance data set. RCB and CRD analyses are included.

 healthy_choice:
Contains the Healthy Choice Cereal design types' sales data. A CRD analysis is
included using the Excel "ANOVA: Single Factor" analysis tool and using
formulas. Oneatime multiple comparisons may be done in the multiple_comparisons
sheet. The Using ANOVA formulas sheet is set up to allow users to add constants
to the data in individual treatments. The formulas and the dot plot on this sheet
automatically update to illustrate what effect changes in the data have on the ANOVA
results. 
 RCB_mult_comp: Finds
the ANOVA table and performs the Bonferroni multiple comparison procedure for
RCBs. 

 Chapter 16
 CPI: Contains the consumer
price index data set. 
 KSU_enroll: Contains the
KSU enrollment data set. Included are the plots, formulas, and output associated
with exponential smoothing, regression, and 2point moving average models. 
 KU_enroll: Contains the
KU enrollment data set. 
 McDonalds: Contains the
McDonald's revenues data set. The Excel file comes from Levine, Berenson, &
Stephan (1997). 
 russell3000: Contains
the Russell 3000 Index data set. Included are the 5, 10, 30, 60point moving
average and the W=0.1, 0.5, 0.75, 0.90 exponential smoothing models with plots. 
 S_P_500: Contains
startoftheweek S&P 500 Index values from 1/3/94 to 7/13/98. 
 sunspots: Contains the
yearly number of sunspots data set. 
 volleyball: Shows how to
calculate the weighted composite index for the cost of playing volleyball. 

 Chapter 17
 Bird: Contains the Larry Bird
free throw shooting data set and the formulas to perform a hypothesis test for
independence in a twoway table. 
 chi_square_dist: Shows how to calculate a critical value from the c^{2} distribution and
the effect that different degrees of freedom has on the c^{2} distribution. This is the same
file as listed for Chapter 11. 
 chi_test:
Performs hypothesis tests for independence in 2x2, 2x3, 3x3, 2x4, 2x5,
and 4x5 tables. Graphs are shown to illustrate the degree of
deviance from independence. 
 M&Ms_test:
Contains the M&M's data set and the formulas to perform a hypothesis test for
categorical probabilities in a oneway table. 
 17.35: Contains the #17.35
data set and the formulas to perform a hypothesis test for categorical probabilities in a
oneway table. 

This web page was last updated at
09/02/03 08:37 PM


Need Help?
Excel
Downloading
Unzipping 