در این آموزش تصویری با محاسبات آماری در Excel 2007 آشنا می شوید. این دوره تجزیه و تحلیل های آماری ، استفاده از ابزارها در اکسل ، کار با فرمول ها و توابع را آموزش می دهد. در ادامه نحوه ایجاد جدول ، ساخت histogram ، شناسایی خطا و اشکال زدایی برنامه را می آموزید.
این دوره آموزشی محصول موسسه Lynda است.

سرفصل های دوره:

  • تجزیه و تحلیل های آماری
  • کار با مفاهیم آماری
  • تکنیک های کار با محاسبات آماری
  • استفاده از جدول
  • کار با فرمول ها در اکسل
  • نحوه استفاده از جداول
  • نحوه استفاده از نمودارها
  • استفاده از تابع فرکانس
  • نحوه ساخت histogram
  • نحوه استفاده از PivotTable
  • توصیف داده ها با استفاده روشهای عددی
  • نحوه استفاده از آمار های توصیفی
  • محاسبه کوواریانس
  • استفاده از توزیع های احتمالی
  • انتخاب نمونه داده ها
  • تعریف فرضیه ها
  • شناسایی خطا
  • اشکال زدایی برنامه
  • و…

عنوان دوره: Lynda Excel 2007: Business Statistics
سطح: متوسط
مدت زمان: 4 ساعت و 19 دقیقه
نویسنده: Curt Frye


Excel 2007: Business Statistics with Curtis Frye shows managers and executives how to assess their organization's data effectively by applying statistical analysis techniques. The course covers important statistical terms and definitions, and then dives into techniques using the tools in Excel: formulas and functions for calculating averages and standard deviations, charts and graphs for summarizing data, and the Analysis ToolPak add-in for even greater insights into data. Exercise files are included with the course.
Topics include:
Understanding statistical terms
Creating a basic Excel table
Auditing formulas
Creating frequency distributions for qualitative data
Calculating a running total
Creating a histogram
Using PivotTables
Calculating mean, median, mode, and other numerical data
Using probability distributions
Population sampling
Testing hypotheses
Developing liner and multiple regression models

2m 14s
1m 25s
Using the exercise files
1. Introducing Statistics
10m 17s
Introducing statistical analysis
3m 27s
Understanding statistical terms
4m 25s
Using statistics
2m 25s
2. Learning Useful Excel Techniques
11m 14s
Creating and using an Excel table
4m 50s
Installing the Analysis ToolPak
2m 41s
Auditing formulas step by step
3m 43s
3. Summarizing Data Using Tables and Graphics
28m 23s
Creating frequency distributions for qualitative data
4m 42s
Summarizing data using bar graphs and pie charts
4m 44s
Creating a frequency distribution using the FREQUENCY function
4m 0s
Creating a histogram
2m 55s
Calculating a running total
5m 6s
Summarizing data using a PivotTable
6m 56s
4. Describing Data Using Numerical Methods
55m 3s
Calculating mean, median, and mode
7m 2s
Calculating a moving average
3m 10s
Calculating a seasonal forecast
3m 34s
Calculating percentiles and quartiles
5m 54s
Calculating variance and standard deviation
6m 59s
Summarizing data using descriptive statistics
3m 47s
Summarizing data using z-scores
3m 24s
Summarizing data using t-scores
4m 55s
Calculating covariance
5m 1s
Calculating correlation
4m 11s
Calculating correlations for more than two data sets
3m 41s
Calculating and interpreting chi-square values
3m 25s
5. Using Probability Distributions
39m 33s
Visualizing the normal data distribution
6m 19s
Generating random values
4m 30s
Calculating binomial probabilities
4m 1s
Calculating probabilities using the exponential distribution
5m 58s
Calculating values using the Poisson distribution
5m 6s
Calculating dependent trials using the hypergeometric distribution
5m 46s
Calculating probabilities, permutations, and combinations
7m 53s
6. Sampling Values from a Population
48m 22s
Selecting effective data samples
9m 19s
Inferring a population mean from a sample mean
6m 9s
Inferring population distributions based on a proportion of the data set
4m 10s
Estimating the size of a population given numbered samples
7m 17s
Calculating a confidence interval for a large sample
5m 44s
Calculating a confidence interval for a small sample using t-tests
4m 25s
Calculating a confidence interval given a population proportion
5m 34s
Calculating sample size required for a given confidence level
5m 44s
7. Testing Hypotheses
48m 11s
Defining hypotheses and identifying errors
5m 15s
Performing one-tailed tests on a large sample's mean
3m 56s
Performing two-tailed tests on a large sample's mean
5m 46s
Testing a small sample's mean
4m 16s
Testing the mean of a population proportion
5m 21s
Estimating the difference between two populations' means
5m 37s
Testing hypotheses related to population means
5m 42s
Inferring results from matched samples selected from two populations
4m 38s
Analyzing variance using an F-test
3m 48s
Analyzing variance using ANOVA
3m 52s
8. Using Linear and Multiple Regression
14m 45s
Creating a linear regression line for an XY (scatter) chart
2m 30s
Analyzing and interpreting data from the Regression tool
4m 57s
Estimating and predicting data using the regression formula
3m 19s
Developing a multiple regression model
3m 59s
1m 3s
Additional Resources
1m 3s

حجم فایل: 1.1GB