Question 1

________ is a tool included in the Analysis ToolPak.

Accepted Answer

The answer of ________ is a tool included in the...

Question 2

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 3

Which of the following functions will use average values to determine the rank of a number within a list if duplicate values are present?

Accepted Answer

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

Question 4

Match between columns
                        Premises: STDEVPA
VAR.S
VAR.P
STDEVA
STDEV.P

Accepted Answer

The Answer of Standard deviation of a population including logical is...

Question 5

When using the QUARTILE.INC function a quartile of 3 represents which percentile?

Accepted Answer

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

Question 6

Match between columns
                        Premises: III.Covariance
II.Analysis ToolPak
V.Histogram
IV.Inferential statistics
I.ANOVA

Accepted Answer

The Answer of Offers 19 tools that fit a variety is...

Question 7

Which of the following functions will help determine the strength of a relationship between two variables?

Accepted Answer

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

Question 8

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 9

________ calculates the variance of a sample.

Accepted Answer

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

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

Which of the following is included in an ANOVA summary report?

Accepted Answer

A) F crit 
B) STDEV 
C) Correlation 
D) Covariance 
A) F crit 
B) STDEV 
C) Correlation 
D) Covariance

Question 13

Which of the following functions is best suited to add numbers based on one condition?

Accepted Answer

A) SUMIFS 
B) SUMIF 
C) COUNTIF 
D) COUNTIFS 
A) SUMIFS 
B) SUMIF 
C) COUNTIF 
D) COUNTIFS

Question 14

When using the RANK.AVG function the order argument determines the ________.

Accepted Answer

The answer of When using the RANK.AVG function the order...

Question 15

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 16

When using text for criteria in conditional logic functions,the text must be surrounded by double quotation marks.

Accepted Answer

A) True 
 B)False

Question 17

The PERCENTRANK.INC function excludes 0 and 1.

Accepted Answer

A) True 
 B)False

Question 18

In an ANOVA summary report,the degrees of freedom are equal to the number of data points in the sample - 1 (N - 1).

Accepted Answer

A) True 
 B)False

Question 19

The ________ function can be used to perform a multiconditional average of data.

Accepted Answer

A) AVERAGE 
B) AVERAGEIF 
C) AVERAGEIFS 
D) MU 
A) AVERAGE 
B) AVERAGEIF 
C) AVERAGEIFS 
D) MU

Question 20

STDEV.S calculates the standard deviation of a sample.

Accepted Answer

A) True 
 B)False

Exam 25: Excel: Statistical Functions

________ is a tool included in the Analysis ToolPak.

Which of the following is not a statistical function?

Which of the following functions will use average values to determine the rank of a number within a list if duplicate values are present?

When using the QUARTILE.INC function a quartile of 3 represents which percentile?

Which of the following functions will help determine the strength of a relationship between two variables?

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

________ calculates the variance of a sample.

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

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

Which of the following is included in an ANOVA summary report?

Which of the following functions is best suited to add numbers based on one condition?

When using the RANK.AVG function the order argument determines the ________.

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

When using text for criteria in conditional logic functions,the text must be surrounded by double quotation marks.

The PERCENTRANK.INC function excludes 0 and 1.

In an ANOVA summary report,the degrees of freedom are equal to the number of data points in the sample - 1 (N - 1).

The ________ function can be used to perform a multiconditional average of data.

STDEV.S calculates the standard deviation of a sample.

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