Question 1

The ________ function determines how often a set of numbers appears within a dataset.

Accepted Answer

The answer of The ________ function determines how often a...

Question 2

A ________ is a visual display of tabulated frequencies.

Accepted Answer

The answer of A ________ is a visual display of...

Question 3

If the number 0 is entered in the order argument of the RANK.AVG function the numbers will appear in ascending order.

Accepted Answer

A) True 
 B)False

Question 4

Which feature of the Analysis ToolPak is best suited to determine if samples were taken from the same population?

Accepted Answer

A) Correlation 
B) Histogram 
C) Descriptive Statistics 
D) ANOVA 
A) Correlation 
B) Histogram 
C) Descriptive Statistics 
D) ANOVA

Question 5

The ________ function can be used to perform a single condition summary.

Accepted Answer

The answer of The ________ function can be used to...

Question 6

COVARIANCE.S determines how two sets of data from a sample vary simultaneously.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following will determine the variance of a population?

Accepted Answer

A) VARA 
B) VAR.P 
C) VAR.S 
D) VARPA 
A) VARA 
B) VAR.P 
C) VAR.S 
D) VARPA

Question 8

The ________ is best suited to measure the strength of the relationship between credit score and salary.

Accepted Answer

The answer of The ________ is best suited to measure...

Question 9

Match between columns
                        Premises: STDEV.S
VARPA
VARA
FREQUENCY
CORREL

Accepted Answer

The Answer of Descriptive statistic function in Excel that determines is...

Question 10

VAR.P is included in the Analysis ToolPak.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following tools is not included in the Analysis ToolPak?

Accepted Answer

A) Anova: Single Factor 
B) Correlation 
C) Rank Average 
D) Covariance 
A) Anova: Single Factor 
B) Correlation 
C) Rank Average 
D) Covariance

Question 12

Which function is best suited to determine how the data set is spread around the mean?

Accepted Answer

A) COVARIANCE 
B) CORREL 
C) STDEV.P 
D) VARA 
A) COVARIANCE 
B) CORREL 
C) STDEV.P 
D) VARA

Question 13

VARPA calculates the variance of a population including logical values and text.

Accepted Answer

A) True 
 B)False

Question 14

The PERCENTRANK.INC function excludes 0 and 1.

Accepted Answer

A) True 
 B)False

Question 15

The .EXC descriptor in PERCENTRANK.EXC stands for:

Accepted Answer

A) inclusive. 
B) increment. 
C) expert. 
D) exclusive. 
A) inclusive. 
B) increment. 
C) expert. 
D) exclusive.

Question 16

When using the QUARTILE.INC function which quartile would include the lowest value in the dataset?

Accepted Answer

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

Question 17

Which of the following is not a statistical function?

Accepted Answer

A) AVERAGEIF 
B) MAX 
C) COUNTIFS 
D) DSUM 
A) AVERAGEIF 
B) MAX 
C) COUNTIFS 
D) DSUM

Question 18

When active,where does the Analysis ToolPak appear?

Accepted Answer

A) Data tab 
B) Formulas tab 
C) View tab 
D) Insert tab 
A) Data tab 
B) Formulas tab 
C) View tab 
D) Insert tab

Question 19

STDEV.P should be used to calculate standard deviation when all data for a population is present.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following is a new statistical function in Excel 2013?

Accepted Answer

A) Skew.P 
B) STDEV.P 
C) VARPA 
D) CORREL 
A) Skew.P 
B) STDEV.P 
C) VARPA 
D) CORREL

Exam 29: Statistical Functions

The ________ function determines how often a set of numbers appears within a dataset.

A ________ is a visual display of tabulated frequencies.

If the number 0 is entered in the order argument of the RANK.AVG function the numbers will appear in ascending order.

Which feature of the Analysis ToolPak is best suited to determine if samples were taken from the same population?

The ________ function can be used to perform a single condition summary.

COVARIANCE.S determines how two sets of data from a sample vary simultaneously.

Which of the following will determine the variance of a population?

The ________ is best suited to measure the strength of the relationship between credit score and salary.

VAR.P is included in the Analysis ToolPak.

Which of the following tools is not included in the Analysis ToolPak?

Which function is best suited to determine how the data set is spread around the mean?

VARPA calculates the variance of a population including logical values and text.

The PERCENTRANK.INC function excludes 0 and 1.

The .EXC descriptor in PERCENTRANK.EXC stands for:

When using the QUARTILE.INC function which quartile would include the lowest value in the dataset?

Which of the following is not a statistical function?

When active,where does the Analysis ToolPak appear?

STDEV.P should be used to calculate standard deviation when all data for a population is present.

Which of the following is a new statistical function in Excel 2013?

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