Statistics Using Excel MCQ PDF

https://quizplus.com/study-set/417
18 Chapters
532 Verified Questions
 Statistics Using Excel
MCQ PDF
Cou
Statistics Using Excel introduces the fundamental concepts of statistical analysis

through practical applications in Microsoft Excel. Students will learn to organize,

summarize, and interpret data using spreadsheets, covering topics such as descriptive

statistics, probability distributions, hypothesis testing, correlation, regression, and data

visualization. Emphasis is placed on hands-on exercises and real-world datasets,

enabling students to build proficiency in utilizing Excel tools and functions for statistical

problem-solving and effective data presentation. This course is ideal for those seeking to

improve their analytical skills while leveraging the powerful features of Excel in

academic, business, or research settings.

Recommended Textbook
Statistics for People Who Think They Hate Statistics Excel 2010 Edition 3rd Edition by Neil J. Salkin

Available Study Resources on Quizplus

18 Chapters
532 Verified Questions
532 Flashcards
Source URL: https://quizplus.com/study-set/417

Page 2
 Chapter 1: Statistics or Sadistics? It’s Up to You
Available Study Resources on Quizplus for this Chatper
30 Verified Questions
30 Flashcards
Source URL: https://quizplus.com/quiz/7308

Sample Questions
Q1) According to the text, statistical procedures were first developed in what field of
study?
Answer: Statistical procedures were first developed in the fields of agriculture,
astronomy, and politics.

Q2) What is a sample?

Answer: A sample is a smaller subset of data taken from the larger population such as
class of undergraduate students in the University.

Q3) Which of the following is an example of an Excel formula for taking the number 6 to
the power of 2?
A) =6+2
B) =6^2
C) 6+2
D) 6^2

Answer: B

Q4) What is a formula?

Answer: A formula is a set of mathematical operators that performs a specific
mathematical task.

To view all questions and flashcards with answers, click on the resource link above.

Page 3
 Chapter 2: Means to an End: Computing and

Understanding Averages
Available Study Resources on Quizplus for this Chatper
30 Verified Questions
30 Flashcards
Source URL: https://quizplus.com/quiz/7309

Sample Questions
Q1) Who was the inventor of the correlation?
A) Sigmund Freud
B) Charles Darwin
C) Francis Galton
D) Jacob Cohen

Answer: C

Q2) To identify the point in a distribution at which 50% of scores fall above and 50% fall
below a given score, which measure of central tendency would you report?
A) average
B) mean
C) mode
D) median

Answer: D

Q3) When might you want to use the moving average tool?
Answer: A moving average might be used when you have a distribution that has outliers
in order to obtain a more accurate representation.

To view all questions and flashcards with answers, click on the resource link above.
Page 4
 Chapter 3: Vive La Différence: Understanding Variability
Available Study Resources on Quizplus for this Chatper
30 Verified Questions
30 Flashcards
Source URL: https://quizplus.com/quiz/7310

Sample Questions
Q1) Write out the two Excel formulas for computing the standard deviation and the
variance.
Answer: VAR(A1:A12) STDEV(A1:A10)

Q2) What is the term associated with scores that are at the extreme ends of the
distribution?
A) variability
B) outliers
C) skew
D) percentile

Answer: B

Q3) What is the s of the following set of scores? 10, 15, 12, 18, 19, 16, 12
Answer: The standard deviation is 3.6

Q4) Explain why the standard deviation is referred to as an unbiased estimate. Why are
unbiased estimates important to researchers?
Answer: Because n - 1 is used in the denominator, we call the SD an unbiased estimate of
the population's SD. By artificially inflating the SD, researchers are conservative in their
estimate of the population SD.

To view all questions and flashcards with answers, click on the resource link above.

Page 5
 Chapter 4: A Picture Really Is Worth a Thousand Words
Available Study Resources on Quizplus for this Chatper
30 Verified Questions
30 Flashcards
Source URL: https://quizplus.com/quiz/7311

Sample Questions
Q1) If you have a distribution of 50 scores and you want 10 intervals, what should be the
size of your class interval?

Q2) When the left tail of a distribution's curve is longer than the right, what is this called?
A) Platykurtic
B) Leptokurtic
C) Positive skew
D) Negative skew

Q3) Which of the following Excel functions will allow you to examine the symmetry of a
set of scores?
A) AVERAGE(A1:A20)
B) VAR(A1:A20)
C) SKEW(A1:A20)
D) KURT(A1:A20)

Q4) Which of the following are among the things to remember when creating figures?
A) Use a lot of text
B) Graphs communicate several ideas
C) Label just the most important item
D) Maintain the scale in the graph

Q5) Name the four ways that distributions can be different from one another.

