الإحصاء باستخدام Excel للأعمال والاقتصاد

الشرح: excelisfun | تنظيم المصادر: بوصلة

استخدم الجداول لاستكشاف الأفكار الإحصائية، وفسّر معنى الناتج وحدود الاستنتاج بدل التركيز على الصيغة وحدها. الشرح من excelisfun، والدروس متاحة بالترتيب داخل الدورة.

  • 0 متعلّمين
  • 22 س 26 د
  • كل المستويات
  • elposla

عن هذه الدورة

الإحصاء باستخدام Excel: ماذا ستدرس؟

استخدم الجداول لاستكشاف الأفكار الإحصائية، وفسّر معنى الناتج وحدود الاستنتاج بدل التركيز على الصيغة وحدها.

الشرح الأصلي من excelisfun. تجمع بوصلة هذه الدروس لتسهيل الوصول والتعلّم، ولا تنسب شرح القناة إلى فريق الموقع.

نماذج من موضوعات الدروس

  • Excel Statistical Analysis 01: Data & Statistics
  • Excel Statistical Analysis 15: 5-Number Summary / Box & Whiskers Chart: Power Query & Array Formulas
  • Excel Statistical Analysis 30: Introduction to Continuous Probability Distributions
  • Excel Statistical Analysis 47: Hypothesis Testing with T Distribution, 1 Tail Lower (Left) Test
  • What is Difference Between Clustered Column & Stack Column Excel Charts? #Short Excel Trick 39

قبل أن تبدأ

استعداد لتدوين المفاهيم وحل الأمثلة، ومراجعة المتطلبات التي يذكرها المحاضر قبل الموضوعات المتقدمة.

كيف تستفيد من الإحصاء باستخدام Excel؟

خصّص جلسة للتطبيق بعد كل مجموعة. ابدأ بدرس «Excel Statistical Analysis 01: Data & Statistics»، ثم سجّل ما فهمته وما تحتاج الرجوع إليه. عند الوصول إلى «Excel Statistical Analysis 30: Introduction to Continuous Probability Distributions»، جرّب تنفيذ المثال أو شرحه دون متابعة الفيديو لحظة بلحظة.

مهمة مقترحة لتثبيت التعلم

اختر فكرة من موضوع «What is Difference Between Clustered Column & Stack Column Excel Charts? #Short Excel Trick 39» واكتب ملخصًا تطبيقيًا لها أو نفّذ مثالًا مستقلًا. أضف النتيجة إلى مساحة تعلمك؛ واذكر في سيرتك ما نفذته فعلًا، دون اعتبار المشاهدة وحدها خبرة عملية.

المصدر وحدود الإتاحة

تحتوي هذه النسخة على 67 درسًا عامًا بحسب بيانات القائمة التي راجعناها في 17 أكتوبر 2026. قائمة excelisfun الأصلية على YouTube. احتُفظ بترتيب المصدر، وقد تتغير إتاحة الفيديوهات لاحقًا. مشاهدة الشرح مجانية؛ أما تراخيص البرامج والموارد السحابية والاختبارات الرسمية فقد تكون منفصلة. لا تشمل هذه الصفحة شهادة من الجهة الأصلية. لم تُشاهد جميع الفيديوهات بالكامل ضمن فحص البيانات.

محتوى الدورة

