All categories

3 years ago

What does =SUM(B2:B6) mean

1 answer:

8 0

In Excel the sum B2 and B6 simply means that B2 and B6 Numbers are adding to get a Sum, it actually like the normal Calculator, but in Excel it helps to do the calculation of your your data simple and easy, there is no hard work.

You might be interested in

What ideas should I write about for information writing

Lady bird [3.3K]

Well first of all who is your favorite celebrity?
Then find some research and look up interesting facts you did not know about.

5 0

3 years ago

Read 2 more answers

Steve is creating a document with proper nouns, which Word continues to identify as being misspelled.

mash [69]

Answer:

it's D. B and C are correct.

Explanation:

The options are:

A. Skip the Spell Checker.

B. Right-click the noun and choose to Ignore All.

C. Right-click and Add to the dictionary.

D. B and C are correct.

You can either right-click the noun and choose to Ignore all. or you can Right-click and add to the dictionary. And this is because you are correct this time, as a proper noun can have misspelled type of spelling. And this is because it is some other language word, and that's why.

6 0

3 years ago

Read 2 more answers

For this problem, you will write a function standard_deviation that takes a list whose elements are numbers (they may be floats

Evgesh-ka [11]

Answer:

import math
def standard_deviation(aList):
sum = 0
for x in aList:
sum += x
mean = sum / float(len(aList))
sumDe = 0
for x in aList:
sumDe += (x - mean) * (x - mean)
variance = sumDe / float(len(aList))
SD = math.sqrt(variance)
return SD
print(standard_deviation([3,6, 7, 9, 12, 17]))

Explanation:

The solution code is written in Python 3.

Firstly, we need to import math module (Line 1).

Next, create a function standard_deviation that takes one input parameter, which is a list (Line 3). In the function, calculate the mean for the value in the input list (Line 4-8). Next, use the mean to calculate the variance (Line 10-15). Next, use sqrt method from math module to get the square root of variance and this will result in standard deviation (Line 16). At last, return the standard deviation (Line 18).

We can test the function using a sample list (Line 20) and we shall get 4.509249752822894

If we pass an empty list, a ZeroDivisionError exception will be raised.

3 0

3 years ago

Can you help me with these AP Computer Science Questions. (THIS IS DUE BY 1:30 PM today) you have to evaluate the Boolean Expres

vfiekz [6]

Answer + Explanation:

'and' -> both statements are 'True' to evaluate as 'True'.

'or' -> at least one statement is 'True' to evaluate as 'True'.

1. True (grade has the value of 82, so the statement evaluates to 'True').

2. True (Both statements are true, this expression evaluates to 'True').

3. False (Both statements are false, this expression evaluates to 'False').

4. True (the != operator means not equal. Since the 'name' variable holds the string 'Rumpelstiltskin', name != 'Rumpelstiltskin' evaluates to 'False'. The 'not' operator returns the opposite of the given Boolean expression, so this expression evaluates to 'True').

5. True (name == 'Rumpelstiltskin' evaluates to 'True', so this expression is true).

6. False (All statements evaluate to 'False').

7. True (All statements evaluate to 'True').

8. False (All statements evaluate to 'True' except for not(x == - 3) which evaluates to 'False', so the whole statement now becomes false).

9. True (grade+5 < 90 and grade >= 80 evaluates to 'True', so this whole expression becomes true).

10. True (grade > 0 and x % 2 == 1 evaluates to 'True')

Hope this helps :)

7 0

3 years ago

Provide an example of a question that could NOT be answered with a binary message. Explain why this is the case, making referenc

solong [7]

This is a question with a much simpler answer given its open ended ness - a representation merely means, given binary data, we can determine what 'thing' that binary data corresponds to.

That makes the question unanswerable, because words can all be represented in binary data, and the question cannot be answered without those. Thus, all answers we can convey have a binary representation of some form (that form being the translation of the words we used to communicate the answer into binary data).

7 0

3 years ago