Question

What is the function and argument to count the number of cells in the range B1:B50...

  1. What is the function and argument to count the number of cells in the range B1:B50 that equal “B”?
  2. What is the function and arguments to retrieve the value located in the fifth row and second column of the data in the range A10:G50?
Math   Advanced-Math   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Q1) What is the function and argument to count the number of cells in the range B1:B50 that equal “B”?

Ans)

In text form:

=countif(B1:B50,"B")

Q2) What is the function and arguments to retrieve the value located in the fifth row and second column of the data in the range A10:G50?

In text form:

=INDEX(A10:G50,5,2)

Hope this was helpful. Please do leave a positive rating if you liked this answer. Thanks and have a good day!

0 0
Know the answer?
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
Similar Questions
COUNTIF excel function Count number of cells based on filtered data. for example counting number of...
COUNTIF excel function Count number of cells based on filtered data. for example counting number of orange sold on the 1/1/2010 Look at filtered data below Data Item Sold OrangesSold 1/1/2010 Oranges 1/1/2010 Oranges 1/1/2010 Apples Question a)What excel function would you use to count the number of oranges sold.Show work
Define and test a function myRange. This function should behave like Python’s standard range function, with...
Define and test a function myRange. This function should behave like Python’s standard range function, with the required and optional arguments, but it should return a list. Do not use the range function in your implementation! Study Python’s help on range to determine the names, positions, and what to do with your function’s parameters. Use a default value of None for the two optional parameters. If these parameters both equal None, then the only provided argument should be considered the...
Excel searches for an exact match of the first argument in the first column of the...
Excel searches for an exact match of the first argument in the first column of the data when the range in the VLOOKUP function is a. EXACT. b. TRUE. c. FALSE. d. NULL. The function of Trace Precedents and Trace Dependents is to a. highlight errors in copying and formula construction. b. investigate the cell calculations in great detail. c. ascertain how model parts are segregated. d. trace the range of cells included in the Watch Window box list.
1. What are the inputs to Excel’s RAND function? a.There is one argument to put into...
1. What are the inputs to Excel’s RAND function? a.There is one argument to put into the function – the distribution from which to generate random numbers. b.There are two arguments to put into the function – the number of random values to generate, followed by the number of decimal places. c.The RAND function has no arguments, just parentheses with nothing in between. 2. What do you actually type into a spreadsheet cell to use the RAND function? a. =RAND()...
Write a function to find the indices of a time series in which the absolute value...
Write a function to find the indices of a time series in which the absolute value of the derivative is above a particular threshold. This is somewhat based on work we’ve done in this chapter. The function: (a) should be named where_deriv_large. (b) should take two arguments: times, data (in that order). (c) (509 only) should have a third argument in which the value of the threshold can be passed. (d) should return a tuple. The first element is the...
1. Write a function to find the indices of a time series in which the absolute...
1. Write a function to find the indices of a time series in which the absolute value of the derivative is above a particular threshold. This is somewhat based on work we’ve done in this chapter. The function: (a) should be named where_deriv_large. (b) should take two arguments: times, data (in that order). (d) should return a tuple. The first element is the indices of the derivative that exceed a particular threshold. The second element is the count of the...
a fixed point of a function f is a number c in its domain such that...
a fixed point of a function f is a number c in its domain such that f(c)=c. use the intermediate value theorem to prove that any continious function with domain [0,1] and range a subset of [0,1] must have a fixed point.[hint: consider the function f(x)-x] “Recall the intermediate value theorem:suppose that f is countinous function with domain[a,b]and let N be any number between f(a)and f(b), where f(a)not equal to f(b). Then there exist at least one number c in...
Suppose you roll two dice and count the number of dots showing. Let A = "the...
Suppose you roll two dice and count the number of dots showing. Let A = "the sum of the dots showing on the two rolls is a prime number." (a) Let B = "The first toss showed an even number of dots." Are A and B independent? Show your work. (b) Let C = "the second toss was greater than the first." Are A and C independent? Show your work. (c) Suppose we pick a value ?k for 1≤?≤61≤k≤6 and...
Use Random number generator (under Data Analysis) to simulate the following data set. Create 10 columns,...
Use Random number generator (under Data Analysis) to simulate the following data set. Create 10 columns, each 20 points long and use the following parameters: Number of variables (10), number of data point (20), Distribution (Normal), Mean (40), Standard Deviation (10), Random seed (1234). The data should be in columns: A,B,C,….,I,J. Randomly pick two columns (say Column B and Column H) and perform 2-sided t-test on these two data columns. Record the P-value and repeat this procedure several times (at...
Use Random number generator (under Data Analysis) to simulate the following data set. Create 10 columns,...
Use Random number generator (under Data Analysis) to simulate the following data set. Create 10 columns, each 20 points long and use the following parameters: Number of variables (10), number of data point (20), Distribution (Normal), Mean (40), Standard Deviation (10), Random seed (1234). The data should be in columns: A,B,C,….,I,J. Randomly pick two columns (say Column B and Column H) and perform 2-sided t-test on these two data columns. Record the P-value and repeat this procedure several times (at...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT