Question 1

Explain the steps in creating a function that would add the data in a range of cells?

Accepted Answer

Enter the function in the cell where you want the results to appear, enter the range of cells on which you want the function to operate, and press the Enter key.

Question 2

What is a function?

Accepted Answer

A function is a predefined formula.

Question 3

Which of the following would be used to describe the type of statistical methods used to make inferences about the population based on a sample?

Accepted Answer

A)  Inferential statistics 
B)  Descriptive statistics 
C)  Sampling methods 
D)  Population methods 
A)  Inferential statistics 
B)  Descriptive statistics 
C)  Sampling methods 
D)  Population methods A

Question 4

In Excel, what is a collection of cells called?

Accepted Answer

A)  average 
B)  sum 
C)  range 
D)  mean 
A)  average 
B)  sum 
C)  range 
D)  mean

Question 5

What is a mathematical operator used to perform a mathematical task called?

Accepted Answer

A)  function 
B)  formula 
C)  average 
D)  range 
A)  function 
B)  formula 
C)  average 
D)  range

Question 6

How can a course in statistics make you a better student in the sciences?

Accepted Answer

Having some background in statistics mak

Question 7

Which of the following would be considered a formula?

Accepted Answer

A)  SUM(A1:A3) 
B)  AVERAGE(A1:A9) 
C)  SUM(3,4) 
D)  2+5 
A)  SUM(A1:A3) 
B)  AVERAGE(A1:A9) 
C)  SUM(3,4) 
D)  2+5

Question 8

Every formula contains the name of the function and the function's what?

Accepted Answer

A)  operator 
B)  argument 
C)  average 
D)  population 
A)  operator 
B)  argument 
C)  average 
D)  population

Question 9

What is a formula?

Accepted Answer

A formula is a set o

Question 10

Most of the basic statistical procedures were first developed and used in agriculture and which of the following fields?

Accepted Answer

A)  biology 
B)  botany 
C)  astronomy 
D)  geology 
A)  biology 
B)  botany 
C)  astronomy 
D)  geology

Question 11

Where will the results of the formula appear when you hit the Enter key?

Accepted Answer

A)  in the selected cell 
B)  in the formula bar 
C)  in the toolpak 
D)  in the operator 
A)  in the selected cell 
B)  in the formula bar 
C)  in the toolpak 
D)  in the operator

Question 12

Which of the following would be used to describe the type of statistical methods used to organize and describe the characteristics of a collection of data?

Accepted Answer

A)  Inferential statistics 
B)  Descriptive statistics 
C)  Sampling methods 
D)  Population methods 
A)  Inferential statistics 
B)  Descriptive statistics 
C)  Sampling methods 
D)  Population methods

Question 13

Which of the following formulas will add each of the scores together and divide the sum by 3?

Accepted Answer

A)  x + y + z/3 
B)  x + y + (z)/3 
C)  (x + y + z)/3 
D)  x + y + z:3 
A)  x + y + z/3 
B)  x + y + (z)/3 
C)  (x + y + z)/3 
D)  x + y + z:3

Question 14

When might a person use inferential statistics?

Accepted Answer

Inferential statistics are use

Question 15

What function would you enter to find the average of the data in cells A1 through A10?

Accepted Answer

To find the average

Question 16

What symbol is used for representing the mathematical operator "multiplication" when using Excel?

Accepted Answer

A)  = 
B)  * 
C)  / 
D)  - 
A)  = 
B)  * 
C)  / 
D)  -

Question 17

When might a person use descriptive statistics?

Accepted Answer

Descriptive statisti

Question 18

What is a sample?

Accepted Answer

A sample is a smaller subset o

Question 19

According to the text, statistical procedures were first developed in what field of study?

Accepted Answer

Statistical procedur

Question 20

What was the first ever Excel-like computer application called?

Accepted Answer

A)  Visicalc 
B)  Calcgraph 
C)  Excel-graph 
D)  Excelcalc 
A)  Visicalc 
B)  Calcgraph 
C)  Excel-graph 
D)  Excelcalc

