              If you are using Internet Explorer 4.0 or above, the files are listed in a collapsible outline.  To expand the outline, click on the bullet to the left of the chapter's programs that you would like to see.  If "(none)" is listed after a chapter, no programs are currently available. Kvanli, Pavur, and Guynes CD files (no longer available) Chapter 1 (none) Chapter 2 EX2-59_new.xls - Exercise 2.59 highest_point.xls - Data contains the highest elevations for each state in the United States NU_OSU_ch2.xls - NU and OSU football series scores; frequency distributions and histograms are constructed Stem-and-leaf plot.xls - Template to calculate stem-and-leaf plots 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

Need Help?
Excel