To view all questions and flashcards with Page

answers,
6 click on the resource link above.
 Chapter 5: Ice Cream and Crime: Computing Correlation

Coefficients
Available Study Resources on Quizplus for this Chatper
30 Verified Questions
30 Flashcards
Source URL: https://quizplus.com/quiz/7312

Sample Questions
Q1) If the correlation between variables is .70, what percent of the variance is not shared
variance?

Q2) If you constrain, or restrict, the range of one variable, what effect does this have on
the correlation of that variable with another variable?

Q3) If you wanted to compute the correlation between two interval-level variables, which
type of correlation should you use?
A) Point biserial
B) Phi
C) Spearman rank
D) Pearson

Q4) If the coefficient of determination between two variables is .81, what is the Pearson
correlation coefficient?
A) .19
B) .34
C) .66
D) .90

Q5) What does a correlation coefficient represent?

Q6) Write the formula for the Pearson product-moment

Page 7 correlation coefficient.

To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Just the Truth: An Introduction to Understanding

Reliability and Validity

Available Study Resources on Quizplus for this Chatper
30 Verified Questions
30 Flashcards
Source URL: https://quizplus.com/quiz/7313

Sample Questions
Q1) How does interrater reliability measure consistency?
A) Over time
B) From form to form
C) Across different tests
D) From rater to rater

Q2) If you correlate scores from your test with some other valid measure that assesses
the same set of abilities, what type of validity evidence are you collecting?
A) Criterion validity
B) Content validity
C) Construct validity
D) Internal consistency

Q3) How does error affect reliability? Write the general equation for reliability that
demonstrates this concept.

Q4) Which of the following is concerned with monitoring estimates of present

performance and predictions of future performance?
A) Content validity
B) Criterion validity
C) Internal validity
D) Construct validity
Page 8

To view all questions and flashcards with answers, click on the resource link above.
 Chapter 7: Hypotheticals and You: Testing Your Questions
Available Study Resources on Quizplus for this Chatper
30 Verified Questions
30 Flashcards
Source URL: https://quizplus.com/quiz/7314

Sample Questions
Q1) Which of the following symbols represents the first research hypothesis?
A) \(H _ { 1 }\)
B) \(\mu 1\)
C) \(\bar { X } 1\)
D) \(H _ { 0 }\)

Q2) Which of the following provides a measure of how well your sample approximates
the population?
A) Generalizability
B) Population
C) Sampling error
D) Hypothesis

Q3) What test would you want to use to test a directional research hypothesis?
A) One-tailed test
B) Two-tailed test
C) Nonparametric test
D) Frequency test

Q4) What is the sampling error? What does a high sampling error indicate?

Q5) Using the symbols from the text, write a directional research hypothesis equation
where 9th graders are hypothesized to score better 12th graders.

To view all questions and flashcards with Page

answers,
9 click on the resource link above.
Chapter 8: Are Your Curves Normal? Probability and Why It

Counts
Available Study Resources on Quizplus for this Chatper
30 Verified Questions
30 Flashcards
Source URL: https://quizplus.com/quiz/7315

Sample Questions
Q1) What are the characteristics associated with the normal curve?

Q2) The study of probability is the basis for the normal curve and the foundation for what
type of statistics?

Q3) Approximately what percent of scores fall between the mean and -1 to +1 standard
deviations under the normal curve?
A) 34%
B) 14%
C) 68%
D) 95%

Q4) What percent of all scores fall above a z score of +1?

A) 16%
B) 34%
C) 50%
D) 84%

Q5) If the z score is -.5 in a distribution with a mean of 50 and a standard deviation of 5,
what is the raw score?

Q6) How many standard deviations are included in a normal distribution with a mean of
100 and a standard deviation of 10? Page 10

Q7) What do standard scores allow researchers to do that raw scores cannot?

To view all questions and flashcards with answers, click on the resource link above.
 Chapter 9: Significantly Significant: What It Means for You

and Me
Available Study Resources on Quizplus for this Chatper
30 Verified Questions
30 Flashcards
Source URL: https://quizplus.com/quiz/7316

Sample Questions
Q1) What are the Greek letters associated with Type I and Type II error?

Q2) If you conclude that your findings yield a 1-in-100 chance that differences were not
due to the hypothesized reason, what is the corresponding p value?

Q3) Complete the following table:

\[\begin{array} { l | | c | c }
\hline & \text { "ru!l! True } & \text { "ruul!" False } \\
\hline \hline \text { Reject "rru!l!" } & & \\
\hline \text { Retain "ruLl!" } & & \\
\hline
\end{array}\]

Q4) What Greek letter is associated with Type II error?