Explain the steps in creating a function that would add the data in a range of cells?

What is a function?

Which of the following would be used to describe the type of statistical methods used to make inferences about the population based on a sample?

In Excel, what is a collection of cells called?

What is a mathematical operator used to perform a mathematical task called?

How can a course in statistics make you a better student in the sciences?

Which of the following would be considered a formula?

Every formula contains the name of the function and the function's what?

What is a formula?

Most of the basic statistical procedures were first developed and used in agriculture and which of the following fields?

Where will the results of the formula appear when you hit the Enter key?

Which of the following would be used to describe the type of statistical methods used to organize and describe the characteristics of a collection of data?

Which of the following formulas will add each of the scores together and divide the sum by 3?

When might a person use inferential statistics?

What function would you enter to find the average of the data in cells A1 through A10?

What symbol is used for representing the mathematical operator "multiplication" when using Excel?

When might a person use descriptive statistics?

What is a sample?

According to the text, statistical procedures were first developed in what field of study?

What was the first ever Excel-like computer application called?

Means to an End: Computing and Understanding Averages

Vive La Différence: Understanding Variability

A Picture Really Is Worth a Thousand Words

Ice Cream and Crime: Computing Correlation Coefficients

Just the Truth: An Introduction to Understanding Reliability and Validity

Hypotheticals and You: Testing Your Questions

Are Your Curves Normal? Probability and Why It Counts

Significantly Significant: What It Means for You and Me

Only the Lonely

t(ea) for Two (Again): Tests Between the Means of Related Groups

t(ea) for Two (Again): Tests Between the Means of Related Groups

Two Groups Too Many? Try Analysis of Variance

Two Too Many Factors: Factorial Analysis of Variance

Cousins or Just Good Friends? Testing Relationships Using the Correlation Coefficient

Predicting Who’ll Win the Super Bowl: Using Linear Regression

What to Do When You’re Not Normal: Chi-Square and Some Other Nonparametric Tests

Some Other (Important) Statistical Procedures You Should Know About

Filters

Exam 1: Statistics or Sadistics? It’s Up to You

Explain the steps in creating a function that would add the data in a range of cells?

What is a function?

Which of the following would be used to describe the type of statistical methods used to make inferences about the population based on a sample?

In Excel, what is a collection of cells called?

What is a mathematical operator used to perform a mathematical task called?

How can a course in statistics make you a better student in the sciences?

Which of the following would be considered a formula?

Every formula contains the name of the function and the function's what?

What is a formula?

Most of the basic statistical procedures were first developed and used in agriculture and which of the following fields?

Where will the results of the formula appear when you hit the Enter key?

Which of the following would be used to describe the type of statistical methods used to organize and describe the characteristics of a collection of data?

Which of the following formulas will add each of the scores together and divide the sum by 3?

When might a person use inferential statistics?

What function would you enter to find the average of the data in cells A1 through A10?

What symbol is used for representing the mathematical operator "multiplication" when using Excel?

When might a person use descriptive statistics?

What is a sample?

According to the text, statistical procedures were first developed in what field of study?

What was the first ever Excel-like computer application called?

Means to an End: Computing and Understanding Averages

Vive La Différence: Understanding Variability

A Picture Really Is Worth a Thousand Words

Ice Cream and Crime: Computing Correlation Coefficients

Just the Truth: An Introduction to Understanding Reliability and Validity

Hypotheticals and You: Testing Your Questions

Are Your Curves Normal? Probability and Why It Counts

Significantly Significant: What It Means for You and Me

Only the Lonely

t(ea) for Two (Again): Tests Between the Means of Related Groups

t(ea) for Two (Again): Tests Between the Means of Related Groups

Two Groups Too Many? Try Analysis of Variance

Two Too Many Factors: Factorial Analysis of Variance

Cousins or Just Good Friends? Testing Relationships Using the Correlation Coefficient

Predicting Who’ll Win the Super Bowl: Using Linear Regression

What to Do When You’re Not Normal: Chi-Square and Some Other Nonparametric Tests

Some Other (Important) Statistical Procedures You Should Know About

Filters