# Excel Statistics Canonical URL: ## Overview This course provides a thorough introduction to statistical analysis using Microsoft Excel, equipping you with the tools and techniques needed to analyze, interpret, and visualize data in a professional setting. You begin with foundational statistical functions and ranking tools before diving into Excel's Data Analysis ToolPak, which streamlines complex statistical calculations. Core analytical methods are covered in depth, including descriptive statistics, T-tests, straight line analysis, simple linear regression, and multiple regression, giving students a solid framework for understanding relationships within data. The course also explores data visualization and advanced forecasting techniques, teaching you how to build histograms, waterfall charts, and probability models. You are introduced to powerful tools such as the POISSON distribution, Solver, Monte Carlo Simulation, and resampling methods, all of which are essential for modeling risk and uncertainty in real-world decision-making scenarios. By the end of the course, you'll have the practical Excel skills needed to perform sophisticated statistical analysis and support data-driven business decisions. ## What you'll learn - Apply foundational statistical functions and ranking tools to analyze ranges of data in Excel - Use the Data Analysis ToolPak to efficiently perform complex statistical calculations - Conduct T-tests and regression analysis to identify relationships and differences within datasets - Create histograms and waterfall charts to visually communicate data insights - Build probability models using POISSON distribution and Solver to support multi-variable decision-making - Apply Monte Carlo Simulation and resampling techniques to model risk and uncertainty in forecasting scenarios ## Curriculum ### Basic Statistics #### Statistical Functions - These foundational statistical functions can be used to perform basic caluclations on ranges of values #### Ranking Functions - Rank values to establish percentages and percentiles #### Data Analysis Toolpack - Quickly and easily perform statistical calculations with the Data Analysis Toolpack add-in ### Statistical Analysis #### Descriptive Statistics - Compare two sets of data by 16 different, statistical measures #### T Tests - Calculates whether the means of two groups are statistically different from each other #### Straight Line Analysis - Graphically estimate the relationship between two variables #### Simple Linear Regrssion - Estimate the relationship between two variables #### Multiple Regression - Estimate the relationship between more than two variables ### Charts #### Histogram - Divide values into intervals and represent the frequency of data values in each interval with a bar #### Waterfall Chart - Visually display how an intitial value is affected by a series of positive and negative values ### Probability and Forecast Modelling #### POISSON Distribution - Calculate the probability of a given number of events occurring in a fixed interval of time or space #### Solver - Calculate optimal solutions to multi-variable decision problems #### Monte Carlo Simulation - Better understand the impact of risk and uncertainty in forecasting models #### Resampling - Make statistical inferences from data by sampling with replacement ## FAQ ### Is this course open to beginners? Yes, this course is open to beginners. Students must be comfortable using a computer. No other prior knowledge is required. ### Do you offer payment plans or student financing for this course? This course does not qualify for payment plans or student financing. See our Payment Plan FAQ to find related programs that qualify. ### Can I take this course online (remote learning)? You may attend this training virtually (online) at the scheduled time the course is offered (New York, Eastern Time). How does attending “live online” work? Students can attend this training remotely through screen sharing software (we use Zoom). Participants can hear the instruction, ask questions, and even share their screen with the instructor. For audio you can use your computer’s microphone/speakers or call a phone number that we’ll provide. Classes are activity-based and taught by a live instructor, so we strongly encourage students who are local to the area to attend in person! You will need your own computer and copy of any required software. If you don’t have the software, you can usually do a free trial or purchase your own license. If you need assistance, contact us at nyc@careercenters.com ### What happens if I need to miss a session? You have some options: You can watch a recording of the session. We will provide any course materials. If you can’t come into the classroom but can still attend remotely, we will provide you with the Zoom login information. You can use your free retake to make up any missed class time. ### What’s included with my tuition? A hands-on learning experience working on projects and exercises, which is proven to boost comprehension, retention, and engagement Expert instructors who are industry professionals and experienced educators that are driven to help you succeed Access to industry-standard software during your training Top-notch curricula that have been tried and tested over many cohorts and are consistently improved for an optimal learning experience A 1-year free retake policy which allows students to retake any part of the course or program for free to refresh the materials and gain additional practice 30-day access to class recordings to review material at your own pace A certificate of completion to verify your accomplishment ### Are there any additional fees or expenses? There are no extra fees or taxes for our courses. The price you see on this page is the maximum you’ll pay us. ### Do you offer any discounts for this course? We don’t currently offer discounts as we do our best to affordably prices our courses. ## Pricing **Tuition:** $1