آنالیز های آماری در اکسل Statistical Analysis Using Excel

<< آموزش تخصصی PivotTables, PowerPivot, Power View, GeoFlow با MrExcel آموزش تخصصی و کاربردی اکسل با MrExcel >>

Statistical Analysis Using Excel LiveLessons

آموزش حرفه ای و کاربردی توابع آماری در اکسل.به کمک این مجموعه که توسط Conrad Carlberg ارائه شده است می توانید آنالیز های آماری در اکسل را انجام دهید

کلاس های آنلاین اکسل کاربردی

Statistical Analysis Using Excel LiveLessons is the world’s first complete video training course of its kind on the topic

Bestselling author and trainer Conrad Carlberg provides the novice with 7+ hours of hands-on step-by-step video training on the fundamentals of statistical analysis. These videos make the concepts concrete using Excel charts, tools, and functions. Statistical analysis takes two main forms: descriptive statistics and inferential statistics. Descriptive statistics provide numbers that describe how values cluster together (averages), disperse (standard deviations), and vary together (correlations). Inferential statistics informs us regarding the probability that the descriptive statistics that we calculate from samples are accurate estimators of the populations from which we took the samples. These techniques are well worked out in theory and in applications such as Microsoft Excel. They have applicability in fields as diverse as politics and sports, as economics and agriculture, as psychology and business management, as achievement testing and manufacturing. This training on statistical analysis is designed to provide conceptual overviews of topics such as testing the reliability of the difference between the means of a treatment group and a control group, followed by demonstrations of how to handle the topic in Excel. Topics such as statistical power are crucial to understanding inferential analysis but history shows that they are very difficult to communicate through text. By using auditory explanations in combination with Excel's powerful charting capabilities, it's possible to communicate these abstract notions in a concrete fashion.

 

Part I: About Excel and Statistical Analysis

 Accuracy of functions

 Appropriate use of statistical functions

 Overview of the Data Analysis Add-in

 

Part II: Using Excel one variable at a time

 Central Tendency 1

 Central Tendency 2

 Variability 1

 Variability 2

 Variability 3

 Array formulas using statistical functions

 Array formulas or pivot tables?

 Confidence intervals

 Descriptive Statistics tool

 Confidence intervals with the Descriptive Statistics tool

 

Part III: Using one variable to analyze another

 Two variables at a time

 Correlation and scattercharts

 Regression and shared variance

 Regression diagnostics

 Understanding regression coefficients

 Testing the overall regression with the F ratio

 Forecasting with the TREND() function

 

Part IV: Basic hypothesis testing

 Hypothesis testing: single sample z tests

 Single sample z tests: Excel’s normal distribution functions

 Z tests, alpha and statistical power

 

Part V: Using the t distribution in Excel

 Mean differences and the t distribution

 Two-sample t tests Two-sample t tests

 Recap of consistency and compatibility functions

 

LiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include: IT Certification, Programming, Web Development, Mobile Development, Home & Office Technologies, Business & Management, and more.  View All

مشخصات
زبان آموزش انگلیسی
مدت زمان آموزش 7:04
ویرایش 2012
نوع تصویری(Multimedia)
تعداد DVD 1
سطح مقدماتی-متوسط-پیشرفته-حرفه ای
هزینه حمل دارد
اوپن کارت فارسی
فروشگاه اینترنتی محصولات آموزشی آفیس © 2016