Liwara 2, Ajman, UAE info@theunitedinstitute.com

Office Address

  • 2 Floor Bin Hamooda Building,
    Flat #208, Liwara 2, Near ABCD Bank
    Ajman, UAE
  • theunitedinstitute@gmail.com
  • +971 54 7899 234 ,0506016017

Our Courses

MS Excel Statistical Analysis Training Course

MS Excel Statistical Analysis Training in Ajman

Statistical Analysis with Excel is a detailed course that gives you a clear understanding of Microsoft Excel's new and most advanced features. It describes in depth how to use MS-features Excel's to perform different data analysis functions.

MS Excel Statistical Analysis ajman-pic

The tutorial includes a lot of screenshots that show you how to use each function step by step. This course is for anyone who uses MS-Excel to create maps, tables, and technical reports with complex data. It will benefit all readers who use MS-Excel to analyze data on a regular basis.

United Excel Courses

Course Overview

  • 1. Install Data Analysis Add-in For Amazing Excel Statistical Tools
  • 2. Download & Install Power Query for Data Transformation Tools
  • 3. What Is Are Statistics Download Stock Data Create Information
  • 4. Data Categorical, Quantitative, Nominal, Ordinal, Interval, Ratio
  • 5. Frequency Distributions & Column Charts, Categorical Variables
  • 6. Subtle Chart Junk
  • 7. Frequency Distributions, Histograms, Skew, Quantitative Variable
  • 8. Cumulative Frequency Distribution & Chart, PivotTable & Formula
  • 9. Description of Dot Plot and Stem and Leaf Charts
  • 10. Power Query Import Multiple Text Files, Grade Histogram by Year
  • 11. Cross Tabulation & Charts for Two Variables, Simpson’s Paradox
  • 12. Scatter Chart & Trendline, X Y Data, 2 Quantitative Variables
  • 13. VLOOKUP to Add New Field To Table & Create Cross Tabulation
  • 14. Create Dot Plot in Excel Using COUNTIFS and REPT functions
  • 15. Location Mean, Median, Mode for Central Location
  • 16. Weighted Mean & SUMPRODUCT Function & Accounting Example
  • 17. Geometric Mean, Average Compounding Rate GEOMEAN & RRI
  • 18. Location Percentile, Quartile, Rank and Percentile Rank
  • 19. Standard Deviation How Fairly Does Mean Represent Data Points
  • 20. SKEW Function and Asymmetry in a Distribution of Data Points
  • 21. Z-Score = # of Standard Deviations, Chebshev’s &Empirical Rule
  • 22. Five Number Summary, Outliers and Box Plots
  • 23. Numerical Measures Covariance and Correlation Coefficient
  • 24. Probability Basics Sample Points, Events & Event Probabilities
  • 25. Combinations & Permutations and Listing Sample Points
  • 26. Adding Law of Probability for OR Events (12 Examples)
  • 27. Multiplication Law of Probability AND Events (16 Examples)
  • 28. Create Joint Probability Table from Raw Data & Calc Event Probs
  • 29. Bayes’ Theorem to Calculate Posterior Probabilities
  • 30. Create Discrete Probability Distribution, Calculate Mean and SD
  • 31. Expected Value Standard & Deviation Discrete Prob. Distribution
  • 32. Binomial Probability Distributions Tables, Charts, Functions
  • 33. POSSION Distribution and POISSON.DIST Function
  • 34. Hyper geometric Distribution and HYPGEOM.DIST Function
  • 35. Dynamic Binomial Probability Charts (3 Examples)
  • 36. Introduction to Continuous Probability Distributions
  • 37. Uniform Probability Distribution
  • 38. Probabilities for Normal (Bell) Probability Distribution
  • 39. Normal (Bell) Probability Distribution Area Chart, X & Z Values
  • 40. Answering Probability Questions With NORM.DIST Function
  • 41. Exponential Probability Distribution & EXPON.DIST function
  • 42. Simple Random Sampling in Excel Process & Theory
  • 43. Sampling Distribution of Xbar and the Central Limit Theorem
  • 44. Sampling Distribution of Pbar (Binomial Sample Proportion)
  • 45. Standard Error Standard Deviation of Xbar Sampling Distribution
  • 46. Central Limit Theorem To Compare Sample Mean To Normal Curve
  • 47. Introduction to Confidence Intervals
  • 48. Create Confidence Intervals Sigma Known Z-Score (3 Methods)
  • 49. Distribution Confidence Intervals Sigma NOT Known 3 Examples
  • 50. Confidence Intervals for Pbar Sample Proportion
  • 51. Determine Sample Size for Sample Mean & Sample Proportion
  • 52. 5 Steps Hypothesis Testing P-value & Critical Value Methods
  • 53. 1 Tail Left Mean Hypothesis Z Test P-value & Critical Value
  • 54. 2 Tail Z Score Mean Hypothesis Testing P-value Critical Value
  • 55. NORM.S.DIST = p-value, NORM.S.INV = Critical Value Sigma Known
  • 56. 1 Tail Right Mean Hypothesis T Test P-value & Critical Value
  • 57. 1 Tail Left T Score Mean Hypothesis Test P-value Critical Value
  • 58. 2 Tail Mean Hypothesis T Test P-value & Critical Value
  • 59. T.DIST, T.DIST.RT, T.DIST.2T, T.INV, T.INV.2T functions
  • 60. Hypothesis Test for Proportions using p-value or Critical Value
  • 61. Calculate Slope and Intercept for Regression Line
  • 62. Sampling Distribution of Xbar1 – Xbar2 & Standard Error
  • 63. Confidence Interval for Population Differences Sigma Known
  • 64. Hypothesis Testing for Population Differences Sigma Known
  • 65. Confidence Interval for Population Differences Sigma NOT Known
  • 66. Hypothesis Testing for Population Differences Sigma NOT Known
  • 67. Matched Paired Samples Population Differences Sigma NOT Known
  • 68. ANOVA Tables for Comparing More Than 2 Population Means
  • 69. Sampling Distribution of Pbar1 – Pbar2, Mean & Standard Error
  • 70. Inference about Difference Between 2 Pop. Proportions Z Method
  • 71. Chi-Square Test For 2 or More Population Proportions (Formulas)
  • 72. Chi-Square Test Independence 2 Categorical Var. (PivotTables)
  • 73. Joint Probability Tables. What Are They How to Use How to Create using PivotTable. EMT 1719
  • 74. PivotTable or FREQUENCY function How They Are Different for Counting Numbers Excel Magic Trick 1720 16
Call Us Now
054-7727005 | 065464400