[Assassins]

lynda.com | Excel 2007: Business Statistics [2010] [EN] PCRec

Автор (режиссер): lynda.com
Название: Excel 2007: Business Statistics
Год выпуска: 2010
Жанр: Excel
Язык: EN
Качество видео: PCRec
Продолжительность: 04:19:09
Видеокодек: Advanced Video Codec (AVC)
Битрейт видео: ~296 - 1150 кбит/с
Размер кадра: 960 x 540
Аудиокодек: Advanced Audio Codec (AAC)
Битрейт аудио: 100 - 127 Кбит/сек 2 канала 48,0 КГц

Описание:
Курс Excel 2007: Business Statistics с автором Curtis Frye показывает менеджерам и исполнителям, как эффективно оценивать организованные данные, применяя техники статистического анализа. Курс охватывает важные статистические термины и определения, затем углубляется в техники использования инструментов Excel: формулы и функции для расчета среднего и стандартного отклонения, диаграммы и графики для суммирования данных и Analysis ToolPak.

Introduction

Welcome 1:25 9.5 MB

Using the exercise files 0:49 1.0 MB

1. Introducing Statistics

Introducing statistical analysis 3:28 8.1 MB

Understanding statistical terms 4:26 12.6 MB

Using statistics 2:25 3.9 MB

2. Learning Useful Excel Techniques

Creating and using an Excel table 4:50 8.3 MB

Installing the Analysis ToolPak 2:41 5.5 MB

Auditing formulas step by step 3:43 6.9 MB

3. Summarizing Data Using Tables and Graphics

Creating frequency distributions for qualitative data 4:42 7.9 MB

Summarizing data using bar graphs and pie charts 4:44 8.1 MB

Creating a frequency distribution using the FREQUENCY function 4:00 6.8 MB

Creating a histogram 2:55 5.3 MB

Calculating a running total 5:06 9.7 MB

Summarizing data using a PivotTable 6:56 14.3 MB

4. Describing Data Using Numerical Methods

Calculating mean, median, and mode 7:02 12.2 MB

Calculating a moving average 3:10 5.8 MB

Calculating a seasonal forecast 3:34 6.4 MB

Calculating percentiles and quartiles 5:54 10.1 MB

Calculating variance and standard deviation 6:59 11.2 MB

Summarizing data using descriptive statistics 3:47 7.1 MB

Summarizing data using z-scores 3:24 6.3 MB

Summarizing data using t-scores 4:55 8.1 MB

Calculating covariance 5:01 8.9 MB

Calculating correlation 4:11 6.3 MB

Calculating correlations for more than two data sets 3:41 6.8 MB

Calculating and interpreting chi-square values 3:25 5.3 MB

5. Using Probability Distributions

Visualizing the normal data distribution 6:19 11.1 MB

Generating random values 4:30 7.5 MB

Calculating binomial probabilities 4:01 6.7 MB

Calculating probabilities using the exponential distribution 5:58 9.8 MB

Calculating values using the Poisson distribution 5:06 8.9 MB

Calculating dependent trials using the hypergeometric distribution 5:46 14.4 MB

Calculating probabilities, permutations, and combinations 7:53 15.8 MB

6. Sampling Values from a Population

Selecting effective data samples 9:19 15.8 MB

Inferring a population mean from a sample mean 6:09 11.2 MB

Inferring population distributions based on a proportion of the data set 4:10 6.6 MB

Estimating the size of a population given numbered samples 7:17 12.9 MB

Calculating a confidence interval for a large sample 5:45 9.8 MB

Calculating a confidence interval for a small sample using t-tests 4:25 7.9 MB

Calculating a confidence interval given a population proportion 5:34 9.9 MB

Calculating sample size required for a given confidence level 5:44 9.2 MB

7. Testing Hypotheses

Defining hypotheses and identifying errors 5:15 6.0 MB

Performing one-tailed tests on a large sample's mean 3:56 6.9 MB

Performing two-tailed tests on a large sample's mean 5:46 10.3 MB

Testing a small sample's mean 4:16 7.7 MB

Testing the mean of a population proportion 5:21 9.5 MB

Estimating the difference between two populations' means 5:37 10.4 MB

Testing hypotheses related to population means 5:42 10.2 MB

Inferring results from matched samples selected from two populations 4:38 8.3 MB

Analyzing variance using an F-test 3:48 6.7 MB

Analyzing variance using ANOVA 3:52 7.0 MB

8. Using Linear and Multiple Regression

Creating a linear regression line for an XY (scatter) chart 2:30 4.6 MB

Analyzing and interpreting data from the Regression tool 4:57 8.7 MB

Estimating and predicting data using the regression formula 3:20 5.7 MB

Developing a multiple regression model 3:59 7.7 MB

Conclusion

Additional Resources 1:03 1.1 MB

Скриншоты:


Время раздачи: с 23:00 до 8:00 (днём по возможности) до первых пяти скачавших
Заранее извиняюсь за низкую скорость раздачи... быстро скачать не получится...
Отдельная благодарность Группе "Uploaders" и лично slava03 за поддержку релизов