Statistical Functions in EXCEL
xlsx
keyboard_arrow_up
School
The City College of New York, CUNY *
*We aren’t endorsed by this school
Course
20350
Subject
Statistics
Date
Feb 20, 2024
Type
xlsx
Pages
59
Uploaded by MajorFang13470
Statistical functions (reference) in EXCEL
We will go over only some of these statistics
Function
https://support.microsoft.com/en-us/office/stati
AVEDEV function
AVERAGE function
AVERAGEA function
AVERAGEIF function
AVERAGEIFS function
BETA.DIST function
BETA.INV function
BINOM.DIST function
BINOM.DIST.RANGE function
BINOM.INV function
CHISQ.DIST function
CHISQ.DIST.RT function
CHISQ.INV function
CHISQ.INV.RT function
CHISQ.TEST function
CONFIDENCE.NORM function
CONFIDENCE.T function
CORREL function
COUNT function
COUNTA function
COUNTBLANK function
COUNTIF function
COUNTIFS function
COVARIANCE.P function
COVARIANCE.S function
DEVSQ function
EXPON.DIST function
F.DIST function
F.DIST.RT function
F.INV function
F.INV.RT function
F.TEST function
FISHER function
FISHERINV function
FORECAST function
FORECAST.ETS function
FORECAST.ETS.CONFINT function
FORECAST.ETS.SEASONALITY function
FORECAST.ETS.STAT function
FORECAST.LINEAR function
FREQUENCY function
GAMMA function
GAMMA.DIST function
GAMMA.INV function
GAMMALN function
GAMMALN.PRECISE function
GAUSS function
GEOMEAN function
GROWTH function
HARMEAN function
HYPGEOM.DIST function
INTERCEPT function
KURT function
LARGE function
LINEST function
LOGEST function
LOGNORM.DIST function
LOGNORM.INV function
MAX function
MAXA function
MAXIFS function
MEDIAN function
MIN function
MINIFS function
MINA function
MODE.MULT function
MODE.SNGL function
NEGBINOM.DIST function
NORM.DIST function
NORM.INV function
NORM.S.DIST function
NORM.S.INV function
PEARSON function
PERCENTILE.EXC function
PERCENTILE.INC function
PERCENTRANK.EXC function
PERCENTRANK.INC function
PERMUT function
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
PERMUTATIONA function
PHI function
POISSON.DIST function
PROB function
QUARTILE.EXC function
QUARTILE.INC function
RANK.AVG function
RANK.EQ function
RSQ function
SKEW function
SKEW.P function
SLOPE function
SMALL function
STANDARDIZE function
STDEV.P function
STDEV.S function
STDEVA function
STDEVPA function
STEYX function
T.DIST function
T.DIST.2T function
T.DIST.RT function
T.INV function
T.INV.2T function
T.TEST function
T.TEST function
TREND function
TRIMMEAN function
VAR.P function
VAR.S function
VARA function
VARPA function
WEIBULL.DIST function
Z.TEST function
s
Description
Returns the average of the absolute deviations of data points from their mean
Returns the average of its arguments
Returns the average of its arguments, including numbers, text, and logical values
Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria
Returns the average (arithmetic mean) of all cells that meet multiple criteria
Returns the beta cumulative distribution function
Returns the inverse of the cumulative distribution function for a specified beta distribution
Returns the individual term binomial distribution probability
Returns the probability of a trial result using a binomial distribution
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
Returns the cumulative beta probability density function
Returns the one-tailed probability of the chi-squared distribution
Returns the cumulative beta probability density function
Returns the inverse of the one-tailed probability of the chi-squared distribution
Returns the test for independence
Returns the confidence interval for a population mean
Returns the confidence interval for a population mean, using a Student's t distribution
Returns the correlation coefficient between two data sets
Counts how many numbers are in the list of arguments
Counts how many values are in the list of arguments
Counts the number of blank cells within a range
Counts the number of cells within a range that meet the given criteria
Counts the number of cells within a range that meet multiple criteria
Returns covariance, the average of the products of paired deviations
Returns the sample covariance, the average of the products deviations for each data point pair in two data sets
tistical-functions-reference-624dac86-a375-4435-bc25-76d659719ffd
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Returns the sum of squares of deviations
Returns the exponential distribution
Returns the F probability distribution
Returns the F probability distribution
Returns the inverse of the F probability distribution
Returns the inverse of the F probability distribution
Returns the result of an F-test
Returns the Fisher transformation
Returns the inverse of the Fisher transformation
Returns a value along a linear trend
Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (
Returns a confidence interval for the forecast value at the specified target date
Returns the length of the repetitive pattern Excel detects for the specified time series
Returns a statistical value as a result of time series forecasting
Returns a future value based on existing values
Returns a frequency distribution as a vertical array
Returns the gamma function value
Returns the gamma distribution
Returns the inverse of the gamma cumulative distribution
Returns the natural logarithm of the gamma function, Γ(x)
Returns the natural logarithm of the gamma function, Γ(x)
Returns 0.5 less than the standard normal cumulative distribution
Returns the geometric mean
Returns values along an exponential trend
Note:
In Excel 2016, this function is replaced with
FORECAST.LINEAR
as part of the new
Forecasting functions
, b
versions.
Returns the harmonic mean
Returns the hypergeometric distribution
Returns the intercept of the linear regression line
Returns the kurtosis of a data set
Returns the k-th largest value in a data set
Returns the parameters of a linear trend
Returns the parameters of an exponential trend
Returns the cumulative lognormal distribution
Returns the inverse of the lognormal cumulative distribution
Returns the maximum value in a list of arguments
Returns the maximum value in a list of arguments, including numbers, text, and logical values
Returns the maximum value among cells specified by a given set of conditions or criteria
Returns the median of the given numbers
Returns the minimum value in a list of arguments
Returns the minimum value among cells specified by a given set of conditions or criteria.
Returns the smallest value in a list of arguments, including numbers, text, and logical values
Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data
Returns the most common value in a data set
Returns the negative binomial distribution
Returns the normal cumulative distribution
Returns the inverse of the normal cumulative distribution
Returns the standard normal cumulative distribution
Returns the inverse of the standard normal cumulative distribution
Returns the Pearson product moment correlation coefficient
Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
Returns the k-th percentile of values in a range
Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set
Returns the percentage rank of a value in a data set
Returns the number of permutations for a given number of objects
Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the tota
Returns the value of the density function for a standard normal distribution
Returns the Poisson distribution
Returns the probability that values in a range are between two limits
Returns the quartile of the data set, based on percentile values from 0..1, exclusive
Returns the quartile of a data set
Returns the rank of a number in a list of numbers
Returns the rank of a number in a list of numbers
Returns the square of the Pearson product moment correlation coefficient
Returns the skewness of a distribution
Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distr
Returns the slope of the linear regression line
Returns the k-th smallest value in a data set
Returns a normalized value
Calculates standard deviation based on the entire population
Estimates standard deviation based on a sample
Estimates standard deviation based on a sample, including numbers, text, and logical values
Calculates standard deviation based on the entire population, including numbers, text, and logical values
Returns the standard error of the predicted y-value for each x in the regression
Returns the Percentage Points (probability) for the Student t-distribution
Returns the Percentage Points (probability) for the Student t-distribution
Returns the Student's t-distribution
Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom
Returns the inverse of the Student's t-distribution
Returns the probability associated with a Student's t-test
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Returns the probability associated with a Student's t-test
Returns values along a linear trend
Returns the mean of the interior of a data set
Calculates variance based on the entire population
Estimates variance based on a sample
Estimates variance based on a sample, including numbers, text, and logical values
Calculates variance based on the entire population, including numbers, text, and logical values
Returns the Weibull distribution
Returns the one-tailed probability-value of a z-test
Math and Trigonometry Function
To get detailed information about
Function
https://support.microsoft.com/en-
ABS function
ACOS function
ACOSH function
ACOT function
ACOTH function
AGGREGATE function
ARABIC function
ASIN function
ASINH function
ATAN function
ATAN2 function
ATANH function
BASE function
CEILING function
CEILING.MATH function
CEILING.PRECISE function
COMBIN function
COMBINA function
COS function
COSH function
COT function
COTH function
CSC function
CSCH function
DECIMAL function
DEGREES function
EVEN function
EXP function
FACT function
FACTDOUBLE function
FLOOR function
FLOOR.MATH function
FLOOR.PRECISE function
GCD function
INT function
ISO.CEILING function
LCM function
LN function
LOG function
LOG10 function
MDETERM function
MINVERSE function
MMULT function
MOD function
MROUND function
MULTINOMIAL function
MUNIT function
ODD function
PI function
POWER function
PRODUCT function
QUOTIENT function
RADIANS function
RAND function
RANDARRAY function
RANDBETWEEN function
ROMAN function
ROUND function
ROUNDDOWN function
ROUNDUP function
SEC function
SECH function
SERIESSUM function
SIGN function
SIN function
SINH function
SQRT function
SQRTPI function
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
SUBTOTAL function
SUM function
SUMIF function
SUMIFS function
SUMPRODUCT function
SUMSQ function
SUMX2MY2 function
SUMX2PY2 function
SUMXMY2 function
TAN function
TANH function
TRUNC function
ns in EXCEL
t a function, click its name in the first column.
Description
Returns the absolute value of a number
Returns the arccosine of a number
Returns the inverse hyperbolic cosine of a number
Returns the arccotangent of a number
Returns the hyperbolic arccotangent of a number
Returns the aggregate in a list or database
Converts a Roman number to Arabic, as a number
Returns the arcsine of a number
Returns the inverse hyperbolic sine of a number
Returns the arctangent of a number
Returns the arctangent from x- and y-coordinates
Returns the inverse hyperbolic tangent of a number
Converts a number into a text representation with the given radix (base)
Rounds a number to the nearest integer or to the nearest multiple of significance
Rounds a number up, to the nearest integer or to the nearest multiple of significance
Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, t
Returns the number of combinations for a given number of objects
Returns the number of combinations with repetitions for a given number of items
Returns the cosine of a number
Returns the hyperbolic cosine of a number
Returns the cotangent of an angle
Returns the hyperbolic cotangent of a number
Returns the cosecant of an angle
Returns the hyperbolic cosecant of an angle
Converts a text representation of a number in a given base into a decimal number
Converts radians to degrees
Rounds a number up to the nearest even integer
Returns the factorial of a number
Returns the double factorial of a number
-us/office/math-and-trigonometry-functions-reference-ee158fd6-33be-42c9-9ae5-d635c3ae8c16
Returns
e
raised to the power of a given number
Rounds a number down, toward zero
Rounds a number down, to the nearest integer or to the nearest multiple of significance
Rounds a number down to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the n
Returns the greatest common divisor
Rounds a number down to the nearest integer
Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance
Returns the least common multiple
Returns the natural logarithm of a number
Returns the logarithm of a number to a specified base
Returns the base-10 logarithm of a number
Returns the matrix determinant of an array
Returns the matrix inverse of an array
Returns the matrix product of two arrays
Returns the remainder from division
Returns a number rounded to the desired multiple
Returns the multinomial of a set of numbers
Returns the unit matrix or the specified dimension
Rounds a number up to the nearest odd integer
Returns the value of pi
Returns the result of a number raised to a power
Multiplies its arguments
Returns the integer portion of a division
Converts degrees to radians
Returns a random number between 0 and 1
Returns a random number between the numbers you specify
Converts an Arabic numeral to Roman, as text
Rounds a number to a specified number of digits
Rounds a number down, toward zero
Rounds a number up, away from zero
Returns the secant of an angle
Returns the hyperbolic secant of an angle
Returns the sum of a power series based on the formula
Returns the sign of a number
Returns the sine of the given angle
Returns the hyperbolic sine of a number
Returns a positive square root
Returns the square root of (number * pi)
Returns an array of random numbers between 0 and 1. However, you can specify the number of rows and columns to
values.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Returns a subtotal in a list or database
Adds its arguments
Adds the cells specified by a given criteria
Adds the cells in a range that meet multiple criteria
Returns the sum of the products of corresponding array components
Returns the sum of the squares of the arguments
Returns the sum of the difference of squares of corresponding values in two arrays
Returns the sum of the sum of squares of corresponding values in two arrays
Returns the sum of squares of differences of corresponding values in two arrays
Returns the tangent of a number
Returns the hyperbolic tangent of a number
Truncates a number to an integer
functions
https://www.statology.org/tutorials/
Tutorials
This page lists all of the basic statistics tutorials available on Statology.
Introduction to Statistics
Describing Data
Visualizing Data
Probability
Study Design
Why is Statistics Important?
Descriptive vs. Inferential Statistics
Population vs. Sample
Statistic vs. Parameter
Qualitative vs. Quantitative Variables
Levels of Measurement: Nominal, Ordinal, Interval and Ratio
Measures of Central Tendency
Measures of Dispersion
SOCS: A Helpful Acronym for Describing Distributions
Boxplots
Stem and Leaf Plots
Scatterplots
Relative Frequency Histogram
Density Curves
Theoretical Probability
Posterior Probability
How to Interpret Odds Ratios
Law of Large Numbers
Set Operations
The General Multiplication Rule
Explanatory & Response Variables
Sampling Methods
What is a Representative Sample?
What is a Sampling Frame?
Matched Pairs Design
Pretest-Posttest Design
Split-Plot Design
Permuted Block Randomization
Latin Hypercube Sampling
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Random Variables
Sampling Distributions
Confidence Intervals
Hypothesis Testing
P-values and Effect Size
What Are Random Variables?
CDF vs. PDF: What’s the Difference?
The Normal Distribution
The Binomial Distribution
The Poisson Distribution
The Geometric Distribution
The Uniform Distribution
The Exponential Distribution
The Hypergeometric Distribution
The Negative Binomial Distribution
The Multinomial Distribution
What is a Sampling Distribution?
Central Limit Theorem
What are Confidence Intervals?
Confidence Interval for a Mean
Confidence Interval for the Difference Between Means
Confidence Interval for a Proportion
Confidence Interval for the Difference in Proportions
Confidence Interval for a Standard Deviation
Confidence Interval for a Median
Confidence Interval for a Correlation Coefficient
Introduction to Hypothesis Testing
One Sample t-test
Two Sample t-test
Welch’s t-test
Mann-Whitney U Test
Paired Samples t-test
Wilcoxon Signed Rank Test
One Proportion Z-Test
Two Proportion Z-Test
How to Interpret a P-Value of 0.000 How to Calculate a P-Value from a t Test By Hand
Three Ways to Find a P-Value from a t Statistic
An Explanation of P-Values and Statistical Significance
A Simple Explanation of Statistical vs. Practical Significance
How to Find Z Alpha/2 (za/2)
Effect Size
Bayes Factor
Chi-Square Tests
Regression
ANOVA
Chi-Square Goodness of Fit Test
Chi-Square Test of Independence
Fisher’s Exact Test
Effect Size for a Chi-Square Test
Introduction to Simple Linear Regression
How to Perform Simple Linear Regression by Hand
Introduction to Multiple Linear Regression
How to Perform Multiple Linear Regression by Hand
Testing the Significance of a Regression Slope
How to Read and Interpret a Regression Table
How to Interpret Regression Coefficients
The F-Test of Overall Significance in Regression
Understanding the Standard Error of the Regression
How to Calculate Residuals in Regression Analysis
Heteroscedasticity in Regression
Multicollinearity in Regression
The Breusch-Pagan Test
One-Way ANOVA
One-Way ANOVA by Hand
Two-Way ANOVA
Repeated Measures ANOVA
Repeated Measures ANOVA By Hand
ANOVA Post Hoc Tests
Dunnett’s Test for Multiple Comparisons
Dunn’s Test for Multiple Comparisons
ANCOVA
Kruskal-Wallis Test
Friedman Test
https://www.statology.org/excel-guides/
Excel Guides
This page lists every Excel tutorial on Statology.
Operations
Descriptive Statistics
How to Load the Analysis ToolPak in Excel
How to Compare Two Excel Sheets for Differences
How to Compare Two Lists in Excel Using VLOOKUP
How to Find the Top 10% of Values in an Excel Column
How to Find the Top 10 Values in an Excel Column
How to Replace #N/A Values in Excel
How to Ignore #N/A Values in Excel
How to Use Linear Interpolation in Excel
How to Interpolate Missing Values in Excel
How to Find the Antilog of Values in Excel
How to Calculate the Difference Between Dates in Excel
How to Sort by Multiple Columns in Excel
How to Rank by Multiple Criteria in Excel
How to Select a Random Sample in Excel
How to Perform Systematic Sampling in Excel
How to Perform Stratified Sampling in Excel
How to Perform Cluster Sampling in Excel
How to Calculate a Five Number Summary in Excel
How to Calculate the Mean and Standard Deviation in Excel
How to Calculate Mean, Median & Mode in Excel
How to Perform Univariate Analysis in Excel
How to Calculate Expected Value in Excel
How to Calculate the Interquartile Range (IQR) in Excel
How to Calculate the Midrange in Excel
How to Calculate Sample & Population Variance in Excel
How to Calculate the Coefficient of Variation in Excel
How to Calculate Skewness in Excel
How to Calculate Standard Error in Excel
How to Create a Covariance Matrix in Excel
How to Create a Frequency Distribution in Excel
How to Count Frequency of Text in Excel
How to Create a Contingency Table in Excel
How to Create a Survival Curve in Excel
How to Calculate a Dot Product in Excel
How to Calculate a Cross Product in Excel
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Visualizations
How to Calculate Conditional Probability in Excel
How to Apply Bayes’ Theorem in Excel
How to Calculate Spearman Rank Correlation in Excel
How to Plot Confidence Intervals in Excel
How to Normalize Data in Excel
How to Calculate Class Width in Excel
How to Calculate Cosine Similarity in Excel
How to Create a Percent Frequency Distribution in Excel
How to Calculate Relative Frequency in Excel
How to Calculate Cumulative Frequency in Excel
How to Calculate Cumulative Percentage in Excel
How to Create a Crosstab in Excel
How to Calculate Partial Correlation in Excel
How to Calculate Point-Biserial Correlation in Excel
How to Easily Find Outliers in Excel
How to Calculate Fleiss’ Kappa in Excel
How to Calculate Relative Standard Deviation in Excel
How to Calculate Hamming Distance in Excel
How to Calculate Euclidean Distance in Excel
How to Calculate Manhattan Distance in Excel
How to Calculate the 90th Percentile in Excel
How to Calculate Deciles in Excel
How to Calculate Quintiles in Excel
How to Calculate Probability in Excel
How to Winsorize Data in Excel
How to Calculate Pearson’s Coefficient of Skewness in Excel
How to Calculate Intraclass Correlation Coefficient in Excel
How to Calculate Cronbach’s Alpha in Excel
How to Calculate Weighted Standard Deviation in Excel
How to Calculate Pooled Variance in Excel
How to Find the Slope of a Trendline in Excel
How to Calculate the Sum by Group in Excel
How to Count by Group in Excel
How to Perform a Median IF Function in Excel
How to Perform a Percentile IF Function in Excel
How to Transform Data in Excel (Log, Square Root, Cube Root)
How to Perform Arcsine Transformation in Excel
How to Perform a Box-Cox Transformation in Excel
PERCENTILE.EXC vs. PERCENTILE.INC in Excel
QUARTILE.EXC vs. QUARTILE.INC in Excel
STDEV.P vs. STDEV.S in Excel
VAR.P vs. VAR.S in Excel
How to Create a Stem-and-Leaf Plot in Excel
How to Create and Interpret Box Plots in Excel
How to Create Side-by-Side Boxplots in Excel
How to Plot Multiple Lines in Excel
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Probability Distributions
How to Create a Double Doughnut Chart in Excel
How to Create an Ogive Graph in Excel
How to Create a ROC Curve in Excel
How to Create a Statistical Process Control Chart in Excel
How to Create and Interpret a Correlation Matrix in Excel
How to Make a Bell Curve in Excel: Example + Template
How to Make a Frequency Polygon in Excel
How to Create a Binomial Distribution Graph in Excel
How to Create a Poisson Distribution Graph in Excel
How to Create a Population Pyramid in Excel
How to Create a Gantt Chart in Excel
How to Create a Dot Plot in Excel
How to Create a Log-Log Plot in Excel
How to Create a Semi-Log Graph in Excel
How to Plot an Equation in Excel
How to Plot a CDF in Excel
How to Add Error Bars to Charts in Excel
How to Rotate Slices of a Pie Chart in Excel
How to Change Bin Width of Histograms in Excel
How to Fit a Curve in Excel
How to Fit a Polynomial Curve in Excel
How to Add a Horizontal Line to a Scatterplot in Excel
How to Create a Scatterplot with Multiple Series in Excel
How to Add Labels to Scatterplot Points in Excel
How to Create a Normal Probability Plot in Excel
How to Create a Bland-Altman Plot in Excel
How to Create Anscombe’s Quartet in Excel
How to Create a Forest Plot in Excel
How to Create an Interaction Plot in Excel
How to Apply Chebyshev’s Theorem in Excel
How to Apply the Central Limit Theorem in Excel
How to Calculate Sampling Distributions in Excel
How to Calculate Z-Scores in Excel
How to Calculate Modified Z-Scores in Excel
How to Calculate the P-Value of an F-Statistic in Excel
How to Find the P-Value of a Chi-Square Statistic in Excel
How to Find a P-Value from a Z-Score in Excel
How to Find a P-Value from a t-Score in Excel
How to Convert Between Z-Scores and Percentiles in Excel
How to Create a t-Distribution Graph in Excel
How to Generate a Normal Distribution in Excel
How to Apply the Empirical Rule in Excel
How to Use the Binomial Distribution in Excel
How to Use the Exponential Distribution in Excel
How to Use the Geometric Distribution in Excel
How to Use the Hypergeometric Distribution in Excel
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Hypothesis Tests
Chi-Square Tests
Regression
How to Use the Poisson Distribution in Excel
How to Use the Triangular Distribution in Excel
How to Use the Uniform Distribution in Excel
How to Find the F Critical Value in Excel
How to Find the Chi-Square Critical Value in Excel
How to Find the T Critical Value in Excel
How to Find the Z Critical Value in Excel
How to Calculate NormalCDF Probabilities in Excel
How to Conduct a One Sample t-Test in Excel
How to Conduct a Two Sample t-Test in Excel
How to Perform Welch’s t-test in Excel
How to Conduct a Paired Samples t-Test in Excel
How to Perform a Sign Test in Excel
How to Conduct Grubbs’ Test in Excel
McNemar’s Test in Excel
How to Perform a One Proportion Z-Test in Excel
How to Perform a Two Proportion Z-Test in Excel
How to Perform One Sample & Two Sample Z-Tests in Excel
How to Perform a Mann-Whitney U Test in Excel
How to Perform a Wilcoxon Signed Rank Test in Excel
How to Perform a Binomial Test in Excel
How to Perform a Correlation Test in Excel
How to Calculate Cohen’s D in Excel
How to Calculate Odds Ratio and Relative Risk in Excel
How to Perform Levene’s Test in Excel
How to Perform a Jarque-Bera Test in Excel
How to Find the P-value for a Correlation Coefficient in Excel
How to Calculate Point Estimates in Excel
How to Calculate Confidence Intervals in Excel
How to Perform a Normality Test in Excel
How to Perform a Durbin-Watson Test in Excel
How to Perform a Chi-Square Goodness of Fit Test in Excel
How to Perform a Chi-Square Test of Independence in Excel
How to Perform Fisher’s Exact Test in Excel
How to Calculate Cramer’s V in Excel
How to Perform Simple Linear Regression in Excel
How to Perform Multiple Linear Regression in Excel
How to Perform Logistic Regression in Excel
How to Perform Nonlinear Regression in Excel
How to Perform Quadratic Regression in Excel
How to Perform Cubic Regression in Excel
How to Perform Exponential Regression in Excel
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
ANOVA
Time Series
How to Perform Logarithmic Regression in Excel
How to Perform Power Regression in Excel
How to Perform Polynomial Regression in Excel
How to Interpret Regression Output in Excel
How to Use Method of Least Squares in Excel
How to Create a Confusion Matrix in Excel
How to Construct a Prediction Interval in Excel
How to Create a Residual Plot in Excel
How to Calculate Standardized Residuals in Excel
How to Calculate VIF in Excel
How to Calculate the Standard Error of Regression in Excel
How to Perform a Breusch-Pagan Test in Excel
How to Create a Q-Q Plot in Excel
How to Calculate R-Squared in Excel
How to Calculate Adjusted R-Squared in Excel
How to Calculate Residual Sum of Squares in Excel
How to Add a Regression Line to a Scatterplot in Excel
How to Use Multiple Linear Regression in Excel for Predictive Analysis
How to Create Dummy Variables in Excel
How to Calculate SST, SSR, and SSE in Excel
How to Perform a Partial F-Test in Excel
How to Perform a One-Way ANOVA in Excel
How to Perform a Tukey-Kramer Post Hoc Test in Excel
How to Perform Scheffe’s Test in Excel
How to Perform a Bonferroni Correction in Excel
How to Perform a Two-Way ANOVA in Excel
How to Perform a Repeated Measures ANOVA in Excel
How to Perform a Nested ANOVA in Excel
How to Perform a Kruskal-Wallis Test in Excel
How to Perform the Friedman Test in Excel
How to Perform an ANCOVA in Excel
How to Calculate Mean Absolute Percentage Error (MAPE) in Excel
How to Calculate Weighted MAPE in Excel
How to Calculate SMAPE in Excel
How to Calculate Mean Squared Error (MSE) in Excel
How to Calculate Root Mean Square Error (RMSE) in Excel
How to Calculate the Mean Absolute Deviation in Excel
How to Calculate Median Absolute Deviation in Excel
How to Calculate Mean Absolute Error in Excel
How to Perform Exponential Smoothing in Excel
How to Find Weighted Moving Averages in Excel
How to Calculate a Cumulative Average in Excel
How to Calculate Autocorrelation in Excel
How to Calculate Rolling Correlation in Excel
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Naive Forecasting in Excel
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
https://www.statology.org/r-guides/
R Guides
This page lists every R tutorial on Statology.
Import & Export Data
Descriptive Statistics
How to Manually Enter Raw Data in R
How to Import CSV Files into R
How to Read a CSV from URL into R
How to Import Excel Files into R
How to Import SAS Files into R
How to Import SPSS Files into R
How to Import .dta Files into R
How to Export a Data Frame to CSV File in R
How to Export a Data Frame to Excel File in R
How to Export Data Frames to Multiple Excel Sheets in R
How to Export Multiple Plots to PDF in R
How to Use read.delim in R
How to Use write.table in R
How to Use setwd / getwd in R
How to Clear the Environment in R
A Complete Guide to the Iris Dataset in R
How to Create Summary Tables in R
How to Calculate Five Number Summary in R
How to Calculate Summary Statistics by Group in R
How to Turn Off Scientific Notation in R
How to Calculate Z-Scores in R
How to Calculate Polychoric Correlation in R
How to Calculate Partial Correlation in R
How to Calculate Point-Biserial Correlation in R
How to Calculate Cross Correlation in R
How to Calculate Spearman Rank Correlation in R
How to Calculate Intraclass Correlation Coefficient in R
How to Calculate Correlation Between Multiple Variables in R
How to Create a Covariance Matrix in R
How to Calculate Variance in R
How to Remove Outliers in R
How to Use the Table Function in R
How to Calculate the Standard Error of the Mean in R
How to Calculate a Trimmed Mean in R
How to Calculate a Bootstrap Standard Error in R
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
How to Perform a COUNTIF Function in R
How to Perform a SUMIF Function in R
How to Use sum Function in R
How to Use par Function in R
How to Use nrow Function in R
How to Use the gsub Function in R
How to Use the summary Function in R
How to Use colMeans Function in R
How to Use rowMeans Function in R
How to Average Across Columns in R
How to Sum Specific Columns in R
How to Sum Columns Based on a Condition in R
How to Calculate the Mean of Multiple Columns in R
How to Calculate the Mean by Group in R
How to Calculate the Sum by Group in R
How to Calculate Mean in R
How to Calculate Mode in R
How to Calculate a Weighted Mean in R
How to Calculate Geometric Mean in R
How to Calculate Cumulative Sums in R
How to Calculate Expected Value in R
How to Use seq Function in R
How to Use dist Function in R
How to Use diff Function in R
How to Calculate Conditional Probability in R
How to Calculate the Dot Product in R
How to Calculate Cosine Similarity in R
How to Calculate Euclidean Distance in R
How to Calculate Hamming Distance in R
How to Calculate Levenshtein Distance in R
How to Calculate Manhattan Distance in R
How to Calculate Minkowski Distance in R
How to Calculate Mahalanobis Distance in R
How to Calculate Jaccard Similarity in R
How to Calculate Combinations & Permutations in R
How to Calculate Autocorrelation in R
How to Calculate Rolling Correlation in R
How to Create Frequency Tables in R
How to Create a Frequency Table of Multiple Variables in R
How to Create Relative Frequency Tables in R
How to Create a Two Way Table in R
How to Find the Range in R
How to Calculate Interquartile Range in R
How to Use Min and Max Functions in R
How to Calculate Skewness & Kurtosis in R
How to Use the quantile() Function in R
How to Calculate Quartiles in R
How to Calculate Deciles in R
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Visualizations
How to Calculate Percentiles in R
How to Calculate Quantiles by Group in R
How to Perform Bootstrapping in R
How to Calculate Point Estimates in R
How to Find Confidence Intervals in R
How to Calculate a Binomial Confidence Interval in R
How to Create a Contingency Table in R
How to Aggregate Multiple Columns in R
How to Create Pivot Tables in R
How to Count Number of Occurrences in Columns in R
How to Count Number of Rows in R
How to Perform Matrix Multiplication in R
How to Create the Identity Matrix in R
How to Perform Element-Wise Multiplication in R
How to Perform Univariate Analysis in R
How to Calculate Cronbach’s Alpha in R
How to Calculate AUC (Area Under Curve) in R
How to Calculate F1 Score in R
How to Find the Antilog of Values in R
How to Plot Multiple Boxplots in One Chart in R
How to Create a Strip Chart in R
How to Plot Multiple Lines in One Chart in R
How to Plot Multiple Histograms in R
How to Plot Categorical Data in R
How to Create a Lollipop Chart in R
How to Create a Frequency Polygon in R
How to Use the Jitter Function in R for Scatterplots
How to Label Points on a Scatterplot in R
How to Create a Population Pyramid in R
How to Create 3D Plots in R
How to Use abline() in R
How to Create a Relative Frequency Histogram in R
How to Create a Histogram of Two Variables in R
How to Change Number of Bins in Histogram in R
How to Display Percentages on Histogram in R
How to Create a Scatterplot with a Regression Line in R
How to Create a Scatterplot in R with Multiple Variables
How to Plot Predicted Values in R
How to Use lm() Function in R to Fit Linear Models
How to Create and Interpret Pairs Plots in R
How to Plot a Confidence Interval in R
How to Plot Multiple Columns in R
How to Overlay Plots in R
How to Remove Outliers in Boxplots in R
How to Create Horizontal Boxplots in R
How to Create Radar Charts in R
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Probability Distributions
How to Create a Stacked Barplot in R
How to Create a Grouped Barplot in R
How to Create a Stacked Dot Plot in R
How to Create Added Variable Plots in R
How to Draw a Legend Outside of a Plot in R
How to Create an Interaction Plot in R
How to Create a Pareto Chart in R
How to Create a Scree Plot in R
How to Create a Bland-Altman Plot in R
How to Plot a Logistic Regression Curve in R
How to Create a Forest Plot in R
How to Create a Log-Log Plot in R
How to Change Axis Scales in R Plots
How to Change Axis Intervals in R Plots
How to Add Error Bars to Charts in R
How to Use xlim() and ylim() in R
Curve Fitting in R
How to Use Italic Font in R
How to Use the Uniform Distribution in R
How to Fit a Gamma Distribution to a Dataset in R
A Guide to dnorm, pnorm, rnorm, and qnorm in R
A Guide to dbinom, pbinom, qbinom, and rbinom in R
A Guide to dpois, ppois, qpois, and rpois in R
A Guide to dgeom, pgeom, qgeom, and rgeom in R
A Guide to dgamma, pgamma, qgamma, and rgamma in R
A Guide to dt, qt, pt, & rt in R
How to Calculate & Plot a CDF in R
How to Calculate Sampling Distributions in R
How to Apply the Empirical Rule in R
How to Plot a Normal Distribution in R
How to Plot a Chi-Square Distribution in R
How to Plot a t Distribution in R
How to Plot a Log Normal Distribution in R
How to Plot an Exponential Distribution in R
How to Plot a Binomial Distribution in R
How to Plot a Poisson Distribution in R
How to Plot a Weibull Distribution in R
How to Plot a Beta Distribution in R
How to Plot a Uniform Distribution in R
How to Calculate the P-Value of an F-Statistic in R
How to Calculate the P-Value of a Chi-Square Statistic in R
How to Calculate the P-Value of a T-Score in R
How to Calculate the P-Value of a Z-Score in R
How to Find the F Critical Value in R
How to Find the Chi-Square Critical Value in R
How to Find t Critical Values in R
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Sampling Methods
Hypothesis Tests
How to Find Z Critical Values in R
Stratified Sampling in R
Cluster Sampling in R
Systematic Sampling in R
The Complete Guide: Hypothesis Testing in R
How to Conduct a Sobel Test in R
How to Perform a One Proportion Z-Test in R
How to Perform One Sample & Two Sample Z-Tests in R
How to Conduct Fisher’s Exact Test in R
How to Conduct a Jarque-Bera Test in R
How to Conduct an Anderson-Darling Test in R
A Guide to Bartlett’s Test of Sphericity
How to Calculate Standard Deviation in R
How to Calculate Pooled Standard Deviation in R
How to Calculate Weighted Standard Deviation in R
How to Calculate Standard Deviation of Data Frame Columns in R
How to Calculate the Coefficient of Variation in R
How to Identify Influential Data Points Using Cook’s Distance
How to Conduct Levene’s Test for Equality of Variances in R
How to Perform an F-Test in R
How to Create & Interpret a Q-Q Plot in R
How to Perform a Paired t-test in R
How to Perform Welch’s t-Test in R
How to Perform the Wilcoxon Signed-Rank Test in R
How to Calculate Pooled Variance in R
How to Perform a Mann-Whitney U Test in R
How to Perform a Mann-Kendall Trend Test in R
How to Perform McNemar’s Test in R
How to Perform Grubbs’ Test in R
How to Perform a Binomial Test in R
How to Perform Mood’s Median Test in R
How to Perform Runs Test in R
How to Test for Normality in R
How to Perform Multivariate Normality Tests in R
How to Perform a Shapiro-Wilk Test in R
How to Perform a Kolmogorov-Smirnov Test in R
How to Perform a Correlation Test in R
How to Perform a Chi-Square Test of Independence in R
How to Perform a Chi-Square Goodness of Fit Test in R
How to Perform a Likelihood Ratio Test in R
How to Calculate Cramer’s V in R
How to Calculate a Phi Coefficient in R
How to Perform a Chow Test in R
How to Perform a Granger-Causality Test in R
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Regression
How to Perform Bartlett’s Test in R
How to Perform a Log Rank Test in R
How to Perform Cross Validation for Model Performance in R
How to Create a Prediction Interval for Linear Regression in R
How to Predict a Single Value Using a Regression Model in R
How to Perform Multiple Linear Regression in R
How to Perform Quadratic Regression in R
How to Perform Exponential Regression in R
How to Perform Logarithmic Regression in R
How to Perform Power Regression in R
How to Perform Robust Regression in R
How to Perform Quantile Regression in R
How to Perform Polynomial Regression in R
How to Plot a Polynomial Regression Curve in R
How to Perform Stepwise Regression in R
How to Perform Weighted Least Squares Regression in R
How to Interpret Regression Output in R
How to Interpret Pr(>|t|) in Regression Output in R
How to Calculate Variance Inflation Factor (VIF) in R
How to Perform Poisson Regression in R
How to Use the predict function with glm in R
The Difference Between glm and lm in R
How to Perform a Durbin-Watson Test in R
How to Perform a Breusch-Godfrey Test in R
How to Perform a Breusch-Pagan Test in R
How to Perform White’s Test in R
How to Perform the Goldfeld-Quandt Test in R
How to Create a Residual Plot in R
How to Calculate Residual Standard Error in R
How to Perform a Box-Cox Transformation in R
How to Find Coefficient of Determination (R-Squared) in R
How to Calculate Adjusted R-Squared in R
How to Calculate BIC in R
How to Interpret a Scale-Location Plot in R
How to Interpret Diagnostic Plots in R
How to Calculate Studentized Residuals in R
How to Calculate Standardized Residuals in R
How to Calculate Leverage Statistics in R
How to Calculate DFFITS in R
How to Calculate DFBETAS in R
How to Calculate Mallows’ Cp in R
How to Calculate AIC in R
How to Plot Multiple Linear Regression Results in R
How to Calculate Residual Sum of Squares in R
How to Create a Histogram of Residuals in R
How to Create Dummy Variables in R
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
ANOVA
Time Series
R Operations
How to Add a Regression Equation to a Plot in R
How to Perform a Lack of Fit Test in R
How to Calculate SST, SSR, and SSE in R
How to Create a Confusion Matrix in R
How to Conduct a One-Way ANOVA in R
How to Conduct a Two-Way ANOVA in R
How to Conduct a Repeated Measures ANOVA in R
How to Conduct a Nested ANOVA in R
How to Conduct a MANOVA in R
How to Conduct an ANCOVA in R
How to Perform Welch’s ANOVA in R
How to Perform the Friedman Test in R
How to Perform Tukey’s Test in R
How to Perform a Brown–Forsythe Test in R
How to Perform a Bonferroni Correction in R
How to Perform Scheffe’s Test in R
How to Perform Dunnett’s Test in R
How to Perform Dunn’s Test in R
How to Calculate Eta Squared in R
How to Create an Interaction Plot in R
How to Calculate MAPE in R
How to Calculate SMAPE in R
How to Calculate RMSE in R
How to Calculate MSE in R
How to Calculate MAD in R
How to Calculate MAE in R
How to Plot a Time Series in R
How to Perform Naive Forecasting in R
How to Perform Lowess Smoothing in R
How to Calculate an Exponential Moving Average in R
How to Aggregate Daily Data to Monthly and Yearly in R
How to Extract Year from Date in R
How to Find Day of the Week in R
How to Subset by a Date Range in R
How to Perform an Augmented Dickey-Fuller Test in R
A Guide to apply(), lapply(), sapply(), and tapply() in R
How to Add an Index (numeric ID) Column to a Data Frame in R
How to Add Superscripts & Subscripts to Plots in R
How to Check Data Type in R
How to Rename Data Frame Columns in R
How to Rename Factor Levels in R
How to Generate a Sample Using the Sample Function in R
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
How to Use the replicate() Function in R
How to Normalize Data in R
How to Standardize Data in R
How to Merge Data Frames Based on Multiple Columns in R
Interpreting Errors in R: ‘max’ not meaningful for factors
How to Handle “undefined columns selected” in R
How to Remove Rows with Some or All NAs in R
How to Select Rows Where Value Appears in Any Column in R
How to Drop Columns from Data Frame in R
How to Select Specific Columns in R
How to Select Columns by Index in R
How to Remove Specific Elements from Vector in R
R: How to Drop Rows that Contain a Specific String
How to Convert Strings to Lowercase in R
Comparing grep() vs. grepl() in R
Comparing lapply() vs. sapply() in R
How to Print All Rows of a Tibble in R
How to Switch Two Columns in R
How to Remove Outliers from Multiple Columns in R
How to Stack Data Frame Columns in R
How to Combine Two Columns into One in R
How to Combine Two Data Frames in R with Different Columns
How to Loop Through Column Names in R
How to Use “NOT IN” Operator in R
How to Subset a Data Frame in R
How to Compare Two Vectors in R
How to Compare Two Columns in R
How to Delete Multiple Columns in R
How to Find and Count Missing Values in R
How to Impute Missing Values in R
How to Use na.omit in R
How to Use na.rm in R
How to Use is.na in R
How to Use complete.cases in R
How to Use “Is Not NA” in R
How to Transform Data in R
How to Perform Arcsine Transformation in R
How to Round Numbers in R
How to Transpose a Data Frame in R
How to Create an Empty Data Frame in R
How to Create an Empty Matrix in R
How to Create an Empty List in R
How to Create an Empty Vector in R
How to Add an Empty Column to a Data Frame in R
How to Append Rows to a Data Frame in R
How to Remove Rows in R
How to Remove Rows with NA in One Column in R
How to Remove Duplicate Rows in R
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
How to Append Values to a Vector Using a Loop in R
How to Append Values to List in R
How to Combine Lists in R
How to Delete Data Frames in R
How to Perform a VLOOKUP (Similar to Excel) in R
How to Remove Dollar Signs in R
How to Create Tables in R
How to Create a Nested For Loop in R
How to Create a For Loop with Range in R
How to Select Random Samples in R
How to Generate a Normal Distribution in R
How to Use xtabs() in R to Calculate Frequencies
How to Calculate Difference Between Rows in R
How to Retrieve Row Numbers in R
How to Apply Function to Each Row in R
How to Conditionally Remove Rows in R
How to Use rowSums() Function in R
How to Use colSums() Function in R
How to Sort a Data Frame by Date in R
How to Sort Values Alphabetically in R
How to Subset Lists in R
How to Convert List to Data Frame in R
How to Convert List to Vector in R
How to Convert List to Matrix in R
How to Convert Data Frame Column to Vector in R
How to Convert Matrix to Vector in R
How to Convert Character to Numeric in R
How to Convert Character to Factor in R
How to Convert Character to a Timestamp in R
How to Convert Factor to Character in R
How to Convert Factor to Numeric in R
How to Convert a Vector to String in R
How to Convert Strings to Dates in R
How to Convert String to Datetime in R
How to Convert Numbers to Dates in R
How to Convert Date to Numeric in R
How to Convert Numeric to Character in R
How to Create a Matrix from Vectors in R
How to Interpret Significance Codes in R
How to Change Row Names in R
How to Center Data in R
How to Sum Specific Rows in R
How to Write a Nested If Else Statement in R
How to Use cbind in R
How to Use rbind in R
How to Add a Column to a Data Frame in R
How to Add Column to Data Frame in R Based on Other Columns
How to Do a Left Join in R
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
How to Fix Common Errors
How to Use the Which Function in R
How to Use the Square Root Function in R
How to Calculate Log in R
How to Sort a Data Frame by Column in R
How to Find the Max Value Across Multiple Columns in R
How to Use str_replace in R
How to Use str_split in R
How to Replace NAs with Strings in R
How to Split Column Into Multiple Columns in R
How to Replace Values in Data Frame in R
How to Use setdiff in R
How to Use the droplevels Function in R
How to Reorder Factor Levels in R
Format Numbers as Percentages in R
Partial String Matching in R
How to Create Categorical Variables in R
How to Fix: ‘x’ must be numeric
How to Fix: subscript out of bounds
How to Fix: Unexpected String Constant
How to Fix: NAs Introduced by Coercion
How to Fix: replacement has length zero
How to Fix: could not find function “ggplot”
How to Fix: incorrect number of dimensions
How to Fix: cannot change working directory
How to Fix: glm.fit: algorithm did not converge
How to Fix: dim(X) must have a positive length
How to Fix: not defined because of singularities
How to Fix: names do not match previous names
How to Fix: invalid model formula in ExtractVars
How to Fix in R: error in select unused arguments
How to Fix: $ operator is invalid for atomic vectors
How to Fix: missing value where true/false needed
How to Fix: object of type ‘closure’ is not subsettable
How to Fix: incorrect number of subscripts on matrix
How to Fix: non-numeric argument to binary operator
How to Fix: Discrete value supplied to continuous scale
How to Fix: error in plot.new() : figure margins too large
How to Fix: (list) object cannot be coerced to type ‘double’
How to Fix: argument is not numeric or logical: returning na
How to Fix: Error in plot.window(…) : need finite ‘xlim’ values
How to Fix: error in file(file, “rt”) : cannot open the connection
How to Fix: prediction from a rank-deficient fit may be misleading
How to Fix: glm.fit: fitted probabilities numerically 0 or 1 occurred
How to Fix: aesthetics must be either length 1 or the same as the data
How to Fix: longer object length is not a multiple of shorter object length
How to Fix: contrasts can be applied only to factors with 2 or more levels
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
The Tidyverse
How to Fix: error in xy.coords(x, y, xlabel, ylabel, log) :’x’ and ‘y’ lengths differ
How to Fix: error in do_one(nmeth) : na/nan/inf in foreign function call (arg 1)
How to Fix: the condition has length > 1 and only the first element will be used
How to Fix: randomForest.default(m, y, …) : Na/NaN/Inf in foreign function call
How to Fix: number of items to replace is not a multiple of replacement length
How to Fix: error: ‘\u’ used without hex digits in character string starting “‘c:\u”
The tidyverse is a collection of R packages specifically designed for data science. The following tutorials explain how to use var
dplyr
– A package designed for manipulating data.
How to Arrange Rows Using dplyr
How to Remove Rows Using dplyr
How to Remove Columns Using dplyr
How to Add Columns Using dplyr
How to Count Observations by Group Using dplyr
How to Count Distinct Values Using dplyr
How to Create a Crosstab Using dplyr
How to Filter Rows Using dplyr
How to Use a “not in” Filter in dplyr
How to Recode Values Using dplyr
How to Reorder Columns Using dplyr
How to Rename Column by Index Position Using dplyr
How to Group & Summarize Data Using dplyr
How to Find Maximum Value by Group Using dplyr
How to Replace NA with Zero Using dplyr
How to Join Multiple Data Frames Using dplyr
How to Use anti_join in dplyr
How to Use case_when in dplyr
How to Use bind_rows and bind_cols in dplyr
How to Select Columns by Index Using dplyr
How to Calculate Relative Frequencies Using dplyr
How to Create a Frequency Table by Group Using dplyr
How to Select the First Row by Group Using dplyr
How to Rank Variables by Group Using dplyr
How Use Mutate in dplyr
How to Use Conditional Mutate in dplyr
tidyr
– A package designed for creating tidy data.
How to use the spread() function
How to use the gather() function
How to use the separate() function
How to use the unite() function
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
ggplot2
– A package designed for visualizing data.
A Complete Guide to the Best ggplot2 Themes
The Complete Guide to ggplot2 Titles
How to Change Background Color in ggplot2
How to Use a Transparent Background in ggplot2
How to Draw a Trend Line in ggplot2
How to Plot Two Lines in ggplot2
How to Change Font Size in ggplot2
How to Change the Legend Title in ggplot2
How to Change Legend Size in ggplot2
How to Change Legend Position in ggplot2
How to Change Legend Labels in ggplot2
How to Remove a Legend in ggplot2
How to Create Side-by-Side Plots in ggplot2
How to Set Axis Limits in ggplot2
How to Create a Bump Chart in R Using ggplot2
How to Create a Gantt Chart in R Using ggplot2
How to Create a Heatmap in R Using ggplot2
How to Overlay Density Plots in ggplot2
How to Make Pie Charts in ggplot2
How to Create a Grouped Boxplot in R Using ggplot2
How to Create Side-by-Side Boxplots in R
How to Create a Barplot in ggplot2 with Multiple Variables
How to Order the Bars in a ggplot2 Bar Chart
How to Plot a Linear Regression Line in ggplot2
How to Plot a Regression Line by Group with ggplot2
How to Add a Vertical Line to a Plot Using ggplot2
How to Add a Horizontal Line to a Plot Using ggplot2
How to Create a Log Scale in ggplot2
How to Create Smooth Lines in ggplot2
How to Plot a ROC Curve Using ggplot2
How to Assign Colors by Factor in ggplot2
How to Adjust Line Thickness in ggplot2
How to Use facet_wrap in ggplot2
How to Remove Gridlines in ggplot2
How to Remove Axis Labels in ggplot2
How to Rotate Axis Labels in ggplot2
How to Modify the Margins in ggplot2
How to Set Axis Breaks in ggplot2
How to Set Axis Label Position in ggplot2
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
https://www.statology.org/python-guides/
Python Guides
This page lists every Python tutorial available on Statology.
Descriptive Statistics
How to Calculate Z-Scores in Python
How to Calculate Correlation in Python
How to Calculate Spearman Rank Correlation in Python
How to Calculate Partial Correlation in Python
How to Calculate Cross Correlation in Python
How to Calculate Point-Biserial Correlation in Python
How to Calculate Intraclass Correlation Coefficient in Python
How to Create a Correlation Matrix in Python
How to Create a Covariance Matrix in Python
How to Calculate a Trimmed Mean in Python
How to Normalize Data in Python
How to Remove Outliers in Python
How to Calculate Levenshtein Distance in Python
How to Calculate Mahalanobis Distance in Python
How to Calculate Manhattan Distance in Python
How to Calculate Hamming Distance in Python
Equal Frequency Binning in Python
How to Calculate Jaccard Similarity in Python
How to Create Frequency Tables in Python
How to Calculate Relative Frequency in Python
How to Create a Contingency Table in Python
How to Calculate The Interquartile Range in Python
How to Calculate Sample & Population Variance in Python
How to Calculate the Standard Error of the Mean in Python
How to Calculate the Standard Deviation of a List in Python
How to Calculate Skewness & Kurtosis in Python
How to Calculate Cosine Similarity in Python
How to Calculate Euclidean Distance in Python
How to Calculate Conditional Probability in Python
How to Calculate Percentiles in Python
How to Calculate Deciles in Python
How to Perform a Box-Cox Transformation in Python
How to Calculate Cramer’s V in Python
How to Calculate the Coefficient of Variation in Python
How to Find the Antilog of Values in Python
How to Transform Data in Python
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Data Visualizations
Probability Distributions
Sampling Methods
Hypothesis Tests
How to Create an Ogive Graph in Python
How to Make a Bell Curve in Python
How to Create Heatmaps in Python
How to Create a Stem-and-Leaf Plot in Python
How to Create a Population Pyramid in Python
How to Create a Bland-Altman Plot in Python
How to Add Error Bars to Charts in Python
How to Plot a ROC Curve in Python
How to Create a Scree Plot in Python
How to Create a Precision-Recall Curve in Python
How to Create a Log-Log Plot in Python
How to Calculate & Plot a CDF in Python
Curve Fitting in Python
How to Create a Scatterplot with a Regression Line in Python
How to Use the Binomial Distribution in Python
How to Use the Poisson Distribution in Python
How to Generate a Normal Distribution in Python
How to Find the F Critical Value in Python
How to Find the T Critical Value in Python
How to Find the Z Critical Value in Python
How to Find the Chi-Square Critical Value in Python
How to Find a P-Value from a t-Score in Python
How to Find a P-Value from a Z-Score in Python
How to Plot a Normal Distribution in Python
How to Plot a Chi-Square Distribution in Python
Stratified Sampling in Pandas
Cluster Sampling in Pandas
Systematic Sampling in Pandas
How to Conduct a One Sample T-Test in Python
How to Conduct a Two Sample T-Test in Python
How to Perform Welch’s t-test in Python
How to Perform Z-Tests in Python
How to Perform a One Proportion Z-Test in Python
How to Conduct a Mann-Whitney U Test in Python
How to Conduct a Paired Samples T-Test in Python
How to Conduct a Wilcoxon Signed-Rank Test in Python
How to Perform Levene’s Test in Python
How to Perform a Brown–Forsythe Test in Python
How to Perform an F-Test in Python
How to Perform a Binomial Test in Python
How to Perform Grubbs’ Test in Python
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Confidence Intervals
Regression
ANOVA
How to Perform a Shapiro-Wilk Test in Python
How to Perform a Kolmogorov-Smirnov Test in Python
How to Perform Runs Test in Python
How to Perform Multivariate Normality Tests in Python
How to Perform a Ljung-Box Test in Python
How to Perform a Mann-Kendall Trend Test in Python
How to Calculate Confidence Intervals in Python
How to Plot a Confidence Interval in Python
How to Perform Linear Regression in Python
How to Perform Quadratic Regression in Python
How to Perform Polynomial Regression in Python
How to Perform Quantile Regression in Python
How to Perform Exponential Regression in Python
How to Perform Logarithmic Regression in Python
How to Create a Q-Q Plot in Python
How to Plot Line of Best Fit in Python
How to Perform a Breusch-Pagan Test in Python
How to Perform a Breusch-Godfrey Test in Python
How to Calculate VIF in Python
How to Perform a Jarque-Bera Test in Python
How to Create a Residual Plot in Python
How to Perform a Durbin-Watson Test in Python
How to Perform an Anderson-Darling Test in Python
How to Calculate Adjusted R-Squared in Python
How to Calculate BIC of Regression Models in Python
How to Calculate AIC of Regression Models in Python
How to Calculate AUC (Area Under Curve) in Python
How to Calculate F1 Score in Python
How to Create a Confusion Matrix in Python
How to Calculate Studentized Residuals in Python
How to Calculate Standardized Residuals in Python
How to Calculate Cook’s Distance in Python
How to Calculate Residual Sum of Squares in Python
How to Create Dummy Variables in Python
How to Perform One-Hot Encoding in Python
How to Perform a One-Way ANOVA in Python
How to Perform a Two-Way ANOVA in Python
How to Perform a Repeated Measures ANOVA in Python
How to Perform a Kruskal-Wallis Test in Python
How to Perform the Friedman Test in Python
How to Perform an ANCOVA in Python
How to Perform Welch’s ANOVA in Python
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Chi-Square Tests
Time Series
Python Operations
How to Fix Common Errors
How to Perform Dunn’s Test in Python
How to Perform the Nemenyi Test in Python
How to Perform Bartlett’s Test in Python
How to Perform Tukey’s Test in Python
How to Perform McNemar’s Test in Python
How to Perform Fisher’s Exact Test in Python
How to Perform a Chi-Square Goodness of Fit Test in Python
How to Perform a Chi-Square Test of Independence in Python
How to Calculate MAPE in Python
How to Calculate SMAPE in Python
How to Calculate RMSE in Python
How to Calculate Mean Squared Error (MSE) in Python
How to Calculate Median Absolute Deviation in Python
How to Calculate Mean Absolute Error in Python
How to Calculate Moving Averages in Python
How to Calculate an Exponential Moving Average in Python
How to Calculate Autocorrelation in Python
How to Calculate Rolling Correlation in Python
How to Calculate a Rolling Mean in Pandas
How to Perform an Augmented Dickey-Fuller Test in Python
How to Use NumPy: import numpy as np
How to Replace Values in a List in Python
How to Calculate Geometric Mean in Python
How to Zip Two Lists in Python
How to Find Index of Max Value in List in Python
How to Concatenate Arrays in Python
How to Create an Array of Arrays in Python
How to Perform a COUNTIF Function in Python
How to Fix: NameError name ‘np’ is not defined
How to Fix: NameError name ‘pd’ is not defined
How to Fix: KeyError in Pandas
How to Fix: No module named numpy
How to Fix: No module named pandas
How to Fix: SettingWithCopyWarning
How to Fix: TypeError: no numeric data to plot
How to Fix: ‘numpy.float64’ object is not iterable
How to Fix: columns overlap but no suffix specified
How to Fix: invalid value encountered in true_divide
How to Fix: TypeError: ‘numpy.float’ object is not callable
How to Fix: ‘numpy.ndarray’ object has no attribute ‘index’
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
pandas
Input/Output
General Functions
How to Fix: RuntimeWarning: overflow encountered in exp
How to Fix: if using all scalar values, you must pass an index
How to Fix: Length of values does not match length of index
How to Fix: ‘numpy.ndarray’ object has no attribute ‘append’
How to Fix: ValueError: cannot convert float NaN to integer
How to Fix: Can only compare identically-labeled series objects
How to Fix: All input arrays must have same number of dimensions
How to Fix: ‘numpy.float64’ object cannot be interpreted as an integer
How to Fix: SyntaxError: positional argument follows keyword argument
How to Fix: ValueError: operands could not be broadcast together with shapes
pandas
is a data analysis library built on top of the Python programming language. The following tutorials explain how to use various functions within this librar
How to Read CSV Files with Pandas
How to Read JSON Files with Pandas
How to Read Excel Files with Pandas
How to Read CSV Files with NumPy
How to Read Text Files with Pandas
How to Read Text File Into List in Python
How to Export NumPy Array to CSV File
How to Export Pandas DataFrame to CSV File
How to Export Pandas DataFrame to JSON
How to Export Pandas DataFrame to Excel
How to Append Pandas DataFrame to Existing CSV File
How to Combine Multiple Excel Sheets in Pandas
How to Write Pandas DataFrames to Multiple Excel Sheets
How to Use Pandas in Python: import pandas as pd
How to Show All Columns of a Pandas DataFrame
How to List All Column Names in Pandas
How to Rename Columns in Pandas
How to Stack Multiple Pandas DataFrames
How to Merge Two or More Series in Pandas
How to Merge Two Pandas DataFrames on Index
How to Merge Pandas DataFrames on Multiple Columns
How to Append Two Pandas DataFrames
How to Perform a VLOOKUP in Pandas
How to Split a Pandas DataFrame into Multiple DataFrames
How to Change the Order of Columns in Pandas
How to Rename Index in Pandas DataFrame
How to Add a Column to a Pandas DataFrame
How to Add Rows to a Pandas DataFrame
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
How to Add Header Row to Pandas DataFrame
How to Get First Column of Pandas DataFrame
How to Get First Row of Pandas DataFrame
How to Get Cell Value from Pandas DataFrame
How to Set Cell Value in Pandas DataFrame
How to Find Unique Values in Multiple Columns in Pandas
How to Count Unique Values in Pandas
How to Count Occurrences of Specific Value in Pandas Column
How to Use idxmax() Function in Pandas
How to Use describe() Function in Pandas
How to Use where() Function in Pandas
How to Use value_counts() Function in Pandas
How to Use head() Function in Pandas
How to Count Missing Values in a Pandas DataFrame
How to Count Number of Rows in Pandas DataFrame
How to Convert Datetime to Date in Pandas
How to Convert Timestamp to Datetime in Pandas
How to Filter Pandas DataFrame Rows by Date
How to Extract Month from Date in Pandas
How to Filter a Pandas DataFrame by Column Values
How to Use “NOT IN” Filter in Pandas
How to Sort a Pandas DataFrame by Date
How to Sort a Pandas DataFrame by Column Name
How to Sort a Pandas DataFrame by Both Index and Column
How to Get Row Numbers in a Pandas DataFrame
How to Split String Column in Pandas into Multiple Columns
How to Convert a NumPy Array to Pandas DataFrame
How to Calculate Dot Product Using NumPy
How to Calculate the Magnitude of a Vector Using NumPy
How to Find Index of Value in NumPy Array
How to Select Rows by Index in a Pandas DataFrame
How to Select Rows Based on Column Values in Pandas
How to Make a Scatterplot From a Pandas DataFrame
How to Fill NA Values for Multiple Columns in Pandas
How to Perform a SUMIF Function in Pandas
How to Compare Two Columns in Pandas
How to Calculate Correlation Between Two Columns in Pandas
How to Create Boxplot from Pandas DataFrame
How to Create Pie Chart from Pandas DataFrame
How to Create a Histogram from Pandas DataFrame
How to Create a Scatter Matrix in Pandas
How to Plot Multiple Series from a Pandas DataFrame
Pandas: Get Index of Rows Whose Column Matches Value
Pandas: How to Plot Multiple Columns on Bar Chart
Pandas: How to Find the Difference Between Two Rows
Pandas: How to Find the Difference Between Two Columns
Pandas: Difference Between Join vs. Merge
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
DataFrame Functions
How to Calculate the Sum of Columns in Pandas
How to Calculate the Mean of Columns in Pandas
How to Calculate the Median of Columns in Pandas
How to Find the Max Value of Columns in Pandas
How to Calculate Standard Deviation in Pandas
How to Apply a Function to Selected Columns in Pandas
How to Use axis=0 and axis=1 in Pandas
How to Use Pandas apply() inplace
How to Calculate a Weighted Average in Pandas
How to Calculate Percent Change in Pandas
How to Compare Two DataFrames in Pandas
How to Convert Pandas DataFrame Columns to Strings
How to Convert Pandas DataFrame Columns to Integer
How to Use Pandas fillna() to Replace NaN Values
How to Replace Values in a Pandas DataFrame
How to Replace NaN Values with Zero in Pandas
How to Drop Rows with NaN Values in Pandas
How to Drop Rows that Contain a Specific Value in Pandas How to Drop Rows by Index in Pandas
How to Filter a Pandas DataFrame on Multiple Conditions
How to Insert a Column Into a Pandas DataFrame
How to Create a New Column Based on a Condition in Pandas
How to Add an Empty Column to a Pandas DataFrame
How to Subtract Two Columns in Pandas DataFrame
How to Convert Strings to Float in Pandas
How to Convert Pandas Series to NumPy Array
How to Convert Pandas Series to DataFrame
How to Convert Pandas DataFrame to Dictionary
How to Convert Pandas DataFrame to NumPy Array
How to Convert a List to a DataFrame in Python
How to Convert a List to a DataFrame Row in Python
How to Convert List to NumPy Array
How to Convert NumPy Array to List
How to Add a Column to a NumPy Array
How to Get Specific Column from NumPy Array
How to Convert Columns to DateTime in Pandas
How to Find the Sum of Rows in a Pandas DataFrame
How to Bin Variables in Python Using numpy.digitize()
How to Normalize Data in a Pandas DataFrame
How to Standardize Data in a Pandas DataFrame
How to Drop the Index Column in Pandas
How to Reset an Index in Pandas DataFrame
How to Convert Index to Column in Pandas
How to Flatten MultiIndex in Pandas
How to Exclude Columns in Pandas
How to Set Column as Index in Pandas
How to Add a Numpy Array to a Pandas DataFrame
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Matplotlib
How to Map a Function Over a NumPy Array
How to Calculate Quantiles by Group in Pandas
How to Count Observations by Group in Pandas
How to Find the Max Value by Group in Pandas
How to Perform a GroupBy Sum in Pandas
How to Drop Duplicate Rows in a Pandas
How to Drop Duplicate Columns in Pandas
How to Combine Two Columns in Pandas
How to Drop Columns in Pandas
How to Drop Columns by Index in Pandas
How to Select Multiple Columns in Pandas
How to Shuffle Rows in Pandas DataFrame
How to Iterate Over Columns in Pandas DataFrame
How to Iterate Over Rows in Pandas DataFrame
Pandas: Select Rows Where Value Appears in Any Column
Pandas: How to Group and Aggregate by Multiple Columns
Pandas: How to Find Unique Values in a Column
Pandas: How to Drop Rows that Contain a Specific String
Matplotlib
is a data visualization library built on top of the Python programming language. The following tutorials explain how to use various functions within th
library.
How to Color a Scatterplot by Value in Matplotlib
How to Generate Random Colors in Matplotlib
How to Create Boxplots by Group in Matplotlib
How to Create Multiple Matplotlib Plots in One Figure
How to Increase Plot Size in Matplotlib
How to Save Matplotlib Figure to a File
How to Export Matplotlib Plot with Transparent Background
How to Plot Multiple Lines in Matplotlib
How to Create a Density Plot in Matplotlib
How to Plot a Time Series in Matplotlib
How to Draw a Vertical Line in Matplotlib
How to Draw a Horizontal Line in Matplotlib
How to Plot Histogram from List of Data in Matplotlib
How to Adjust Bin Size in Matplotlib Histograms
How to Add Legend to Scatterplot in Matplotlib
How to Change Font Sizes on a Matplotlib Plot
How to Change Font Family in Matplotlib
How to Create a Contour Plot in Matplotlib
How to Remove Ticks from Matplotlib Plots
How to Rotate Tick Labels in Matplotlib
How to Change the Number of Ticks in Matplotlib
How to Set Tick Labels Font Size in Matplotlib
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Seaborn
How to Create Matplotlib Plots with Log Scales
How to Show Gridlines on Matplotlib Plots
How to Place the Legend Outside of a Matplotlib Plot
How to Plot a Smooth Curve in Matplotlib
How to Create Stacked Bar Charts in Matplotlib
How to Adjust the Position of a Matplotlib Colorbar
How to Adjust Axis Label Position in Matplotlib
How to Annotate Matplotlib Scatterplots
How to Add Titles to Plots in Matplotlib
How to Adjust Title Position in Matplotlib
How to Adjust Spacing Between Matplotlib Subplots
How to Adjust Subplot Size in Matplotlib
How to Create a Quiver Plot in Matplotlib
How to Adjust Marker Size in Matplotlib
How to Plot Circles in Matplotlib
How to Change Background Color in Matplotlib
How to Fill in Areas Between Lines in Matplotlib
How to Draw Rectangles in Matplotlib
How to Draw Arrows in Matplotlib
How to Adjust Line Thickness in Matplotlib
How to Set the Aspect Ratio in Matplotlib
How to Add Text to Matplotlib Plots
How to Set Axis Ranges in Matplotlib
How to Set X-Axis Values in Matplotlib
How to Change Legend Font Size in Matplotlib
How to Create a Table with Matplotlib
Seaborn
is a data visualization library built on top of matplotlib. The following tutorials explain how to use various functions within this library.
How to Use Seaborn: import seaborn as sns
How to Create Multiple Seaborn Plots in One Figure
How to Create Heatmaps in Seaborn
How to Create a Time Series Plot in Seaborn
How to Create a Pie Chart in Seaborn
How to Create Barplots in Seaborn
How to Create an Area Chart in Seaborn
How to Show Values on Seaborn Barplot
How to Create a Pairs Plot in Seaborn
How to Adjust the Figure Size of a Seaborn Plot
How to Change Axis Labels on a Seaborn Plot
How to Adjust Number of Ticks in Seaborn Plots
How to Change the Position of a Legend in Seaborn
How to Change Legend Font Size in a Seaborn Plot
How to Place Legend Outside a Seaborn Plot
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
How to Create Subplots in Seaborn
How to Add a Title to Seaborn Plots
How to Save Seaborn Plot to a File
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Table 1: Results of experiment comparing two treatments
All Patients
Improved
Not improved
Percent improved
New treatment
20
20
50
Standard treatment
24
6
60
Experiment disaggrgated by sex
Men Only Improved
Not improved
Percent improved
New treatment
12
18
40
Standard treatment
3
7
30
Woman Only Improved
Not improved
Percent improved
New treatment
8
2
80
Standard treatment
21
9
70
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Function
AVEDEV function
AVERAGE function
AVERAGEA function
AVERAGEIF function
AVERAGEIFS function
BETA.DIST function
BETA.INV function
BINOM.DIST function
BINOM.DIST.RANGE function
BINOM.INV function
CHISQ.DIST function
CHISQ.DIST.RT function
CHISQ.INV function
CHISQ.INV.RT function
CHISQ.TEST function
CONFIDENCE.NORM function
CONFIDENCE.T function
CORREL function
COUNT function
COUNTA function
COUNTBLANK function
COUNTIF function
COUNTIFS function
COVARIANCE.P function
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
COVARIANCE.S function
DEVSQ function
EXPON.DIST function
F.DIST function
F.DIST.RT function
F.INV function
F.INV.RT function
F.TEST function
FISHER function
FISHERINV function
FORECAST function
FORECAST.ETS function
FORECAST.ETS.CONFINT function
FORECAST.ETS.SEASONALITY function
FORECAST.ETS.STAT function
FORECAST.LINEAR function
FREQUENCY function
GAMMA function
GAMMA.DIST function
GAMMA.INV function
GAMMALN function
GAMMALN.PRECISE function
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
GAMMALN.PRECISE function
GAUSS function
GEOMEAN function
GROWTH function
HARMEAN function
HYPGEOM.DIST function
INTERCEPT function
KURT function
LARGE function
LINEST function
LOGEST function
LOGNORM.DIST function
LOGNORM.INV function
MAX function
MAXA function
MAXIFS function
MEDIAN function
MIN function
MINIFS function
MINA function
MODE.MULT function
MODE.SNGL function
NEGBINOM.DIST function
NORM.DIST function
NORM.INV function
NORM.S.DIST function
NORM.S.INV function
PEARSON function
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
PERCENTILE.EXC function
PERCENTILE.INC function
PERCENTRANK.EXC function
PERCENTRANK.INC function
PERMUT function
PERMUTATIONA function
PHI function
POISSON.DIST function
PROB function
QUARTILE.EXC function
QUARTILE.INC function
RANK.AVG function
RANK.EQ function
RSQ function
SKEW function
SKEW.P function
SLOPE function
SMALL function
STANDARDIZE function
STDEV.P function
STDEV.S function
STDEVA function
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
STDEVPA function
STEYX function
T.DIST function
T.DIST.2T function
T.DIST.RT function
T.INV function
T.INV.2T function
T.TEST function
TREND function
TRIMMEAN function
VAR.P function
VAR.S function
VARA function
VARPA function
WEIBULL.DIST function
Z.TEST function
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Description
Returns the average of the absolute deviations of data points from their mean
Returns the average of its arguments
Returns the average of its arguments, including numbers, text, and logical values
Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria
Returns the average (arithmetic mean) of all cells that meet multiple criteria
Returns the beta cumulative distribution function
Returns the inverse of the cumulative distribution function for a specified beta distribution
Returns the individual term binomial distribution probability
Returns the probability of a trial result using a binomial distribution
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
Returns the cumulative beta probability density function
Returns the one-tailed probability of the chi-squared distribution
Returns the cumulative beta probability density function
Returns the inverse of the one-tailed probability of the chi-squared distribution
Returns the test for independence
Returns the confidence interval for a population mean
Returns the confidence interval for a population mean, using a Student's t distribution
Returns the correlation coefficient between two data sets
Counts how many numbers are in the list of arguments
Counts how many values are in the list of arguments
Counts the number of blank cells within a range
Counts the number of cells within a range that meet the given criteria
Counts the number of cells within a range that meet multiple criteria
Returns covariance, the average of the products of paired deviations
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Returns the sample covariance, the average of the products deviations for each data point pair in two data sets
Returns the sum of squares of deviations
Returns the exponential distribution
Returns the F probability distribution
Returns the F probability distribution
Returns the inverse of the F probability distribution
Returns the inverse of the F probability distribution
Returns the result of an F-test
Returns the Fisher transformation
Returns the inverse of the Fisher transformation
Returns a value along a linear trend
Returns a confidence interval for the forecast value at the specified target date
Returns the length of the repetitive pattern Excel detects for the specified time series
Returns a statistical value as a result of time series forecasting
Returns a future value based on existing values
Returns a frequency distribution as a vertical array
Returns the gamma function value
Returns the gamma distribution
Returns the inverse of the gamma cumulative distribution
Returns the natural logarithm of the gamma function, Γ(x)
Returns the natural logarithm of the gamma function, Γ(x)
Note:
In Excel 2016, this function is replaced with
FORECAST.LINEAR
as part of the new
Forecasting functions
, but it's still available for compatibility with earlier versions.
Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Returns the natural logarithm of the gamma function, Γ(x)
Returns 0.5 less than the standard normal cumulative distribution
Returns the geometric mean
Returns values along an exponential trend
Returns the harmonic mean
Returns the hypergeometric distribution
Returns the intercept of the linear regression line
Returns the kurtosis of a data set
Returns the k-th largest value in a data set
Returns the parameters of a linear trend
Returns the parameters of an exponential trend
Returns the cumulative lognormal distribution
Returns the inverse of the lognormal cumulative distribution
Returns the maximum value in a list of arguments
Returns the maximum value in a list of arguments, including numbers, text, and logical values
Returns the maximum value among cells specified by a given set of conditions or criteria
Returns the median of the given numbers
Returns the minimum value in a list of arguments
Returns the minimum value among cells specified by a given set of conditions or criteria.
Returns the smallest value in a list of arguments, including numbers, text, and logical values
Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data
Returns the most common value in a data set
Returns the negative binomial distribution
Returns the normal cumulative distribution
Returns the inverse of the normal cumulative distribution
Returns the standard normal cumulative distribution
Returns the inverse of the standard normal cumulative distribution
Returns the Pearson product moment correlation coefficient
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
Returns the k-th percentile of values in a range
Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set
Returns the percentage rank of a value in a data set
Returns the number of permutations for a given number of objects
Returns the value of the density function for a standard normal distribution
Returns the Poisson distribution
Returns the probability that values in a range are between two limits
Returns the quartile of the data set, based on percentile values from 0..1, exclusive
Returns the quartile of a data set
Returns the rank of a number in a list of numbers
Returns the rank of a number in a list of numbers
Returns the square of the Pearson product moment correlation coefficient
Returns the skewness of a distribution
Returns the slope of the linear regression line
Returns the k-th smallest value in a data set
Returns a normalized value
Calculates standard deviation based on the entire population
Estimates standard deviation based on a sample
Estimates standard deviation based on a sample, including numbers, text, and logical values
Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects
Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Calculates standard deviation based on the entire population, including numbers, text, and logical values
Returns the standard error of the predicted y-value for each x in the regression
Returns the Percentage Points (probability) for the Student t-distribution
Returns the Percentage Points (probability) for the Student t-distribution
Returns the Student's t-distribution
Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom
Returns the inverse of the Student's t-distribution
Returns the probability associated with a Student's t-test
Returns values along a linear trend
Returns the mean of the interior of a data set
Calculates variance based on the entire population
Estimates variance based on a sample
Estimates variance based on a sample, including numbers, text, and logical values
Calculates variance based on the entire population, including numbers, text, and logical values
Returns the Weibull distribution
Returns the one-tailed probability-value of a z-test
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
what kind of charts are used in to describe HTS data
arrow_forward
The correlation of variables can be determined by studying its scatter plot. The scatter plot can be described through its form, also known as (1)____. The form of scatter plot is either linear or
(2)____.
In terms of
(3)____of correlation, it could be categorized as positive or negative
correlation depending on the behavior of the points. The variables can also have no
correlation.
The strength of correlation also known as
(4)____determines the closeness of the
points in a line. If the points are plotted and they form a line, then there is
(5)____ correlation.
arrow_forward
please expalin
arrow_forward
->
yah
A https://www.mathxl.com/Student/PlayerTest.aspx?testld%3D225082817
MAT103 - Wintersession 2021
Test: Exam #1
This Question: 3 pts
10 of 17 (9 complete) ▼
Find the mean, median, and mode of the data, if possible. If any of these measures cannot be found or a measure does not represent the center of the data, explain why.
The cholesterol levels of a sample of 10 female employees are listed below.
165
230
115
175
220
215
180
115
137
145
What is the mean cholesterol level? Select the correct choice below and fill in any answer box to complete your choice.
O A. The mean cholesterol level is
(Round to one decimal place as needed.)
O B. There is no mean score.
Does the mean represent the center of the data?
A. The mean represents the center.
B. The mean does not represent the center because it is the largest data value.
C. The mean does not represent the center because it is not a data value
D. The mean does not represent the center because it is the smallest data value.
What is the…
arrow_forward
please don’t reject the question
arrow_forward
A correlation coefficient should be used when the independent and dependent variable are measured as
categorical
nominal
ordinal
continuous
arrow_forward
Please explain your answer
arrow_forward
duration (amount of time) is what type of data?
arrow_forward
Prove the property
arrow_forward
Describe the range of values for the correlation coefficient.
arrow_forward
Using the boxplot, find the following. ** Plot is attached in photos**
Identify the maximum value, minimum value, median, first quartile, and third quartile.
Maximum value
=
Minimum value
=
Median
=
First quartile
=
Third quartile
=
Find the Interquartile Range.
Interquartile range
=
arrow_forward
Two lines are proposed to describe the relationship between x and y for a particular data set. Shown below are the lines and the sum of squared error for each line.
Line1: yˆ = 5+ 4x, Sumofsquarederror= 48.6
Line2: yˆ = 6 + 3.5x, Sumofsquarederror= 40.8
One of these two lines is the regression line. Which line is the regression line?
arrow_forward
elogin
|||
X
12 McGraw-Hill Campus - Intro to S.X
https://www-awu.aleks.com/alekscgi/x/Isl.exe/1o_u IgNslkr7j8P3jH-IBlu6HJ1SV
O DESCRIPTIVE STATISTICS
Finding quartiles
Median:
The following are the ages of 13 physics teachers in a school district.
24, 27, 31, 33, 35, 36, 39, 41, 43, 46, 46, 55, 56
Notice that the ages are ordered from least to greatest.
Give the median, lower quartile, and upper quartile for the data set.
McGraw-Hill
(b) Lower quartile:
(c) Upper quartile: 0
Explanation Check
X
arrow_forward
Please do not give solution in image format thanku
arrow_forward
If you want to quickly observe the brief statistics of a DataFrame object in the form shown below, please write the corresponding method name on the horizontal line
iris_df_length.________________()sepal length (cm) petal length (cm)count 150.000000 150.000000mean 5.843333 3.758000std 0.828066 1.765298min 4.300000 1.00000025% 5.100000 1.60000050% 5.800000 4.35000075% 6.400000 5.100000max 7.900000 6.900000
arrow_forward
Describe about the correlation coefficient for quantitative data.
arrow_forward
Chi-square is different. Explain why it's different and what types of data require you to use chi-square for analysis. Please give an example.
arrow_forward
Create a model for the data using the 1st and 3rd points in the data set.
1909
90.490
1st point^
1929
121.767
3 rd point ^
y= years since 1909
P=population of the United States (in millions)
arrow_forward
Quiz Grade
Frequency
100
98
95
92
88
85
80
75
What is the
range of
the quiz
grades?
III
II
Enter
us Corporation. All Rights Reserved.
Z=Z_
arrow_forward
An outlier is a data point that
may be an abnormal result
should sometimes be left out of a statistical analysis
may significantly affect the calculation of the correlation
all of the above
arrow_forward
What is the coefficient of correlation given this data: X = 51, 42, 34, 10, -1 Y = 59, 30, 24, 19, -11 Please format to 2 decimal places.
arrow_forward
Quiz for Chapter 21 LearningCur X +
/learningcurve.macmillanlearning.com/?user_id=3e6bfbb2-26e7-11ed-9c99-653e998b9738&file=stats%2Fbps9e%2Fbps9e_chapter21_achieve&itemic
X
D21 Chapter 21 Learning Curve: Comp X
An experiment was conducted to see if elderly patients had more trouble keeping their balance when loud,
unpredictable noises were made compared to younger patients who were also exposed to the noises.
Researchers compared the amount of forward and backward sway for the two groups. The researchers
conducted the experiment and obtained data summarized in the following table:
XSE
Elderly Young
26.33 18.13
9.77
4.09
9
18
The standardized test statistic is t =
equation? Answer to two decimal places.
Your answer:
2.30
E
Need help on this question?
Read the ebook page on this topic
(no penalty)
CO
26.33-18.13
B2
9.772+ B²
18
O Search
Get a hint
(fewer points)
L
2.30. What belongs in place of the letter B in the
G
Show answer
(no points)
DELL
Challenge this Question
prese
X
inseri
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Related Questions
- what kind of charts are used in to describe HTS dataarrow_forwardThe correlation of variables can be determined by studying its scatter plot. The scatter plot can be described through its form, also known as (1)____. The form of scatter plot is either linear or (2)____. In terms of (3)____of correlation, it could be categorized as positive or negative correlation depending on the behavior of the points. The variables can also have no correlation. The strength of correlation also known as (4)____determines the closeness of the points in a line. If the points are plotted and they form a line, then there is (5)____ correlation.arrow_forwardplease expalinarrow_forward
- -> yah A https://www.mathxl.com/Student/PlayerTest.aspx?testld%3D225082817 MAT103 - Wintersession 2021 Test: Exam #1 This Question: 3 pts 10 of 17 (9 complete) ▼ Find the mean, median, and mode of the data, if possible. If any of these measures cannot be found or a measure does not represent the center of the data, explain why. The cholesterol levels of a sample of 10 female employees are listed below. 165 230 115 175 220 215 180 115 137 145 What is the mean cholesterol level? Select the correct choice below and fill in any answer box to complete your choice. O A. The mean cholesterol level is (Round to one decimal place as needed.) O B. There is no mean score. Does the mean represent the center of the data? A. The mean represents the center. B. The mean does not represent the center because it is the largest data value. C. The mean does not represent the center because it is not a data value D. The mean does not represent the center because it is the smallest data value. What is the…arrow_forwardplease don’t reject the questionarrow_forwardA correlation coefficient should be used when the independent and dependent variable are measured as categorical nominal ordinal continuousarrow_forward
- Describe the range of values for the correlation coefficient.arrow_forwardUsing the boxplot, find the following. ** Plot is attached in photos** Identify the maximum value, minimum value, median, first quartile, and third quartile. Maximum value = Minimum value = Median = First quartile = Third quartile = Find the Interquartile Range. Interquartile range =arrow_forwardTwo lines are proposed to describe the relationship between x and y for a particular data set. Shown below are the lines and the sum of squared error for each line. Line1: yˆ = 5+ 4x, Sumofsquarederror= 48.6 Line2: yˆ = 6 + 3.5x, Sumofsquarederror= 40.8 One of these two lines is the regression line. Which line is the regression line?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL