Skip to content
Dr. Dawn Wright
  • Home
  • About Dawn
  • Excel Calculators
  • BUS 233/503 Video Matrix
  • Doc’s Blog
Menu
  • Home
  • About Dawn
  • Excel Calculators
  • BUS 233/503 Video Matrix
  • Doc’s Blog
  • Excel 2016 – Statistical Analysis
    • A. Describing Data
      • What you’ll learn in this training
      • Finding the arithmetic mean
      • AVERAGEA function
      • AVERAGEIF function
      • AVERAGEIFS function
      • Find the geometric mean
      • Find the median
      • Find the mode
      • Find the standard deviation
      • Use the STDEVA functions
      • Find the variance
      • Use the VARA functions
      • Find the kurtosis of a distribution
      • Find the skewness of a distribution
      • Find the confidence interval
      • Use the FREQUENCY function
      • Find the quartile of a data set
      • Ranking values
      • Finding a value’s standard score
    • B. Comparing Variables
      • Find the bivariate correlation coefficient
      • Find the values associated with a linear regression
      • Find linear slope
      • Find the y-intercept of a linear regression
      • Predict a future value using an existing value
      • TREND function
      • Find the values associated with an exponential regression
      • Predicting values along an exponential curve using existing values
    • C. Tests of Significance
      • Finding the probability of a one-tailed Z-Test
      • Finding the probability associated with a Student’s T-Test for paired samples
      • Finding the critical value of the Student’s T-Test for paired samples
      • Examining data for homogeneity of variance using F-TEST function
      • Finding the critical value of the F-test
      • Finding the probability associated with a student’s T-Test for independent samples
      • Finding the critical value of the student’s T-Test for independent samples
      • Finding the probability associated with a chi-squared test for independence
      • Finding the critical value of the chi-squared test for independence
    • D. Data Analysis ToolPak
      • Activating the data analysis ToolPak
      • Finding descriptive statistics
      • Create a histogram
      • Performing a T-test for paired or related samples
      • Examining data for homogeneity of variance
      • Performing a T-test for independent or unrelated samples
      • Performing a one-way analysis of variance (ANOVA)
      • Performing a factorial analysis of variance (ANOVA)
      • Performing a repeated measures analysis of variance (ANOVA)
      • Finding the correlation of two or more variables
      • Performing a linear regression

Popular Posts

  • How to State the Conclusion about a Hypothesis Test
  • Tail of the Test: Interpreting Excel Data Analysis t-test output
  • Use Excel to Calculate MAD, MSE, RMSE & MAPE
  • Why is the Standard Error Equal to Sigma Divided by the Square Root of n?
  • No Standard Deviation? How do I get the standardized test statistic?
  • "Easy" Excel Inverse Triangular Distribution for Monte Carlo Simulations Redux
  • Playing Card Probability
  • What are d-bar and s sub d?
  • Discrete or Continuous?
  • Chebyshev's Theorem Excel Calculator

Creative Commons

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.
Copyright © 2023 Dawn Wright, Ph.D. | Powered by Dr. Dawn