In an Excel spreadsheet, a set of numbers is stored in cells B1, B2, B3, , B9. Write an Excel formula that would calculate the mean of this data.
Solution 1
Answer:
=(B1+B2+B3+B9)/4
Explanation:
The mean is the average of a group of data and it is calculated by adding all the numbers and dividing by the amount of numbers. So, according to this, the formula in Excel that would allow you to calculate the mean of this data is:
=(B1+B2+B3+B9)/4
You have to add the numbers by indicating the cells in which they are contained and divide by 4 that is the amount of numbers given.
📚 Related Questions
Answer:
Option E is false.
Explanation:
Option A is true.
When you first turn on your computer, RAM is empty. RAM holds processed data before it is stored more permanently on disk. RAM is also volatile memory.
Option B is true.
The processor can run a program only if it is available in RAM. We have to bring a program into the RAM before running it.
Option C is true.
To run a program, the operating system finds the program in flash memory and loads it in RAM because flash memory is a non-volatile memory and it keeps its data until you delete it.
Option D is true.
Flash drives use the type of memory that holds data even when they are not connected to a power source because flash memory is a non-volatile type of memory. and it contains its content when it is not connected to a power source.
so only Option E is false.
The statement that is false is that When the OS needs to store more programs in RAM, RAM expands automatically.
What is RAM?
RAM is a term that connote random access memory. It is found present in a computer.
Note that the RAM is said to be a very volatile memory that only saves files temporarily and as such, saying that the OS needs to store more programs in RAM, RAM expands automatically is wrong as that does not happen.
Learn more about RAM from
Answer:
The answer to this question defined below.
Explanation:
It's a smart idea to get a common language for coding of every kind. It would help all developers and customers understand the language better because, in every case, there's no more need to learn, that language.
- This could also render software developed in the very same language consistent, and therefore, ports on multiple platforms are not required.
- In this process, we talk about the common property and function of the classes, that's why it is the correct answer.
Answer:
b. Customized auditing.
Explanation:
Vulnerability scanning is a process of finding or testing a system for weak or vulnerable spots which can be exploited by outsiders. It helps to boost the computer network in an organisation.
There are two types of vulnerability scanning, they are credentialed and non-credentialed scanning and they are defined as implied. The non credentialed scan requires no authorisation and credentials for scanning to take place while credentialed scan is the reverse.
The credentialed scanning provides baseline and customised auditing features.
Answer:
The correct answer is letter "B": Customized auditing.
Explanation:
Credentialed scanning can be used for baseline or Policy Compliance. Most vulnerability scanners have a customized audit that allows them to find out if a system meets the company's minimum requirements. The audit templates can be set up for different types of serves and network equipment.
Answer:
26.4 hour
21.12 hours
Explanation:
To properly answer this question, we will multiply the estimated time to build the first pool in 33 hours by the percentage of of the contractors estimate.
Thus, we have,
33 x 0.80 = 26.4. This is assumed to be the estimated time to build the second pool.
Now, moving forward to calculate the estimated time to install the fifth pool, we multiply the estimated time for the second pool by percentage of the contractors estimate.
That is:
26.4 X 0.80 = 21.12
Hence, 21.12 is the assumed estimated time required to install the fifth pool.
Answer / Explanation:
Coordination numbers, grain growth in ice, and till deformation.
The Web of Science lists 5 papers that Dr. Alley helped write and that have 1986 publication dates. Dr. Alley was studying why some parts of the Antarctic ice sheet move rapidly, and helped learn that deformation of a special type of mud beneath, called till, was involved. He also was studying the physical properties of ice cores, including why and how some crystals or grains in the ice get bigger over time. Some of the physical properties of the ice cores are related to how many different grains are touching each other, which is the coordination number.
Later, Dr. Alley used his knowledge of physical properties in ice to learn how old ice cores are, and to help learn about climate history from them. The other possibilities listed are all things that he studied, some rather closely related, but that were not published in 1986.
The correct answer is: a_8 =47
- When The cost of maintenance for 2 years is $69000
a.) when a_0 = 23 is the number of cars at the beginning of the 1 month. and then At the end of the first month a_1 = 26 cars. an addition that of extra 3 cars.
- Therefore The Arithmetic Progression equation will be used are:
That is T(n) = a + (n-1)×d
- Where that T(n) is the number of cars after that n months
- So that "a is the number of cars at the end bbn of the first month; 26 d is the monthly car increment that is 3
- When Substituting a and d into the equation, the equation will be reduced to
That is T(n)= 23 + 3n
- After that For number of cars after 8 month a_8;
which is T(8)= 23 + 3(8)
T(8) = 47
b.) Solution of second is that The maintenance of the cost at the first month is $50× 23 cars= $1150, for the second month is $50 × 26 cars= $1300, for the third month is $50 × 29 cars = $1450. The monthly increment is $150.
After that Arithmetic Progression will also be used to solve this problem are:
That is Sm = n/2 [2a + (n-1)×d]
Where that, Sn is the sum of maintenance which cost for months is n
- When 'a' is the maintenance cost of the first month; $1150
- Also that 'd' is the monthly increment; $150
- After that Inserting a and d into the formula, Sn reduces to
- That is Sn= n/2[2150 + 150n]
- When they are Inputting 24months (2 years) as n on the equation above
- Sn= 24/2[2150 + 150×24]
- so, that solution is Sn= $69000
Learn more information:
Answer:
a_8 =47
The cost of maintenance for 2 years is $69000
Explanation:
a.) a_0 = 23 is the number of cars at the beginning of the first month. At the end of the first month a_1 = 26 cars. This is due to the addition of extra 3 cars.
The Arithmetic Progression equation will be used to solve this question.
T(n) = a + (n-1)×d
Where
T(n) is the number of cars after n months
a is the number ofr cars at the end bbn of the first month; 26
d is the monthly car increment; 3
Substituting a and d into the equation, the equation reduces to
T(n)= 23 + 3n
For number of cars after 8 month a_8;
T(8)= 23 + 3(8)
T(8) = 47
b.) The maintenance cost at the first month is $50× 23 cars= $1150, for the second month $50 × 26 cars= $1300, for the third month $50 × 29 cars = $1450. The monthly increment is $150.
Arithmetic Progression will also be used to solve this problem.
Sm = n/2 [2a + (n-1)×d]
Where
Sn is the sum of maintenance cost for months n
a is the maintenance cost of the first month; $1150
d is the monthly increment; $150
Inserting a and d into the formula,Sn reduces to
Sn= n/2[2150 + 150n]
Inputting 24months (2 years) as n on the equation above
Sn= 24/2[2150 + 150×24]
Sn= $69000
Answer:
Hi Tianylee114! The answer is False.
Explanation:
Structural Testing or White-Box testing by definition is the testing of Software solution's internal structure, design and coding. The code is therefore visible to the tester, who can verify the internal flow of variables and outputs based on operations of those inputs. This allows the tester to identify areas of improvements. Black-Box testing on the other hand is where the software is tested for behaviour, therefore internals are not visible to the tester.
Answer:
The statement is: False.
Explanation:
White Box Testing is a type of benchmark for applications where the language written is visible since the coding and structure are analyzed. The White Box Testing aims to verify the feeds that create the application so its use and security can be upgraded.
Answer:
Computer system use Binary and it uses power of 2 only.
Explanation:
The reasons for equipping memory with a peculiar number instead of round or even number are as follows:
- The computer system uses the power of 2 instead of the power of 10 to equipping memory and hence use a number like 250,000,000 is not possible.
- The computer systems work on the memory where 1 MB or 1 megabyte shows as 1024 kb or 1,048,576 bytes.
- In computer system memory capacity is always some multiply of 1024 bytes.
- Hence, 268,435,456 bytes of memory shows 256 MB of memory.
Answer:
d. Blanchard/Peale model
Explanation:
In order to conduct proper emission test, it is essential to follow the three steps proposed by Blanchard and Peale. Their proposition can be used to answer the necessary ethical questions and proffer solutions. Therefore, the company should have conducted an ethical check to resolve the ethical issue. The correct answer is option d.
Answer:
The correct answer is letter "D": Blanchard/Peale model.
Explanation:
The Blanchard-Peale model is a technique helpful to solve an ethical dilemma. This approach asks three questions about the problem: Is it legal? Is it fair? and How does it make me feel? Answering those questions would help individuals and organizations to avoid major issues involving the law.
Answer:
13.2 miB
Explanation:
Total Number of pixels:
N = (326*7.5) * (326*5.8) = 4,623,006 pixels.
If we have 3 color subpixels, and any of them has 256 levels, this means that each color subpixel will have 8 bits.
⇒ 4,623,006*24*8 = 110,952,144 bits
As 1 byte = 8 bits,
N(Bytes) = 110,952,144 bits / 8 = 13,869, 018 bytes
As 1 MiB = 2²⁰ bytes = 1024*1024,
The total size of the display memory in MiBs is as follows:
N(MiB) =
⇒ N(MiB) = 13.2 MiB