In an Excel spreadsheet, a set of numbers is stored in cells B1, B2, B3,

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.

2 months ago

Solution 1

Guest Guest #2392141
2 months ago

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

Question
Which of the following statements is false? A. When you first turn on your computer, RAM is empty. B. The processor can run a program only if it is available in RAM. C. To run a program, the operating system finds the program in flash memory and loads it in RAM. D. Flash drives use the type of memory that holds data even when they are not connected to a power source. E. When the OS needs to store more programs in RAM, RAM expands automatically.
Solution 1

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.

Solution 2

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

brainly.com/question/24688176

Question
1. What arguments can you make for the idea of a single language for all programming domains
Solution 1

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.
Question
The security administrator for Corp.com. You are explaining to your CIO the value of credentialed scanning over non-credentialed scanning. In credentialed scanning, policy compliance plugins give you which advantage? a. Active scanning b. Customized auditing c. More accurate results d. Safer scanning
Solution 1

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.

Solution 2

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.

Question
A contractor is preparing a bid to install swimming pools at a new housing addition. The estimated time to build the first pool is 33 hours. The contractor estimates an 80 percent learning rate. Using POM for Windows or OM​ Explorer, how long do you estimate the time required to install the fifth pool?
Solution 1

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.

Question
Type "Alley RB" into the author space on the Web of Science. You will find lots of pages of refereed scientific literature that Dr. Alley has worked on. What was he publishing on in 1986? (Hint: the older ones are near the back, so use the "page" box near the top in the center to go there.) Group of answer choices
Solution 1

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.

Question
A Silicon Valley billionaire purchases 3 new cars for his collection at the end of every month. Let a_n denote the number of cars he has after n months. Let a_0 = 23.a) What is a_8 ?b) If he pays $50 each month to have a car maintained, how much does he pay for maintenance after 2 years? No need to calculate the actual number. Instead give a closed form (without the summation) mathematical expression for the number. Note that he purchases the new car at the end of each month, so during the first month, he is only maintaining 23 cars.
Solution 1

       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:

brainly.com/question/8445686

Solution 2

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

Question
In Structural Testing (White-Box), we ignore how the program is being written. Group of answer choices True False
Solution 1

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.

Solution 2

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.

Question
A certain computer can be equipped with 268,435,456 bytes of memory. Why would a manufacturer choose such a peculiar number instead of a round, even number like 250,000,000
Solution 1

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.

Question
VW discovered that its engineers had developed a software program that allowed some of its car models to run without emissions controls except when the cars were undergoing emissions testing. The company goal was to reduce emissions and maintain fuel efficiency. The falsification of emissions data is a federal crime. Which of the following ethical resolution models would have helped VW employees analyze their conduct better as they were developing this software? a. "front page of the newspaper test"​ b. ​Wall Street Journal model c. ​ethical relativism d. ​Blanchard/Peale model
Solution 1

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.

Solution 2

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.

Question
A tablet has a 7.5- × 5.8-inch screen size with a resolution of 326 pixels per inch. (a) How many pixels does it have? (b) With 256 levels of brightness for each color subpixel, what is the MiB size of the display memory?
Solution 1

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) =\frac{13,869,018}{1,024*1,024} = 13.2 MiB

⇒ N(MiB) = 13.2 MiB