lynda - Excel - Excel 2007 Business Statistics

1. 06 Sampling Values from a Population/1 Selecting effective data samples.mov81.65MB
2. 05 Using Probability Distributions/7 Calculating probabilities, permutations, and combinations.mov68.21MB
3. 06 Sampling Values from a Population/4 Estimating the size of a population given numbered samples.mov65.33MB
4. 03 Summarizing Data Using Tables & Graphics/6 Summarizing data using a PivotTable.mov59.34MB
5. 04 Describing Data Using Numerical Methods/1 Calculating mean, median, and mode.mov58.99MB
6. 07 Testing Hypotheses/3 Performing two-tailed tests on a large sample's mean.mov49.37MB
7. 06 Sampling Values from a Population/2 Inferring a population mean from a sample mean.mov49.03MB
8. 07 Testing Hypotheses/7 Testing hypotheses related to population means.mov49MB
9. 05 Using Probability Distributions/1 Visualizing the normal data distribution.mov48.38MB
10. 06 Sampling Values from a Population/5 Calculating a confidence interval for a large sample.mov46.95MB
11. 06 Sampling Values from a Population/7 Calculating a confidence interval given a population proportion.mov46.38MB
12. 05 Using Probability Distributions/5 Calculating values using the Poisson distribution.mov45.45MB
13. 05 Using Probability Distributions/4 Calculating probabilities using the exponential distribution.mov45.36MB
14. 07 Testing Hypotheses/6 Estimating the difference between two populations' means.mov45.35MB
15. 05 Using Probability Distributions/6 Calculating dependent trials using the hypergeometric distribution.mov44.81MB
16. 04 Describing Data Using Numerical Methods/4 Calculating percentiles and quartiles.mov44.25MB
17. 04 Describing Data Using Numerical Methods/5 Calculating variance and standard deviation.mov43.73MB
18. 08 Using Linear & Multiple Regression/2 Analyzing and interpreting data from the Regression tool.mov42.85MB
19. 06 Sampling Values from a Population/8 Calculating sample size required for a given confidence level.mov42.76MB
20. 03 Summarizing Data Using Tables & Graphics/5 Calculating a running total.mov41.54MB
21. 07 Testing Hypotheses/5 Testing the mean of a population proportion.mov39.54MB
22. 04 Describing Data Using Numerical Methods/9 Calculating covariance.mov37.95MB
23. 04 Describing Data Using Numerical Methods/8 Summarizing data using t-scores.mov37.04MB
24. 07 Testing Hypotheses/8 Inferring results from matched samples selected from two populations.mov35.32MB
25. 06 Sampling Values from a Population/6 Calculating a confidence interval for a small sample using t-tests.mov35.07MB
26. 07 Testing Hypotheses/4 Testing a small sample's mean.mov34.98MB
27. 03 Summarizing Data Using Tables & Graphics/3 Creating frequency distributions for qualitative data.mov34.76MB
28. 02 Learning Useful Excel Techniques/1 Creating and using an Excel table.mov34.33MB
29. 05 Using Probability Distributions/2 Generating random values.mov33.38MB
30. 03 Summarizing Data Using Tables & Graphics/2 Summarizing data using bar graphs and pie charts.mov32.62MB
31. 04 Describing Data Using Numerical Methods/11 Calculating correlations for more than two data sets.mov31.95MB
32. 07 Testing Hypotheses/2 Performing one-tailed tests on a large sample's mean.mov31.48MB
33. 08 Using Linear & Multiple Regression/4 Developing a multiple regression model.mov30.83MB
34. 04 Describing Data Using Numerical Methods/10 Calculating correlation.mov30.61MB
35. 02 Learning Useful Excel Techniques/3 Auditing formulas step by step.mov30.42MB
36. 05 Using Probability Distributions/3 Calculating binomial probabilities.mov30.23MB
37. 06 Sampling Values from a Population/3 Inferring population distributions based on a proportion of the data set.mov29.91MB
38. 07 Testing Hypotheses/10 Analyzing variance using ANOVA.mov28.04MB
39. 03 Summarizing Data Using Tables & Graphics/1 Creating a frequency distribution using the FREQUENCY function.mov27.43MB
40. 04 Describing Data Using Numerical Methods/7 Summarizing data using z-scores.mov27.3MB
41. 04 Describing Data Using Numerical Methods/6 Summarizing data using descriptive statistics.mov25.93MB
42. 07 Testing Hypotheses/9 Analyzing variance using an F-test.mov25.56MB
43. 04 Describing Data Using Numerical Methods/3 Calculating a seasonal forecast.mov25.08MB
44. 04 Describing Data Using Numerical Methods/2 Calculating a moving average.mov22.82MB
45. 01 Introducing Statistics/2 Understanding statistical terms.mov21.59MB
46. 04 Describing Data Using Numerical Methods/12 Calculating and interpreting chi-square values.mov21.04MB
47. 03 Summarizing Data Using Tables & Graphics/4 Creating a histogram.mov20.06MB
48. 02 Learning Useful Excel Techniques/2 Installing the Analysis ToolPak.mov19.3MB
49. 08 Using Linear & Multiple Regression/3 Estimating and predicting data using the regression formula.mov18.73MB
50. 07 Testing Hypotheses/1 Defining hypotheses and identifying errors.mov18.25MB
51. 01 Introducing Statistics/3 Using statistics.mov17.06MB
52. 08 Using Linear & Multiple Regression/1 Creating a linear regression line for an XY (scatter) chart.mov16.75MB
53. 01 Introducing Statistics/1 Introducing statistical analysis.mov15.87MB
54. 00 Introduction/1 Welcome.mov8.45MB
55. 09 Conclusion/Additional Resources.mov3.04MB
56. 00 Introduction/2 Using the excerise files.mov2.75MB