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
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
Related Questions
Duration is what typye of data?
arrow_forward
Differentiate between nominal data and ordinal data.
Give at least two examples of nominal and ordinal data.
arrow_forward
Describe the difference between parametric statistics and non-parametric statistics. What is an example of a test for each form of statistics?
arrow_forward
Find out some examples for statistic and parameter?
arrow_forward
Please help me with this scatter plot
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 find attached image for table
Estimating Relationships – There are many statistical tools used to estimate relationships between variables. These include covariance, correlation, ANOVA, simple linear regression, and multiple regression. In the table below, enter a Yes (or Y) or No (or N) in each box to indicate the best response. If a box does not apply, enter NA.
arrow_forward
Differentiate
- Parameter vs statistic
arrow_forward
What is the similarities of parameter and statistics
arrow_forward
What are the examples of parameter and examples of statistic
arrow_forward
Develop the relationship between correlation coefficient and regression coefficient.
Mention the applications of correlation and regression.
arrow_forward
A correlation coefficient should be used when the independent and dependent variable are measured as
categorical
nominal
ordinal
continuous
arrow_forward
Prove the property
arrow_forward
The coefficient of determination
is the square root of the correlation coefficient
is the same as the correlation coefficient
cannot be negative
can be negative or positive
arrow_forward
Define Bivariate Relationships?
arrow_forward
please highlight the correct answer
Choose all that apply
arrow_forward
Which of the following sets of data represent valid functions?
OS = {(0, – 1), (3, 1), (6, 4), (7, 9), (13, 14)}
%3D
-
OF= {(-3, - 2), (1, 2), (1, 4), (8, 9), (13, 15)}
OR = {(- 1, – 2), (2, 1), (4, 5), ( – 1, – 2), (10, 13)}
OG = {(- 4, - 5), (2, 3), (4, 5), (9, 8), (14, 10)}
%3D
Calculator
Check Answer
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
Pls do fast its urgent!!. I will give like for sure .. try to answer in typed form pls..
arrow_forward
Distinguish briefly the Parameters and statistics
arrow_forward
Discuss different situations where a teacher can use Correlation and Regression to draw conclusions.
Please give answer in detail.thanks
arrow_forward
3) Complete the chart below. Use (1) for independent variable and (D) for dependent variable.
DESCRIBE/PREDICT
NAME THE TYPE
VARIABLES
OF
THE RELATIONSHIP
CORRELATION
Sample
Distance traveled_D
As time increases, the
distance travelled
POSITIVE
Time L
increases
a)
Number of Books
Total Mass
Hours Exercised
Amount of Body Fat
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
Differentiate Regrassion analysis and Correlational analysis?
arrow_forward
Please give an example of an IMPOSSIBLE correlation coefficient? Just need a simple answer
arrow_forward
Please do not give solution in image format thanku
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
- Duration is what typye of data?arrow_forwardDifferentiate between nominal data and ordinal data. Give at least two examples of nominal and ordinal data.arrow_forwardDescribe the difference between parametric statistics and non-parametric statistics. What is an example of a test for each form of statistics?arrow_forward
- Find out some examples for statistic and parameter?arrow_forwardPlease help me with this scatter plotarrow_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_forward
- please 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 find attached image for table Estimating Relationships – There are many statistical tools used to estimate relationships between variables. These include covariance, correlation, ANOVA, simple linear regression, and multiple regression. In the table below, enter a Yes (or Y) or No (or N) in each box to indicate the best response. If a box does not apply, enter NA.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