A) \(\alpha\)
B) \(\beta\)
C) \(\Sigma\)
D) \(\eta\)

Q5) What does 1 - ? represent?

A) Alpha level
B) Type I error
C) Type II error Page 11

D) Power

To view all questions and flashcards with answers, click on the resource link above.
 Chapter 10: Only the Lonely
Available Study Resources on Quizplus for this Chatper
30 Verified Questions
30 Flashcards
Source URL: https://quizplus.com/quiz/7317

Sample Questions
Q1) You have a sample of 45 male teens ages 15-19 have with a mean height of 70.8
inches and assume you have a ? = 1.5 inches. What is the equation that will determine
the standard error of the mean?

Q2) Excel can apply the Z tests to data arranged in rows or in columns, but the statistical
packages present the results typically by.
A) Rows
B) Columns

Q3) If you have designed a 99% confidence interval to estimate the population average
(?) with a known standard deviation for the populationstandard deviation for the
populationstandard deviation for the population (?), what is supposed to be the correct
critical values range for z?

Q4) The observed sample mean?

A) Array
B) Mean score
C) Sigma
D) Mu

Q5) A test is conducted for H?: ? = 20, with ? = 4. A sample of size 36 has \(\bar { X }\) =
21.4. Calculate the Z Test.

To view all questions and flashcards with answers, click on the resource link above.

Page 12
Chapter 11: t(ea) for Two (Again): Tests Between the Means

of Related Groups
Available Study Resources on Quizplus for this Chatper
30 Verified Questions
30 Flashcards
Source URL: https://quizplus.com/quiz/7318

Sample Questions
Q1) Which of the following relates to the difference you expect?
A) Hypothesized mean difference
B) Pearson correlation
C) Observations
D) Variance

Q2) In the formula that computes a t value, what does n?D represent?
A) Sum of the difference between groups
B) Sum of the means for Group 1
C) Sum of the means for Group 2
D) Sum of the differences squared

Q3) What is the test statistic calculated by the statistical procedure selected known as?
A) Critical value
B) Significance level
C) Obtained value
D) p value

Q4) What is another term that statisticians use when talking of dependent tests? Explain.

Q5) What does t stat represent?

Q6) What is the formula for calculating aPage

t value
13 for a dependent samples test?

To view all questions and flashcards with answers, click on the resource link above.
Chapter 12: t(ea) for Two (Again): Tests Between the Means

of Related Groups
Available Study Resources on Quizplus for this Chatper
30 Verified Questions
30 Flashcards
Source URL: https://quizplus.com/quiz/7319

Sample Questions
Q1) When using the Amazing Analysis ToolPak to compute t value for dependent
samples, which test should you select?

Q2) To compute the test statistic or t value you must first approximate the sample size
through calculating the?
A) Pooled variance
B) Standard deviation
C) Degrees of freedom
D) Mean score

Q3) Given the following, what should you conclude? t???? = 2.001 and tc??t?c?l = 1.94

Q4) If the obtained value is greater than the critical value, what should you do?
A) Reject the null hypothesis
B) Accept the null hypothesis
C) Set a higher p value
D) Increase your sample

Q5) If the obtained value is less than the critical value, what should you do?
A) Reject the null hypothesis
B) Accept the null hypothesis
C) Reduce the p value
D) Decrease your sample Page 14

To view all questions and flashcards with answers, click on the resource link above.
Chapter 13: Two Groups Too Many? Try Analysis of Variance
Available Study Resources on Quizplus for this Chatper
30 Verified Questions
30 Flashcards
Source URL: https://quizplus.com/quiz/7320

Sample Questions
Q1) Which of the following is the same as t² when examining the difference between two
groups?
A) F
B) t
C) Cohen's d
D) F²

Q2) If the total sample size was 50 and three groups were examined, what is the
within-groups degrees of freedom?

Q3) What is the sum of squares total?

Q4) When is analysis of variance the appropriate statistical procedure to use?

Q5) What is the MS within value?

Q6) If you wanted to examine whether the level of parental involvement differs based on
students' grade in school (i.e., 1st, 2nd, 3rd, etc.), what is the independent variable of
interest?
A) Grade level
B) Students
C) Parents
D) Level of parent involvement

Q7) What is the F value?

Page 15

Q8) How are the F statistic and t statistic related?

To view all questions and flashcards with answers, click on the resource link above.
 Chapter 14: Two Too Many Factors: Factorial Analysis of

Variance
Available Study Resources on Quizplus for this Chatper
30 Verified Questions
30 Flashcards
Source URL: https://quizplus.com/quiz/7321

Sample Questions
Q1) When you are interested in finding out if students' achievement level changes over
time as a result of a reading intervention, what type of ANOVA would you use?
A) Repeated measures
B) Between-group design
C) Mixed design
D) One-way ANOVA