1 وحدة · 67 درس · 22 س 26 د

  1. دروس الدورة بالترتيب الأصلي 67 درسًا 22 س 26 د

    المصدر: excelisfun

    • Excel Statistical Analysis 01: Data & Statistics مقفل 22 د
    • Excel Statistical Analysis 02: Structure of Excel files, Navigation, Keyboard and more مقفل 19 د
    • Excel Statistical Analysis 03: Comprehensive Worksheet Formula & Model Building Video مقفل 43 د
    • Excel Statistical Analysis 04: PivotTable & Power Query to Build Frequency Distributions مقفل 36 د
    • Excel Statistical Analysis 05: Frequency Distributions & Visualizations for Categorical Data مقفل 33 د
    • Excel Statistical Analysis 06: Frequency Distributions, Visualizations & Skew for Quantitative Data مقفل 28 د
    • Excel Statistical Analysis 7: Cross Tabulation, Visualizations, AND Logical Tests, Simpson’s Paradox مقفل 33 د
    • Excel Statistical Analysis 08: X-Y Scatter Charts for Linear Data: Excel Chart? Analyze Data Button? مقفل 12 د
    • Mode for Categorical Data? LET Function to Dynamically List all Modes with Category Labels EMT 1770 مقفل 6 د
    • Excel Statistical Analysis 09: Location, Mean, Median, Mode, Moving Average, Skew & More! مقفل 40 د
    • Excel Statistical Analysis 10: Weighted Mean. Awesome Accounting Example!! مقفل 11 د
    • Excel Statistical Analysis 11: Geometric Mean to Calculate Average Compounding Rate per Period مقفل 15 د
    • Excel Statistical Analysis 12: Percentile, Quartile, Percentile Rank and Rank Functions & Algorithms مقفل 19 د
    • FILTER, LET, TRANSPOSE and Other Excel Functions: Mode Calculation for each Quartile. EMT 1771 مقفل 7 د
    • Excel Statistical Analysis 13: Range, Variance, Standard Deviation, Coefficient of Variation مقفل 26 د
    • Excel Statistical Analysis 14: Z-Score, Empirical Rule , Chebyshev Theorem: # of Standard Deviations مقفل 23 د
    • Excel Statistical Analysis 15: 5-Number Summary / Box & Whiskers Chart: Power Query & Array Formulas مقفل 26 د
    • Turn Off GETPIVOTDATA Function - EMT 1774 مقفل 1 د
    • Excel Statistical Analysis 16: Introduction to Probability. Power Query & Pivot Table Example too مقفل 43 د
    • Excel Statistical Analysis 17: AND, OR, and NOT Logical Tests for COUNTIFS & FILTER Functions مقفل 28 د
    • Excel Statistical Analysis 18: Addition Law of Probability, OR Logical Test: Formulas & PivotTables مقفل 17 د
    • Excel Statistical Analysis 19: Conditional Probability 5 Examples مقفل 15 د
    • Excel Statistical Analysis 20: Joint Probability Table: Dynamic Spilled Array or PivotTable? مقفل 9 د
    • Excel Statistical Analysis 21: Multiplication Law of Probability, AND Logical Test, Probability Tree مقفل 11 د
    • Excel Statistical Analysis 22: Bayes’ Theorem, Tabular Method, Probability Tree, SUMPRODUCT function مقفل 21 د
    • Excel Statistical Analysis 23: Discrete Probability Distributions: Terms and Definitions مقفل 13 د
    • DROP, TAKE & VSTACK: How They Are Useful! Spilled Frequency Distribution with Total Row. EMT 1788 مقفل 12 د
    • Excel Statistical Analysis 24: Build Discrete Probability Distributions with Worksheet Formulas مقفل 28 د
    • Excel Statistical Analysis 25: Import Excel data: Build PivotTable Discrete Probability Distribution مقفل 12 د
    • Excel Statistical Analysis 26: Accounting & Finance Discrete Probability Distribution Examples مقفل 9 د
    • Excel Statistical Analysis 27: Binomial Probability Distributions. BINOM.DIST.RANGE Function & Chart مقفل 32 د
    • Excel Statistical Analysis 28: Poisson Distribution, POISSON.DIST function and Poisson Column Chart مقفل 21 د
    • Excel Statistical Analysis 29: HYPGEOM.DIST Function for Conditional Probabilities Across # Trials مقفل 16 د
    • Excel Statistical Analysis 30: Introduction to Continuous Probability Distributions مقفل 9 د
    • Excel Statistical Analysis 31: Uniform Probability Distribution مقفل 15 د
    • Excel Statistical Analysis 32: Bell Curve Functions: NORM.DIST, NORM.S.DIST, NORM.INV, NORM.S.INV مقفل 23 د
    • Excel Statistical Analysis 33: Chart Normal (Bell) Probability Distribution in Excel with Area Chart مقفل 15 د
    • Excel Statistical Analysis 34: Answering Probability Questions With NORM.DIST Function مقفل 8 د
    • Excel Statistical Analysis 35: Exponential Probability Distribution & EXPON.DIST function مقفل 11 د
    • Excel Statistical Analysis 36: Sampling & Sampling Distribution of Sample Means (Xbar) مقفل 24 د
    • Excel Statistical Analysis 37: Learn Central Limit Theorem by Building Sampling Distribution of Xbar مقفل 49 د
    • Excel Statistical Analysis 38: Normal Bell Curve to Estimate Range of Sample Proportions مقفل 10 د
    • Excel Statistical Analysis 39: Confidence Intervals: Theory for Estimating Population Parameter مقفل 14 د
    • Excel Statistical Analysis 40: Confidence Interval for z Distribution, use when Sigma Known مقفل 8 د
    • Excel Statistical Analysis 41: Confidence Interval for t Distribution, use when Sigma NOT Known مقفل 18 د
    • Excel Statistical Analysis 42: Confidence Interval for Proportions (Binomial Experiments) مقفل 10 د
    • Excel Statistical Analysis 43: Hypothesis Testing: P-value & Critical Value Methods: 1 Tail Upper مقفل 32 د
    • Excel Statistical Analysis 44: Hypothesis Testing with Z Distribution, 1 Tail Lower (Left) Test مقفل 10 د
    • Excel Statistical Analysis 45: Hypothesis Testing with Z Distribution, Two Tail Test Example مقفل 9 د
    • Excel Statistical Analysis 46: Hypothesis Testing with T Distribution, 1 Tail Upper (Right) Test مقفل 11 د
    • Excel Statistical Analysis 47: Hypothesis Testing with T Distribution, 1 Tail Lower (Left) Test مقفل 7 د
    • Excel Statistical Analysis 48: Hypothesis Testing with T Distribution, Two Tail Example مقفل 8 د
    • Excel Statistical Analysis 49: Hypothesis Testing for Proportion (Binominal) using Normal Curve مقفل 7 د
    • Linear Regression Made Easy! The Epic Full Story with all Details. Excel Statistical Analysis 50 مقفل 1 س 12 د
    • Excel 2013 Statistical Analysis #63: Sampling Distribution of Xbar1 – Xbar2 & Standard Error مقفل 26 د
    • Excel 2013 Statistical Analysis #64: Confidence Interval for Population Differences Sigma Known مقفل 9 د
    • Excel 2013 Statistical Analysis #65: Hypothesis Testing for Population Differences Sigma Known مقفل 16 د
    • Excel 2013 Statistical Analysis #66: Confidence Interval for Population Differences Sigma NOT Known مقفل 16 د
    • Excel 2013 Statistical Analysis #67: Hypothesis Testing for Population Differences Sigma NOT Known مقفل 17 د
    • Excel 2013 Statistical Analysis #68: Matched/Paired Samples Population Differences Sigma NOT Known مقفل 20 د
    • Excel 2013 Statistical Analysis #69: ANOVA Tables for Comparing More Than 2 Population Means مقفل 44 د
    • Excel 2013 Statistical Analysis #70: Sampling Distribution of Pbar1 – Pbar2, Mean & Standard Error مقفل 24 د
    • Excel 2013 Statistical Analysis #71: Inference About Difference Between 2 Pop. Proportions Z Method مقفل 28 د
    • Excel 2013 Statistical Analysis #72: Chi-Square Test For 2 or More Population Proportions (Formulas) مقفل 30 د
    • Excel 2013 Statistical Analysis #73: Chi-Square Test Independence 2 Categorical Var. (PivotTables) مقفل 23 د
    • CSV and XLSX Files Look The Same!?!? Here Is How To Fix That!. #Short Excel Trick 38 مقفل 1 د
    • What is Difference Between Clustered Column & Stack Column Excel Charts? #Short Excel Trick 39 مقفل 1 د

مدرّبك

elposla

تقييمات المتعلّمين

لا تقييمات بعد.