HomeworkLib
Question

Which of the following Excel procedures generates correct frequency distributions for quantitative (numeric) data? Procedure 1:...

Which of the following Excel procedures generates correct frequency distributions for quantitative (numeric) data?
Procedure 1: based on function Frequency().
Procedure 2: based on function CountIf().
Procedure 3: based on command Insert > PivotTable.
Explain why or why not.

math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Correct option:

Procedure 1: based on function Frequency().

Explanation:

Syntax:

FREQUENCY(data_array,bins_array)

where

data_array = array of values for getting frequency

bin_array = array of intervals

Function Countf() is to count the cells that meet a single criterion

Function Insert > PivotTable. will create a Pivot Table on a new sheet

0 0
Add a comment
Know the answer?
Add Answer to:
Which of the following Excel procedures generates correct frequency distributions for quantitative (numeric) data? Procedure 1:...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • 1) Excel's _____________ can be used to construct a frequency distribution for quantitative data. a) COUNTIF...

    1) Excel's _____________ can be used to construct a frequency distribution for quantitative data. a) COUNTIF function b) AVERAGE function c) FREQUENCEY function d) none of these answers is correct e) SUM function 2) Excel's ______________ can be used to construct a frequency distribution for qualitative data. a) Pivot Table report b) COUNTIF function C) chart wizard d) SUM function e) none of these answers is correct 3) The relative frequency of a class is computed by a) None of...

  • Create a Categorical Frequency Table and Grouped Frequency Distribution table in Excel using the above data...

    Create a Categorical Frequency Table and Grouped Frequency Distribution table in Excel using the above data Example 2-1 Distribution of Blood Types Twenty-five army inductees were given a blood test to determine their blood type. The data set i:s ВВАВ B AO О O A AB B Construct a frequency distribution for the data Categorical Frequency Table (Qualitative or Discrete Data) 1. In an open workbook select cell A1 and type in all the blood types from Example 2-1 down...

  • Oracle 12c Regarding the INSERT statement, which of the following is correct? Non-numeric data is enclosed...

    Oracle 12c Regarding the INSERT statement, which of the following is correct? Non-numeric data is enclosed in single quotation marks. Column names are enclosed in parentheses ( ). The data values to be inserted are enclosed in parentheses ( ) after the VALUES keyword. all of the above I answered "all of the above".

  • Frequency distributions can be formed from which of the following types of data? Both discrete and...

    Frequency distributions can be formed from which of the following types of data? Both discrete and continuous Discrete only Continuous only Only qualitative data

  • Regarding the informal bankruptcy procedures, which of the following is NOT correct? A. Reorganization plans usually...

    Regarding the informal bankruptcy procedures, which of the following is NOT correct? A. Reorganization plans usually require some type of restructuring of the firm's debts; this may involve an extension, which postpones the date of required payment of past-due obligations. B. Reorganization may involve a composition, by which the creditors voluntarily reduce their claims on the debtor or the interest rate on their claims. C. Informal bankruptcy procedures are usually less costly than the formal bankruptcy procedures. This could be...

  • 23. Find the following regarding excel functions: a. A new surgical procedure is said to be...

    23. Find the following regarding excel functions: a. A new surgical procedure is said to be successful 90% of the time. Suppose the procedure is performed five times. Assume that the results of each procedure are independent of one another. In this binomial distribution application, which Excel statement will find the probability of exactly 2 successful surgical procedures? =BINOMDIST(2,5,90%,TRUE) =BINOMDIST(2,5,90%,FALSE) =1-BINOMDIST(2,5,90%,TRUE) =1-BINOMDIST(2,5,90%,FALSE) b. A new surgical procedure is said to be successful 90% of the time. Suppose the procedure is...

  • CIS 120 Final Project Case Study Grades Analysis 1. 4. Overview Please use the Excel data...

    CIS 120 Final Project Case Study Grades Analysis 1. 4. Overview Please use the Excel data file to analyze the grades for students in their class. You are required to use either a formula or function to receive points for the steps. Typing in the answer is worth 0 (zero) points. Steps to complete are as following: Separate the student first name and last name into two columns. (5 points) 2. Get the Average, Minimum, and Maximum of Test 1....

  • Determine whether the following variable is qualitative or​ quantitative, and explain why. The annual salaries of...

    Determine whether the following variable is qualitative or​ quantitative, and explain why. The annual salaries of NBA basketball players Choose the correct answer below. A. The variable is quantitative because salaries are numerical categories. B. The variable is qualitative because the data do not include the salaries of WNBA basketball players. C. The variable is qualitative because salary is based on​ talent, which is not quantifiable. D. The variable is quantitative because there are a limited number of players on...

  • Microsoft Excel Question Which of the following 4 options is the correct answer for this question...

    Microsoft Excel Question Which of the following 4 options is the correct answer for this question ? How does the SUM function handle cells that do not contain a number? Excel treats text cell values as 1. If there are no numbers in the SUM range, Excel displays an error message. Excel doesn't let you enter a SUM function if the range contains any nonnumerical values. Excel displays an error if any of the cells in the SUM range contain...

  • ath 131-Statistics Spring 2019 Linked Marjana Aktar & I 1/20/19 5 1 Frequency Distributions for Organizing...

    ath 131-Statistics Spring 2019 Linked Marjana Aktar & I 1/20/19 5 1 Frequency Distributions for Organizing and Summarizing Data 2.1.15 represents the daily raintall (in inches) for one 0230 0445 The data Construct a frequency distribution beginning with a lower class limit 0 31 of 0.00 and use a class width of 0 20. Does the frequency distribution appear to be roughly a normall distribution 1 27 0.16 15 0 140 0.160550 o 01 002 024 0 14 Daily Rainta...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT