Lynda com Excel 2007 Business Statistics | D90C24C3ED620C6536BB9075143C73B67478D883

Lynda com Excel 2007 Business Statistics

Name	Lynda.com.Excel.2007.Business.Statistics	DOWNLOAD Copy Link
Total Size	2.1 GB
Total Files	58
Hash	D90C24C3ED620C6536BB9075143C73B67478D883

/0 Introduction/
Using the excerise files.flv	1.6 MB
Using the excerise files.mov	2.9 MB
Welcome.flv	10.4 MB
Welcome.mov	8.9 MB
/1 Introducing Statistics/
Introducing statistical analysis.mov	16.6 MB
Understanding statistical terms.mov	22.6 MB
Using statistics.mov	17.9 MB
/2 Learning Useful Excel Techniques/
1 Creating and using an Excel table.mov	36.0 MB
2 Installing the Analysis ToolPak.mov	20.2 MB
Auditing formulas step by step.mov	31.9 MB
/3 Summarizing Data Using Tables and Graphics/
1 Creating a frequency distribution using the FREQUENCY function.mov	28.8 MB
2 Summarizing data using bar graphs and pie charts.mov	34.2 MB
3 Creating frequency distributions for qualitative data.mov	36.4 MB
4 Creating a histogram.mov	21.0 MB
Calculating a running total.mov	43.6 MB
Summarizing data using a PivotTable.mov	62.2 MB
/4 Describing Data Using Numerical Methods/
1 Calculating mean, median, and mode.mov	61.9 MB
10 Calculating correlation.mov	32.1 MB
11 Calculating correlations for more than two data sets.mov	33.5 MB
2 Calculating a moving average.mov	23.9 MB
3 Calculating a seasonal forecast.mov	26.3 MB
4 Calculating percentiles and quartiles.mov	46.4 MB
5 Calculating variance and standard deviation.mov	45.9 MB
6 Summarizing data using descriptive statistics.mov	27.2 MB
7 Summarizing data using z-scores.mov	28.6 MB
8 Summarizing data using t-scores.mov	38.8 MB
9 Calculating covariance.mov	39.8 MB
Calculating and interpreting chi-square values.mov	22.1 MB
/5 Using Probability Distributions/
1 Visualizing the normal data distribution.mov	50.7 MB
2 Generating random values.mov	35.0 MB
3 Calculating binomial probabilities.mov	31.7 MB
4 Calculating probabilities using the exponential distribution.mov	47.6 MB
5 Calculating values using the Poisson distribution.mov	47.7 MB
6 Calculating dependent trials using the hypergeometric distribution.mov	47.0 MB
7 Calculating probabilities, permutations, and combinations.mov	71.5 MB
/6 Sampling Values from a Population/
1 Selecting effective data samples.mov	85.6 MB
2 Inferring a population mean from a sample mean.mov	51.4 MB
3 Inferring population distributions based on a proportion of the data set.mov	31.4 MB
4 Estimating the size of a population given numbered samples.mov	68.5 MB
5 Calculating a confidence interval for a large sample.mov	49.2 MB
6 Calculating a confidence interval for a small sample using t-tests.mov	36.8 MB
7 Calculating a confidence interval given a population proportion.mov	48.6 MB
8 Calculating sample size required for a given confidence level.mov	44.8 MB
/7 Testing Hypotheses/
1 Defining hypotheses and identifying errors.mov	19.1 MB
10 Analyzing variance using ANOVA.mov	29.4 MB
2 Performing one-tailed tests on a large sample's mean.mov	33.0 MB
3 Performing two-tailed tests on a large sample's mean.mov	51.8 MB
4 Testing a small sample's mean.mov	36.7 MB
5 Testing the mean of a population proportion.mov	41.5 MB
6 Estimating the difference between two populations' means.mov	47.6 MB
7 Testing hypotheses related to population means.mov	51.4 MB
8 Inferring results from matched samples selected from two populations.mov	37.0 MB
9 Analyzing variance using an F-test.mov	26.8 MB
/8 Using Linear and Multiple Regression/
1 Creating a linear regression line for an XY (scatter) chart.mov	17.6 MB
2 Analyzing and interpreting data from the Regression tool.mov	44.9 MB
3 Estimating and predicting data using the regression formula.mov	19.6 MB
4 Developing a multiple regression model.mov	32.3 MB
/Conclusion/
Additional Resources.mov	3.2 MB
Total files 58