Question

In: Statistics and Probability

What is the excel function/equation to add every ten numbers. I have a list of 100...

What is the excel function/equation to add every ten numbers. I have a list of 100 numbers or so in a row. I want to add the first ten numbers and put the value in the row below the list. So add numbers 1 to 10, 2 to 11, 3 to 12, and so on. There has to be an easier way to do this than manually right?

Solutions

Expert Solution

We use the OFFSET Function in excel for increament.

1) if we have data in the one column, then to add the first 10 or n rows use formula.

=SUM(OFFSET($A$1,(ROW()-ROW($A$1))*10,0,10,1))

where A1 is starting cell.

10 is increament number.

if you want to result displayed at 10 th cell of column then use formula:

=IF(MOD(ROW(),10),"",SUM(OFFSET(B1,,,-10)))

(paste formula in first row & drag it.)

2) If we have data in the one rows then use function

=SUM(OFFSET($A$1,,(COLUMNS($A$3:A3)-1)*10,,10)) (A1 is the cell reference which your first value located, A3 stands for the cell where you put this formula in, and 10 is the incremental column numbers ), and then drag the fill handle over to the right cells until 0 is displayed)


Related Solutions

I believe I can do this in excel but not sure which equation or function to...
I believe I can do this in excel but not sure which equation or function to use? Would appreciate any help! You are offered an add-on loan for $4,500 at 18% for 5 years. What is the monthly payment? What is the amount of interest? What is the true interest rate cost of this loan? If you could pay the same loan above at a compound rate, What would the monthly payment be? What would the amount of interest be?
An urn contains 100 balls that have the numbers 1 to 100 painted on them (every...
An urn contains 100 balls that have the numbers 1 to 100 painted on them (every ball has a distinct number). You keep sampling balls uniformly at random (i.e., every ball is equally likely to be picked), one at a time, and without replacement. For 1 ? i < j ? 100, let E{i,j} denote the event that the ball with the number j was taken out of the urn before the ball with the number i. Prove that the...
An urn contains 100 balls that have the numbers 1 to 100 painted on them (every...
An urn contains 100 balls that have the numbers 1 to 100 painted on them (every ball has a distinct number). You keep sampling balls uniformly at random (i.e., every ball is equally likely to be picked), one at a time, and without replacement. For 1 ≤ i < j ≤ 100, let Ei,j denote the event that the ball with number j was picked after the ball with number i got picked. Identify which of the following sets of...
Every C++ program starts with this function:____________________ 2. If A is > 100 I want cnt...
Every C++ program starts with this function:____________________ 2. If A is > 100 I want cnt to be equal to 32 but if A 100 or less I want cnt to be 2. Write a single line using a conditional operator to do this. 3. I want to store into B the remainder of dividing B by the total of A plus D. Write the statement: as a combined operator statement not using a combined operator 4. I want to...
Suppose I have a list of 128 unsorted numbers. If I use the binary search to...
Suppose I have a list of 128 unsorted numbers. If I use the binary search to search it, how many comparisons will I have to do in the worst case, assuming I use a quadratic algorithm to sort the list first.
Write a function that will accept a list of numbers and an integer (n). The function...
Write a function that will accept a list of numbers and an integer (n). The function should return a list containing every nth item from the input list, always starting with the first item in the list. The original list should not be modified. For example, if the function is passed the list [8, 3, 19, 26, 32, 12, 3, 7, 21, 16] and the integer 3, it will return the list [8, 26, 3, 16] If the function is...
2) For reactions in basic solutions, add OH- to both sides of the equation for every...
2) For reactions in basic solutions, add OH- to both sides of the equation for every H+ that appears in the final equation. Is this correct? What should be done for reactions in acid solution? Please discuss briefly.
In python I have a linked list. I want to create one function that takes in...
In python I have a linked list. I want to create one function that takes in one parameter, head. In the function, cur = head and next_cur = head.next. I want to return head and next_cur, except at the end of the function they will return alternating values from head. For example, if the these are the values in the linked list: 2, 3, 5, 7, 11 after the function head should return: 2, 5, 11 and next_cur should return:...
W74) Please answer in detail with EXCEL Function since I am learning in EXCEL function Tests...
W74) Please answer in detail with EXCEL Function since I am learning in EXCEL function Tests with Chi-Square distribution    Variance               A random sample of the number of games played by individual NBA scoring leaders is shown below and reproduced in the Excel answer workbook. If a sports analyst argues that this sample variance is no different from 40 at α = .05, is she correct? Assume, of course, that the number of games played variable is normally distributed....
Write a function which receives a list and returns a number. In the list, all numbers...
Write a function which receives a list and returns a number. In the list, all numbers have been repeated twice except one number that is repeated once. The function should return the number that is repeated once and return it.write a python program for this question. use main function.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT