【Lynda】Excel 2007: Business Statistics【CHN】中英文字幕[SRT]
==========教程信息=====================================================
教程名称：Excel 2007: Business Statistics
作者：Curt Frye
主题：Business, Data Analysis, Finance
使用软件：Excel 2007
难度等级：中级
时长： 4h 19m
发布日期： Dec 08, 2010
┏ACELY STUDIO，2012
┃更多资源请访问
┃◆唯一发布站：ACELY.CN
┗◆我的博客：http://blog.sina.com.cn/u/1991840741
==========教程目录文件列表=============================================
Excel 2007- Business Statistics[SRT]
├─◆0. Introduction
│ └─◇ 0001 Welcome.srt
│ └─◇ 0002 Using the exercise files.srt
├─◆1. Introducing Statistics
│ └─◇ 0101 Introducing statistical analysis.srt
│ └─◇ 0102 Understanding statistical terms.srt
│ └─◇ 0103 Using statistics.srt
├─◆2. Learning Useful Excel Techniques
│ └─◇ 0201 Creating and using an Excel table.srt
│ └─◇ 0202 Installing the Analysis ToolPak.srt
│ └─◇ 0203 Auditing formulas step by step.srt
├─◆3. Summarizing Data Using Tables and Graphics
│ └─◇ 0301 Creating frequency distributions for qualitative data.srt
│ └─◇ 0302 Summarizing data using bar graphs and pie charts.srt
│ └─◇ 0303 Creating a frequency distribution using the FREQUENCY function.srt
│ └─◇ 0304 Creating a histogram.srt
│ └─◇ 0305 Calculating a running total.srt
│ └─◇ 0306 Summarizing data using a PivotTable.srt
├─◆4. Describing Data Using Numerical Methods
│ └─◇ 0401 Calculating mean, median, and mode.srt
│ └─◇ 0402 Calculating a moving average.srt
│ └─◇ 0403 Calculating a seasonal forecast.srt
│ └─◇ 0404 Calculating percentiles and quartiles.srt
│ └─◇ 0405 Calculating variance and standard deviation.srt
│ └─◇ 0406 Summarizing data using descriptive statistics.srt
│ └─◇ 0407 Summarizing data using z-scores.srt
│ └─◇ 0408 Summarizing data using t-scores.srt
│ └─◇ 0409 Calculating covariance.srt
│ └─◇ 0410 Calculating correlation.srt
│ └─◇ 0411 Calculating correlations for more than two data sets.srt
│ └─◇ 0412 Calculating and interpreting chi-square values.srt
├─◆5. Using Probability Distributions
│ └─◇ 0501 Visualizing the normal data distribution.srt
│ └─◇ 0502 Generating random values.srt
│ └─◇ 0503 Calculating binomial probabilities.srt
│ └─◇ 0504 Calculating probabilities using the exponential distribution.srt
│ └─◇ 0505 Calculating values using the Poisson distribution.srt
│ └─◇ 0506 Calculating dependent trials using the hypergeometric distribution.srt
│ └─◇ 0507 Calculating probabilities, permutations, and combinations.srt
├─◆6. Sampling Values from a Population
│ └─◇ 0601 Selecting effective data samples.srt
│ └─◇ 0602 Inferring a population mean from a sample mean.srt
│ └─◇ 0603 Inferring population distributions based on a proportion of the data set.srt
│ └─◇ 0604 Estimating the size of a population given numbered samples.srt
│ └─◇ 0605 Calculating a confidence interval for a large sample.srt
│ └─◇ 0606 Calculating a confidence interval for a small sample using t-tests.srt
│ └─◇ 0607 Calculating a confidence interval given a population proportion.srt
│ └─◇ 0608 Calculating sample size required for a given confidence level.srt
├─◆7. Testing Hypotheses
│ └─◇ 0701 Defining hypotheses and identifying errors.srt
│ └─◇ 0702 Performing one-tailed tests on a large sample’s mean.srt
│ └─◇ 0703 Performing two-tailed tests on a large sample’s mean.srt
│ └─◇ 0704 Testing a small sample’s mean.srt
│ └─◇ 0705 Testing the mean of a population proportion.srt
│ └─◇ 0706 Estimating the difference between two populations’ means.srt
│ └─◇ 0707 Testing hypotheses related to population means.srt
│ └─◇ 0708 Inferring results from matched samples selected from two populations.srt
│ └─◇ 0709 Analyzing variance using an F-test.srt
│ └─◇ 0710 Analyzing variance using ANOVA.srt
├─◆8. Using Linear and Multiple Regression
│ └─◇ 0801 Creating a linear regression line for an XY (scatter) chart.srt
│ └─◇ 0802 Analyzing and interpreting data from the Regression tool.srt
│ └─◇ 0803 Estimating and predicting data using the regression formula.srt
│ └─◇ 0804 Developing a multiple regression model.srt
├─◆Conclusion
│ └─◇ Additional Resources.srt
◇
【本字幕由ACELY.CN独家制作发布】
┏
┃本套教程字幕包含中文字幕
┃中文字幕使用机器翻译，对翻译结果中不当内容不承担任何责任！
┃更多中文字幕请访问唯一发布站【ACELY.CN】
┃本站中文字幕未经允许一律严禁转载！
┗