Q2) What is the appropriate test statistic given the following situation? You are testing for
differences between scores of the same participants; the participants are being tested
more than once; you are dealing with two or more groups; and you are dealing with
more than one factor or independent variable.

Q3) What does a factorial 3 × 2 design represent? Give an example.

Q4) Which of the following would be an example of a design that examines the effects of
gender and school type (i.e., elementary, middle, high school) on a scale of student
attitudes toward learning?
A) Simple ANOVA
B) One-way ANOVA
C) 2 × 3 ANOVA
D) 3 × 3 ANOVA

To view all questions and flashcards withPage 16 click on the resource link above.
answers,
 Chapter 15: Cousins or Just Good Friends? Testing

Relationships Using the Correlation Coefficient

Available Study Resources on Quizplus for this Chatper
32 Verified Questions
32 Flashcards
Source URL: https://quizplus.com/quiz/7322

Sample Questions
Q1) Which of the following is an example of a null hypothesis for testing a correlation
coefficient?
A) \(H _ { 1 : } \rho _ { x v } \neq 0\)
B) \(H _ { 1 : } : \rho _ { x w } = 0\)
C) \(H _ { 0 } : \rho _ { x v } = 0\)
D) \(H _ { 0 } : \rho _ { x w } \neq 0\)

Q2) Which of the following Excel functions calculates a correlation coefficient similar to
the CORREL function?
A) PEARSON
B) PHI
C) POINT-BISERIAL
D) BISERIAL

Q3) Measures that occur over a period of time are known as?
A) Predictive measures
B) Longitudinal measures
C) Concurrent measures
D) Consecutive measures

Q4) What two test statistics can be used to test the significance of a correlation
coefficient?
Page 17

Q5) What does a correlation coefficient represent?

To view all questions and flashcards with answers, click on the resource link above.
 Chapter 16: Predicting Who’ll Win the Super Bowl: Using

Linear Regression
Available Study Resources on Quizplus for this Chatper
30 Verified Questions
30 Flashcards
Source URL: https://quizplus.com/quiz/7323

Sample Questions
Q1) What is the distance between each data point and the regression line called?
A) Error of estimate
B) Standard error of estimate
C) Standard deviation
D) Standardized error

Q2) What must be used to examine an outcome that is predicted from two independent
variables?

Q3) What can be used as the basis for prediction?

A) t test
B) Correlation
C) F test
D) Cohen's d

Q4) What is another name for a regression line?

A) Line of best fit
B) Scatterplot line
C) Line graph
D) Line of the estimate

Q5) Write the equation for linear regression. What do the symbols represent?
Page 18
Q6) In order to use two predictor variables, what must be the case concerning the
variables?

To view all questions and flashcards with answers, click on the resource link above.
 Chapter 17: What to Do When You’re Not Normal:

Chi-Square and Some Other Nonparametric Tests

Available Study Resources on Quizplus for this Chatper
30 Verified Questions
30 Flashcards
Source URL: https://quizplus.com/quiz/7324

Sample Questions
Q1) What is the level of risk associated with the null hypothesis called?
A) Type II error
B) Type III error
C) Power
D) Type I error

Q2) What is a two-sample chi-square test also known as?

A) Goodness of fit test
B) Test of independence
C) Wilcoxon rank
D) Mann-Whitney

Q3) How is a nonparametric test different from a parametric test?

Q4) Which of the following nonparametric tests is used to examine the correlation
between ranks?
A) Mann-Whitney
B) Wilcoxon rank
C) Spearman rank
D) Fisher's exact

Q5) What does the CHIDIST function in Excel compute?

Page 19
Q6) Why is "goodness of fit" a commonly used name for the one-sample chi-square
test?

To view all questions and flashcards with answers, click on the resource link above.
Chapter 18: Some Other (Important) Statistical Procedures

You Should Know About

Available Study Resources on Quizplus for this Chatper
20 Verified Questions
20 Flashcards
Source URL: https://quizplus.com/quiz/7325

Sample Questions
Q1) Which of the following allows you to equalize initial differences between groups?
A) analysis of variance
B) analysis of covariance
C) structural equation modeling
D) factor analysis

Q2) Which ANOVA uses more than one dependent variable?

A) repeated measures
B) path analysis
C) covariance
D) multivariate

Q3) What type of analysis examines the direction of relationships through the
postulation of some theoretical relationship between variables and then uses a test to
see if the direction of these relationships is substantiated by the data?
A) data mining
B) repeated measures
C) path analysis
D) factor analysis

To view all questions and flashcards with answers, click on the resource link above.

Page 20