Excel
Home
Chat Room
Excel
Grades
Homework
Links
Message Board
Projects
Schedule
Syllabus
Tests & Quizzes
Word

 

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.  
bulletKvanli, Pavur, and Guynes CD files (no longer available)
bulletChapter 1 (none)
bulletChapter 2
bulletEX2-59_new.xls - Exercise 2.59
bullethighest_point.xls - Data contains the highest elevations for each state in the United States
bulletNU_OSU_ch2.xls - NU and OSU football series scores; frequency distributions and histograms are constructed
bulletStem-and-leaf plot.xls - Template to calculate stem-and-leaf plots
bulletChapter 3
bulletbox_dot_plot.xls - Side-by-side box and dot plots template for up to 4 variables
bulletCV_ex.xls - Shows how to calculate the CV
bulletdata_summary.xls - Chris Malone's summary statistics, histogram, box plot, and dot plot for one variable spreadsheet
bulletEX3-76_new.xls - Exercise 3.76
bulletfg_data.xls - A random sample of 399 field goals attempted during the 1995 NFL regular season
bulletinvest.xls - June 1991 to April 2001 historical returns for the Dow Jones Industrial's Average, S&P 500 Index, and Russell 2000 Index
bulletNU_OSU.xls - NU and OSU football series scores; summary statistics are calculated
bulletNU_OSU_box_dot.xls - Example of using the box_dot_plot.xls file with the NU and OSU scores data
bulletsimple_GPA.xls - Shows how to calculate the population and sample means, medians, standard deviations, and variances
bulletvariation_ex.xls - Example histograms used to show differences in variation
bulletChapter 4
bulletBird.xls - Contingency table of Larry Bird's first and second free throw attempts during the 1980-1 and 1981-2 NBA seasons.
bulletChapter 5
bulletbinomial_dist.xls -  Interactive spreadsheet showing the shape of the binomial distribution
bulletfg.xls - Field goal kicking and the binomial distribution 
bulletfifty_numbers.xls - 50 numbers drawn at random with equal probability from 0, 1, ..., 9.  
bulletplinko.xls - Probability distributions for Plinko
bulletPlinko 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.  
bulletpois.xls - Interactive spreadsheet showing the shape of the Poisson distribution
bullettele.xls - Telephone calls and the Poisson distribution 
bulletChapter 6
bulletexp.xls - Interactive spreadsheet showing the shape of the exponential distribution
bulletgen_norm.xls - 1,000 MPG generated from a normal distribution 
bulletgrade_bell.xls - Find probabilities for grades using a normal distribution assumption
bulletgrand_am_normal.xls - Find probabilities for the MPG of a Grand Am using a normal distribution assumption
bulletnormal_dist.xls - Interactive spreadsheet showing the shape of the normal distribution
bulletstand_norm_prob.xls - Interactive spreadsheet showing probabilities for the standard normal distribution
bulletstand_norm_tables.xls - Shows how to find a table of values from the standard normal distribution
bulletuniform.xls - Interactive spreadsheet showing the shape of the uniform distribution
bulletChapter 7
bulletCI_ex.xls - Based on CLT_GPA_ex.xls; calculates 1,000 confidence intervals and finds the proportion of intervals that contain the population mean
bulletCLT_GPA_ex.xls - Central Limit Theorem example with GPAs 
bullethealthy_choice.xls - Finding probabilities using the distribution of the sample mean; the data involves Health Choice cereal box weight
bulletlight_bulb.xls - Finds a confidence interval for the population mean light bulb lifetime
bulletpizza.xls - Finds the sample size needed for the pizza sales example
bulletobtain_rs.xls - Random sample of size 10 from numbers 1,...,20 and random sample of size 120 from numbers 1,..., 21000
bulletT_stand_norm.xls - Interactive template comparing the t-distribution to a standard normal distribution 
bulletChapter 8
bullethyp_1sample_pic.xls - Interactive spreadsheet performing a one sample hypothesis test for the mean using Excel's functions
bullethyp_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
bulletChapter 9
bulletcpt.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
bulletdiv_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
bulletEx9-71_new.xls - Exercise 9.71
bulletChapter 10
bulletm_m.xls - Template to perform a hypothesis test for a population proportion; the data are M&M's color proportions
bulletpat.xls - Template to find a confidence interval for a population proportion; the data are PATs for the 1995 NFL season
bulletChapter 14
bulletCI_PI_calc.xls - Template that calculates a confidence interval and predication interval in simple linear regression
bulletHS_college_GPA.xls - High school GPA is used to predict college GPA
bulletinvest_ch14.xls - June 1991 to April 2001 historical returns for the Dow Jones Industrial's Average, S&P 500 Index, and Russell 2000 Index
bulletLeast_squares_demo.xls - Demonstration of how the least squares method works for the GPA data set

 

Need Help?
Excel
Downloading

 

© 2001 Christopher R. Bilder