Question 1

Which of the following is not a function for measuring central tendency?

Accepted Answer

A) CORREL 
B) STDEV.P 
C) VAR.P 
D) SUMIFS 
A) CORREL 
B) STDEV.P 
C) VAR.P 
D) SUMIFS

Question 2

Identify the statistical function used if the rank value returned for duplicate values was 8.5?

Accepted Answer

A) RANK.AVG 
B) RANK.EQ 
C) RANK.SP 
D) RANK 
A) RANK.AVG 
B) RANK.EQ 
C) RANK.SP 
D) RANK

Question 3

Which of the following functions does not base its calculations on data samples?

Accepted Answer

A) STDEV.S 
B) VARPA 
C) VAR.S 
D) STDEVA 
A) STDEV.S 
B) VARPA 
C) VAR.S 
D) STDEVA

Question 4

________ calculates the variance of a sample.

Accepted Answer

The answer of ________ calculates the variance of a sample....

Question 5

The ________ is an Excel add-in that offers powerful tools for statistical analysis.

Accepted Answer

The answer of The ________ is an Excel add-in that...

Question 6

Match between columns
                        Premises: Variance
Population
STDEV.P
Standard deviation
Sample

Accepted Answer

The Answer of A measure of a dataset's dispersion,such as is...

Question 7

How many condition arguments can be defined with the SUMIF function?

Accepted Answer

A) 1 
B) 2 
C) 3 
D) unlimited 
A) 1 
B) 2 
C) 3 
D) unlimited

Question 8

What are the benefits of using the Analysis ToolPakover traditional statistical functions in Excel?

Accepted Answer

Many of the calculations that are incorp

Question 9

A smaller more manageable portion of the population is called a ________.

Accepted Answer

The answer of A smaller more manageable portion of the...

Question 10

The PERCENTILE.EXC function is the best function to calculate the 25th percentile within a range of values.

Accepted Answer

A) True 
 B)False

Question 11

When created using the Analysis ToolPak,histograms cannot be deleted.

Accepted Answer

A) True 
 B)False

Question 12

Match between columns
                        Premises: PHI
Gamma
Skew.P
Gauss
Binom.dist.range

Accepted Answer

The Answer of Returns 0.5 less than the standard normal is...

Question 13

The ________ is the range of cells that contain the values that are being evaluated for frequency of occurrence when using the FREQUENCY function.

Accepted Answer

The answer of The ________ is the range of cells...

Question 14

A CORREL value of .9 has a strong positive relationship.

Accepted Answer

A) True 
 B)False

Question 15

The FREQUENCY function can count words.

Accepted Answer

A) True 
 B)False

Question 16

Which function would be best used to determine the rank of each student in a graduating high school class?

Accepted Answer

A) RANK.EQ 
B) RANK.AVG 
C) QUARTILE.EXC 
D) QUARTILE.INC 
A) RANK.EQ 
B) RANK.AVG 
C) QUARTILE.EXC 
D) QUARTILE.INC

Question 17

Which of the following functions will rank two values evenly if there is a duplicate value present?

Accepted Answer

A) RANK.EQ 
B) RANK.AVG 
C) RANK 
D) PERCENTILE 
A) RANK.EQ 
B) RANK.AVG 
C) RANK 
D) PERCENTILE

Question 18

Which of the following functions will determine the standard deviation of a sample?

Accepted Answer

A) STDEV.P 
B) STDEV.S 
C) STDEVA 
D) VARA 
A) STDEV.P 
B) STDEV.S 
C) STDEVA 
D) VARA

Question 19

What is the difference between COVARIANCE and ANOVA?

Accepted Answer

COVARIANCE is a statistical function tha

Question 20

What does the order argument of the RANK.EQ function define?

Accepted Answer

A) The lowest ranked value 
B) The ranking stop value 
C) The order in which numbers are ranked 
D) The ranking order scale 
A) The lowest ranked value 
B) The ranking stop value 
C) The order in which numbers are ranked 
D) The ranking order scale

Exam 29: Statistical Functions

Which of the following is not a function for measuring central tendency?

Identify the statistical function used if the rank value returned for duplicate values was 8.5?

Which of the following functions does not base its calculations on data samples?

________ calculates the variance of a sample.

The ________ is an Excel add-in that offers powerful tools for statistical analysis.

How many condition arguments can be defined with the SUMIF function?

What are the benefits of using the Analysis ToolPakover traditional statistical functions in Excel?

A smaller more manageable portion of the population is called a ________.

The PERCENTILE.EXC function is the best function to calculate the 25th percentile within a range of values.

When created using the Analysis ToolPak,histograms cannot be deleted.

The ________ is the range of cells that contain the values that are being evaluated for frequency of occurrence when using the FREQUENCY function.

A CORREL value of .9 has a strong positive relationship.

The FREQUENCY function can count words.

Which function would be best used to determine the rank of each student in a graduating high school class?

Which of the following functions will rank two values evenly if there is a duplicate value present?

Which of the following functions will determine the standard deviation of a sample?

What is the difference between COVARIANCE and ANOVA?

What does the order argument of the RANK.EQ function define?

Subtotals, Pivot-tables, and Pivot-charts: Hands-On-Exercise Videos

Desktop Publishing and Graphic Design: Hands On Exercise Videos

Desktop Publishing and Graphic Design: Creating a Newsletter working With Graphics and Linking Objects

Infographics: Creating Text Charts, tables, and Graphs

Subtotals Pivot-tables and Pivot-charts

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Infographics: Hands On Exercise Videos

Data Validation and Data Analysis: Hands On Exercise Videos

What If Analysis: Hands On Exercise Videos

Time Saving Tools: Hands On Exercise Videos

Time Saving Tools: Using Templates multiple Documents and Themes

Interactivity and Advanced Animation: Engaging the Audience

What If Analysis

Action and Specialized Queries: Moving Beyond the Select Query

Interactivity and Advanced Animation: Hands On Exercise Videos

Action and Specialized Queries: Hands On Exercise Videos

Specialized Functions: Hands On Exercise Videos

Document Automation: Hands On Exercise Videos

Document Automation: Forms, macros, and Security

Customization: Customizing Powerpoint and the Slide Show

Specialized Functions

Advanced Forms and Reports: Moving Beyond the Basics

Customization: Hands On Exercise Videos

Advanced Forms and Reports: Hands On Exercise Videos

Statistical Functions: Hands On Exercise Videos

Word and the Internet: Hands On Exercise Videos

Word and the Internet: Web Page Creation and Enhancement and Blogs

Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Get Connected: Exchanging Data Between Access and Other Applications

Collaboration and Distribution: Hands On Exercise Videos

Get Connected: Hands On Exercise Videos

Multiple Sheet Workbook Management: Hands On Exercise Videos

Multiple Sheet Workbook Management

Fine Tuning the Database: Analyzing and Improving Database Performance

Fine Tuning the Database: Hands On Exercise Videos

Imports, web Queries, and XML: Hands-On-Exercise Videos

Imports, web Queries, and XML

Using Macros and SQL in Access: Advanced Techniques

Using Macros and SQL in Access: Hands On Exercise Videos

Collaboration and Workbook Distribution: Hands On Exercise Videos

Collaboration and Workbook Distribution

Templates styles and Macros

Templates, styles, and Macros: Hands-On-Exercise Videos

Filters