statistic
Statistical Techniques in Business and Economics, 17e
Data File Spreadsheets
Chapter 1 Problem 17
Chapter 2 Problem 11
Chapter 2 Problem 12
Chapter 2 Problem 13
Chapter 2 Problem 14
Chapter 2 Problem 26
Chapter 2 Problem 29
Chapter 2 Problem 30
Chapter 2 Problem 31
Chapter 2 Problem 32
Chapter 2 Problem 33
Chapter 2 Problem 34
Chapter 2 Problem 37
Chapter 2 Problem 38
Chapter 2 Problem 40
Chapter 2 Problem 42
Chapter 2 Problem 43
Chapter 2 Problem 48
Chapter 2 Problem 50
Chapter 3 Problem 9
Chapter 3 Problem 10
Chapter 3 Problem 17
Chapter 3 Problem 18
Chapter 3 Problem 19
Chapter 3 Problem 20
Chapter 3 Problem 21
Chapter 3 Problem 22
Chapter 3 Problem 35
Chapter 3 Problem 36
Chapter 3 Problem 37
Chapter 3 Problem 38
Chapter 3 Problem 39
Chapter 3 Problem 40
Chapter 3 Problem 49
Chapter 3 Problem 50
Chapter 3 Problem 51
Chapter 3 Problem 52
Chapter 3 Problem 65
Chapter 3 Problem 66
Chapter 3 Problem 67
Chapter 3 Problem 68
Chapter 3 Problem 72
Chapter 3 Problem 77
Chapter 3 Problem 79
Chapter 3 Problem 80
Chapter 3 Problem 81
Chapter 3 Problem 82
Chapter 3 Problem 83
Chapter 4 Problem 9
Chapter 4 Problem 10
Chapter 4 Problem 11
Chapter 4 Problem 12
Chapter 4 Problem 13
Chapter 4 Problem 14
Chapter 4 Problem 18
Chapter 4 Problem 19
Chapter 4 Problem 20
Chapter 4 Problem 21
Chapter 4 Problem 22
Chapter 4 Problem 23
Chapter 4 Problem 29
Chapter 4 Problem 30
Chapter 4 Problem 31
Chapter 4 Problem 32
Chapter 4 Problem 33
Chapter 4 Problem 36
Chapter 4 Problem 37
Chapter 4 Problem 38
Chapter 4 Problem 39
Chapter 4 Problem 41
Chapter 4, Review Problem 1
Chapter 4, Review Problem 2
Chapter 4, Review Problem 3
Chapter 4, Review Problem 4
Table 4-1 Excel File
Chapter 5 Problem 3
Chapter 5 Problem 8
Chapter 5 Problem 13
Chapter 5 Problem 27
Chapter 5 Problem 29
Chapter 5 Problem 31
Chapter 5 Problem 50
Chapter 5 Problem 66
Chapter 6 Problem 1
Chapter 6 Problem 2
Chapter 6 Problem 3
Chapter 6 Problem 5
Chapter 6 Problem 6
Chapter 6 Problem 7
Chapter 6 Problem 8
Chapter 6 Problem 14
Chapter 6 Problem 15
Chapter 6 Problem 16
Chapter 6 Problem 17
Chapter 6 Problem 18
Chapter 6 Problem 21
Chapter 6 Problem 22
Chapter 6 Problem 23
Chapter 6 Problem 24
Chapter 6 Problem 39
Chapter 6 Problem 41
Chapter 6 Problem 42
Chapter 6 Problem 44
Chapter 6 Problem 53
Chapter 6 Problem 58
Chapter 7 Review Problem 4
Chapter 7 Review Problem 5
Chapter 8 Problem 11
Chapter 8 Problem 12
Chapter 8 Problem 41
Chart 8-3 Excel Sheet
Chapter 9 Problem 13
Chapter 9 Problem 14
Chapter 9 Problem 43
Chapter 9 Problem 44
Chapter 9 Problem 45
Chapter 10 Problem 14
Chapter 10 Problem 17
Chapter 10 Problem 18
Chapter 10 Problem 19
Chapter 10 Problem 20
Chapter 10 Problem 26
Chapter 10 Problem 33
Chapter 10 Problem 34
Chapter 10 Problem 35
Chapter 10 Problem 36
Chapter 10 Problem 37
Chapter 10 Problem 38
Chapter 10 Problem 39
Chapter 10 Problem 40
Chapter 10 Problem 41
Chapter 10 Problem 42
Chapter 10 Problem 45
Chapter 11 Problem 9
Chapter 11 Problem 11
Chapter 11 Problem 12
Chapter 11 Problem 16
Chapter 11 Problem 19
Chapter 11 Problem 20
Chapter 11 Problem 30
Chapter 11 Problem 31
Chapter 11 Problem 32
Chapter 11 Problem 33
Chapter 11 Problem 34
Chapter 11 Problem 35
Chapter 11 Problem 36
Chapter 11 Problem 37
Chapter 11 Problem 38
Chapter 11 Problem 41
Chapter 11 Problem 42
Chapter 11 Problem 43
Chapter 11 Problem 44
Chapter 11 Problem 45
Chapter 11 Problem 46
Chapter 12 Problem 9
Chapter 12 Problem 10
Chapter 12 Problem 11
Chapter 12 Problem 12
Chapter 12 Problem 17
Chapter 12 Problem 18
Chapter 12 Problem 19
Chapter 12 Problem 21
Chapter 12 Problem 22
Chapter 12 Problem 25
Chapter 12 Problem 29
Chapter 12 Problem 30
Chapter 12 Problem 31
Chapter 12 Problem 32
Chapter 12 Problem 33
Chapter 12 Problem 39
Chapter 12 Problem 40
Chapter 12 Problem 41
Chapter 12 Problem 42
Chapter 12 Problem 43
Chapter 12 Problem 44
Chapter 12 Problem 45
Chapter 12 Problem 47
Chapter 12 Problem 48
Chapter 12 Review Problem 2
Chapter 12 Review Problem 4
Chapter 12 Review Problem 5
Chapter 12 Review Problem 7
Chapter 13 Problem 1
Chapter 13 Problem 2
Chapter 13 Problem 3
Chapter 13 Problem 4
Chapter 13 Problem 5
Chapter 13 Problem 6
Chapter 13 Problem 12
Chapter 13 Problem 13
Chapter 13 Problem 14
Chapter 13 Problem 15
Chapter 13 Problem 16
Chapter 13 Problem 17
Chapter 13 Problem 18
Chapter 13 Problem 19
Chapter 13 Problem 20
Chapter 13 Problem 21
Chapter 13 Problem 22
Chapter 13 Problem 23
Chapter 13 Problem 24
Chapter 13 Problem 35
Chapter 13 Problem 36
Chapter 13 Problem 40
Chapter 13 Problem 40
Chapter 13 Problem 41
Chapter 13 Problem 43
Chapter 13 Problem 44
Chapter 13 Problem 45
Chapter 13 Problem 47
Chapter 13 Problem 48
Chapter 13 Problem 49
Chapter 13 Problem 50
Chapter 13 Problem 51
Chapter 13 Problem 52
Chapter 13 Problem 53
Chapter 13 Problem 56
Chapter 13 Problem 57
Chapter 13 Problem 58
Chapter 13 Problem 59
Chapter 13 Problem 61
Table 13-1 Excel Sheet
Table 14-1 Excel Sheet
Table 14-3 Excel Sheet
Chapter 14 Problem 9
Chapter 14 Problem 10
Chapter 14 Problem 11
Chapter 14 Problem 12
Chapter 14 Problem 20
Chapter 14 Problem 21
Chapter 14 Problem 22
Chapter 14 Problem 23
Chapter 14 Problem 24
Chapter 14 Problem 25
Chapter 14 Problem 26
Chapter 14 Problem 27
Chapter 14 Problem 28
Chapter 14 Problem 29
Chapter 14 Problem 30
Chapter 14 Problem 31
Chapter 14 Problem 32
Chapter 15 Problem 19
Chapter 15 Problem 20
Chapter 15 Problem 25
Chapter 15 Problem 26
Chapter 15 Problem 27
Chapter 15 Problem 28
Chapter 15 Problem 29
Chapter 15 Problem 30
Chapter 15 Problem 50
Chapter 15 Problem 51
Chapter 15 Problem 52
Chapter 15 Problem 53
Chapter 15 Problem 54
Chapter 15 Problem 55
Chapter 15 Problem 56
Chapter 15 Problem 57
Chapter 15 Problem 58
Chapter 15 Problem 59
Chapter 15 Problem 60
Chapter 16 Problem 11
Chapter 16 Problem 12
Chapter 16 Problem 13
Chapter 16 Problem 14
Chapter 16 Problem 15
Chapter 16 Problem 16
Chapter 16 Problem 17
Chapter 16 Problem 18
Chapter 16 Problem 21
Chapter 16 Problem 22
Chapter 16 Problem 23
Chapter 16 Problem 24
Chapter 16 Problem 25
Chapter 16 Problem 26
Chapter 16 Problem 27
Chapter 16 Problem 28
Chapter 16 Problem 34
Chapter 16 Problem 35
Chapter 16 Problem 36
Chapter 16 Problem 37
Chapter 16 Problem 38
Chapter 16 Problem 39
Chapter 16 Problem 40
Chapter 17 Problem 1
Chapter 17 Problem 17
Chapter 17 Problem 22
Chapter 18 Problem 4
Chapter 18 Problem 5
Chapter 18 Problem 6
Chapter 18 Problem 7
Chapter 18 Problem 8
Chapter 18 Problem 9
Chapter 18 Problem 16
Chapter 18 Problem 20
Chapter 19 Problem 7
Chapter 19 Problem 8
Chapter 19 Problem 10
Chapter 19 Problem 11
Chapter 19 Problem 12
Chapter 19 Problem 13
Chapter 19 Problem 14
Chapter 19 Problem 20
Chapter 19 Problem 22
Chapter 19 Problem 23
Chapter 19 Problem 24
Chapter 19 Problem 26
Chapter 19 Problem 27
Chapter 19 Problem 28
Chapter 19 Problem 29
Chapter 19 Problem 30
Chapter 19 Problem 32
Chapter 19 Problem 33
Chapter 19 Problem 34
Chapter 19 Problem 35
Data Sets
Appendices
Appendix E: Answers to Self-Review
ScreenCam Tutorials
Excel 2003: Creating Pie Charts
Excel 2003: Creating Scatter Plots
Excel 2003: Generating Descriptive Statistics
Excel 2003: Generating Regression Output
Excel 2003: Installing the Data Analysis Module
Excel 2007: Creating Pie Chart
Excel 2007: Customizing Toolbars
Excel 2007: Descriptive Statistics
Excel 2007: Generating Regression Output
Excel 2007: Installing Data Analysis ToolPak
Excel 2007: Creating Scatter Plot
Megastat: Frequency Distribution
Minitab: Descriptive Statistics using Minitab
Minitab: Introduction to Minitab
Minitab: Regression using Minitab
Excel Tutorials
CHAPTER 2: DESCRIBING DATA: FREQUENCY TABLES, FREQUENCY DISTRIBUTIONS, AND GRAPHIC PRESENTATIONS
Video #1: How to build a frequency table (Length: 5:13)
Video #2: How to build horizontal bar chart (Length: 5:08)
Video #3: How to build vertical bar chart (Length: 4:24)
Video #4: How to build pie chart (Length: 4:11)
Video #5: How to build line chart (Length: 1:59)
Video #6: How to build joint frequency distribution- pivot table (Length: 4:51)
Video #7: How to build frequency table using pivot table (Length: 4:05)
Video #8: How to build frequency distribution using pivot (Length: 5:35)
Video #9: How to build relative and cumulative frequency distribution (Length: 4:59)
Video #10: How to build frequency polygon with pivot table (Length: 4:28)
Video #11: How to build frequency polygon from frequency distribution (Length: 3:45)
Video #12: How to build a histogram with Histogram chart feature (Length: 3:52)
Video #13: How to build a cumulative frequency polygon with pivot table (Length: 5:29)
CHAPTER 3: DESCRIBING DATA: NUMERICAL MEASURES
Video #14: How to compute measures of central tendency (Length: 3:53)
Video #15: How to compute weighted average (Length: 5:13)
Video #16: How to calculate geometric mean (Length: 4:33)
Video #17: How to calculate range (Length: 2:42)
Video #18: How to calculate population variance and SD (Length: 3:51)
Video #19: How to calculate variance and SD for a sample (Length: 2:13)
Video #20: Using Descriptive Statistics to find measures of central tendency and dispersion (Length: 3:26)
Video #21: How to compute arithmetic mean and SD for grouped data (Length: 4:05)
Video #22: How to apply the Empirical Rule using Descriptive Statistics (Length: 4:16)
CHAPTER 4: DESCRIBING DATA: DISPLAYING AND EXPLORING DATA
Video #23: Building a Dot Plot (Length: 4:24)
Video #24: How to build a scatter diagram (Length: 5:22)
Video #25: How to build a stem-and-leaf display (Length: 5:09)
Video #26: How to compute quartiles and percentiles (Length: 5:09)
Video #27: How to build a boxplot in Excel (Length: 3:47)
Video #28: How to use Descriptive Statistics to evaluate skewness (Length: 2:54)
CHAPTER 5: A SURVEY OF PROBABILITY CONCEPTS
Video #29: How to build a contingency table with Pivot table (Length: 3:40)
Video #30: How to use Permut and Combin formulas (3:47)
Video #31: How to apply Bayes Theorem (Length: 54:33)
CHAPTER 6: DISCRETE PROBABILITY DISTRIBUTIONS
Video #32: How to build and graph discrete probability distribution (Length: 3:36)
Video #33: How to apply binomial distribution (Length: 4:48)
Video #34: How to apply hypergeometric distribution (Length: 4:41)
Video #35: How to apply Poisson.dist (Length: 3:31)
CHAPTER 7: CONTINUOUS PROBABILITY DISTRIBUTIONS
Video #36: Transforming continuous distribution to standard normal distribution (Length: 5:05)
Video #37: Using Norm.Dist to find probability in a normal distribution (Length: 5:21)
Video #38: How to apply norm.inv (Length: 2:52)
Video #39: How to apply norm.s.inv and norm.s.dist3 (Length: 4:36)
Video #40: How to use expondist and gammainv (Length: 5:28)
CHAPTER 8: SAMPLING METHODS AND THE CENTRAL LIMIT THEOREM
Video #41: Generating random numbers- three methods (Length: 5:50)
Video #42: Simple random sample with replacement (Length: 2:16)
Video #43: Simple random sample without replacement (Length: 3:29)
Video #44: Generating a stratified random sample (Length: 3:15)
Video #45: Generating a systematic random sample (Length: 3:05)
Video #46: Building a sampling distribution (Length: 5:43)
Video #47: Finding probability of a sample mean with normdist (Length: 3:31)
CHAPTER 9: ESTIMATION AND CONFIDENCE INTERVALS
Video #48: Confidence interval with Descriptive Statistics (Length: 2:46)
Video #49: Simulation of confidence intervals sigma known (Length: 4:01)
Video #50: Computing a confidence interval with confidence-t (Length: 2:04)
CHAPTER 10: ONE-SAMPLE TESTS OF HYPOTHESIS
Video #51: Conducting a one sample z test of the mean (Length: 4:27)
Video #52: Conducting a one sample t test of the mean (Length: 3:18)
Video #53: Computing beta and power (Length: 3:24)
CHAPTER 11: TWO-SAMPLE TESTS OF HYPOTHESIS
Video #54: Conducting a two sample t test assuming equal variance (Length: 5:49)
Video #55: Conducting a two sample z test independent populations (Length: 5:33)
Video #56: Conducting a two sample t test assuming unequal variance (Length: 5:57)
Video #57: Conducting a paired t test for two dependent samples (Length: 1:56)
CHAPTER 12: ANALYSIS OF VARIANCE
Video #58: Conducting an F test two sample for variances (Length: 4:04)
Video #59: Conducting a single factor ANOVA (Length: 3:30)
Video #60: Conducting ANOVA two factor with replication (Length: 3:57)
Video #61: Conducting ANOVA two factor without replication (Length: 3:56)
CHAPTER 13: CORRELATION AND LINEAR REGRESSION
Video #62: Computing correlation (Length: 2:50)
Video #63: How to run regression (Length: 4:55)
Video #64: How to transform data (Length: 4:36)
CHAPTER 14: MULTIPLE REGRESSION ANALYSIS
Video #65: How to build a multiple regression model (Length: 5:46)
CHAPTER 15: NONPARAMETRIC METHODS: NOMINAL LEVEL HYPOTHESIS TESTS
Video #66: Conducting a chi square test for observed vs. expected frequencies (Length: 5:11)
Video #67: Conducting a chi square test of independence for a contingency table (Length: 4:08)
CHAPTER 18: TIME SERIES AND FORECASTING
Video #68: Using least squares method to generate a trend line for a forecast (Length: 5:09)
Video #69: How to conduct a test for autocorrelation using Durbin Watson statistic (Length: 5:45)
Video #70: How to deseasonalize data to generate a trend adjusted equation (Length: 5:39)
CHAPTER 19: STASTISTICAL PROCESS CONTROL AND QUALITY MANAGEMENT
Video #71: How to build a Pareto chart (Length: 1:10)
Copyright