Question 1

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 2

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 3

What is the difference between calculating standard deviation of a population versus a sample?

Accepted Answer

When calculating standard deviation the

Question 4

The FREQUENCY function can count words.

Accepted Answer

A) True 
 B)False

Question 5

By default the Analysis ToolPak is active.

Accepted Answer

A) True 
 B)False

Question 6

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 7

Which of the following percentiles is excluded when using the PERCENTILE.EXC function?

Accepted Answer

A) 0 
B) 25th 
C) 50th 
D) 75th 
A) 0 
B) 25th 
C) 50th 
D) 75th

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

The ________ is the square root of the variance.

Accepted Answer

The answer of The ________ is the square root of...

Question 11

The ________ tool within the Analysis ToolPak can place its output on a blank worksheet.

Accepted Answer

The answer of The ________ tool within the Analysis ToolPak...

Question 12

When using the QUARTILE.INC function the 4th quartile would include the highest number value.

Accepted Answer

A) True 
 B)False

Question 13

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 14

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

Accepted Answer

The Answer of Helps determine the strength of a relationship is...

Question 15

Histogram is a tool of the Analysis ToolPak.

Accepted Answer

A) True 
 B)False

Question 16

When using the CORREL function a value of 1 would indicate:

Accepted Answer

A) a weak relationship. 
B) a mild relationship. 
C) a strong relationship. 
D) no relationship. 
A) a weak relationship. 
B) a mild relationship. 
C) a strong relationship. 
D) no relationship.

Question 17

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 18

Match between columns
                        Premises: PERCENTRANK.INC
PERCENTRANK.EXC
QUARTILE.INC
RANK.EQ
RANK.AVG

Accepted Answer

The Answer of Identifies the rank of a value but is...

Question 19

The QUARTILE.EXC function excludes quartiles 0 and 4.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following functions is best suited to determine the standard deviation of a sample including logical values and text?

Accepted Answer

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

Exam 25: Excel: Statistical Functions

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

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

What is the difference between calculating standard deviation of a population versus a sample?

The FREQUENCY function can count words.

By default the Analysis ToolPak is active.

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

Which of the following percentiles is excluded when using the PERCENTILE.EXC function?

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

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

The ________ is the square root of the variance.

The ________ tool within the Analysis ToolPak can place its output on a blank worksheet.

When using the QUARTILE.INC function the 4th quartile would include the highest number value.

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

Histogram is a tool of the Analysis ToolPak.

When using the CORREL function a value of 1 would indicate:

The .EXC descriptor in PERCENTRANK.EXC stands for:

The QUARTILE.EXC function excludes quartiles 0 and 4.

Which of the following functions is best suited to determine the standard deviation of a sample including logical values and text?

Office Fundamentals and File Management

Word: Document Presentation: Editing and Formatting

Word: Document Productivity: Working With Tables and Mail Merge

Word: Collaboration and Research: Communicating and Producing Professional Papers

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

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

Word: Document Automation: Forms,macros,and Security

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

Power: Introduction to Powerpoint: Creating a Basic Presentation

Power: Presentation Development: Planning and Preparing a Presentation

Power: Presentation Design: Illustrations and Infographics

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

Power: Infographics: Creating Text Charts, tables, and Graphs

Power: Interactivity and Advanced Animation: Engaging the Audience

Power: Customization: Customizing Powerpoint and the Slide Show

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

Excel: Introduction to Excel: What Is a Spreadsheet

Excel: Formulas and Functions: Performing Quantitative Analysis

Excel : Charts: Depicting Data Visually

Excel: Datasets and Tables: Managing Large Volumes of Data

Excel: Subtotals, Pivot-tables, and Pivot-charts

Excel : What-If Analysis

Excel: Specialized Functions

Excel : Multiple-Sheet Workbook Management

Excel: Imports, web Queries, and Xml

Excel : Collaboration and Workbook Distribution

Excel: Templates, styles, and Macros

Access : Introduction to Access: Finding Your Way Through an Access Database

Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Access: Customize,analyze,and Summarize Query Data: Creating and Using Queries to Make Decisions

Access: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

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

Access : Action and Specialized Queries: Moving Beyond the Select Query

Access: Advanced Forms and Reports: Moving Beyond the Basics

Access: Get Connected: Exchanging Data Between Access and Other Applications

Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

Filters