answersLogoWhite

0

What else can I help you with?

Continue Learning about Math & Arithmetic

What is the sum of the values stored in cells b4 b5 b6 and b7?

Use following function in any other cell to calculate sum: =sum(b4:b7)


Uses of chi-square test?

The chi-square test is used to analyze a contingency table consisting of rows and columns to determine if the observed cell frequencies differ significantly from the expected frequencies.


How do you add values of a and b in column c?

If it's a spreadsheet, write the following formula, for example, in C1: = A1 + B1 Or better yet, type "=", click on the first cell you want to add, type "+", and click on the second cell you want to add. The advantage of this method is that you are less likely to get it wrong. Since the cells are adjacent, you can also use the sum() function. For example, in cell C1: = sum(A1:B1)


What are the advantages of using the references in a spreadsheet equation?

It allows you to use the same formula for different values. All you need to do to use different values is change the cells that have the values and you have no need to changed the formula. It is also possible to give cells real names and then use these in a formula. This can make the formula more meaningful. If you take the following formulas, the first is obviously very clear. The second is not so clear, but enables values to be changed in the referenced cells and the third has the actual values. =Income - Expenditure =A6 - B6 =50430-42950 Another advantage and reason is by having the actual values in separate cells, you can see the values on the spreadsheet, making it easier to understand. If you have the values directly in the formula, you will see the result of the formula, but it won't be as clear as to how the total was arrived at. Anything that can be calculated in a spreadsheet should be calculated, and cell references should be used to make the spreadsheet clearer. Another reason is that a formula that has references in it can be copied easily and used with different values, which you can't do if the formula has direct values in it. A lot of spreadsheets consist of similar formulas which can be copied. This is the most efficient way of doing things, rather than repeatedly typing similar formulas. These are some of the main reasons that you would use references rather than actual values in a spreadsheet formula.


How do you represent data as a series of numerical values?

You can assign a numerical value to each element in your data series. There are several ways to do that. Here is a simple example:In cell A1 enter your first data element. Let that entry be GREEN.In cell B1 enter the formula, =IF(A1="GREEN",1,0). Observe that the value of B1 is 1, since the contents of cell A1 is GREEN. If A1 = RED, then B1 would display 0.You also could give a value to each data item depending on the number of characters in the cell. You can do this with the formula =LEN(A1).