All categories

3 years ago

In cell B22, enter a function to calculate the minimum attendance for the year 2022?

Computers and Technology

1 answer:

Brut [27]3 years ago

8 0

Answer:

The user must use min() to attain the desired results. Let us understand the syntax of min() with an example. 

Syntax: 

min(range) where min is the name of the function and the range specifies the address of cells from which the minimum number needs to be found.

Eg. min(A1:A8) 

This function will scan the values from A1 to A8 and then find the minimum value from the given range of values.

So according to the problem, 

B22 = min(range). Provide range for which minimum attendance needs to be calculated.

You might be interested in

Which support function under Tech Mahindra is governing data privacy and protection related requirements

Alex Ar [27]

Answer:

Explanation:

PRIVACY POLICY is the support function under Tech Mahindra that is governing data privacy and protection-related requirements.

Given that support functions are functions which assist and in a way contribute to the company goal.

Other support functions are human resources, training and development, salaries, IT, auditing, marketing, legal, accounting/credit control, and communications.

The above statement is based on the fact that the Privacy Policy clarifies all the data protection rights, such as the right to object to some of the production processes that TechM may carry out.

7 0

3 years ago

Difference between multi-national and global company

trapecia [35]

A multinational corporation, or MNC, is a company which produces goods and services and has offices in several other countries while a global corporation or company is a company which also has trade relations with several other countries. ... MNCs have official headquarters while global companies do not.

5 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

Integers and booleans. Write a program RightTriangle that takes three int command-line arguments and determines whether they con

icang [17]

Answer:

The programming language is not stated;

I'll answer using C++

#include<iostream>

#include<cmath>

using namespace std;

int main()

{

int side1, side2, side3;

cout<<"Enter the three sides of the triangle: "<<endl;

cin>>side1>>side2>>side3;

if(side1<=0 || side2 <= 0 || side3 <= 0) {

cout<<"Invalid Inputs";

}

else {

if(abs(pow(side1,2) - (pow(side2,2) + pow(side3, 2)))<0.001) {

cout<<"Right Angled";

}

else if(abs(pow(side2,2) - (pow(side1,2) + pow(side3, 2)))<0.001) {

cout<<"Right Angled";

}

else if(abs(pow(side3,2) - (pow(side2,2) + pow(side1, 2)))<0.001) {

cout<<"Right Angled";

}

else {

cout<<"Not Right Angled";

}

return 0;

}

Explanation:

The following line declares the three variables

int side1, side2, side3;

The next line prompts user for input of the three sides

cout<<"Enter the three sides of the triangle: "<<endl;

The next line gets user input

cin>>side1>>side2>>side3;

The following if condition checks if any of user input is negative or 0

if(side1<=0 || side2 <= 0 || side3 <= 0) {

cout<<"Invalid Inputs";

}

If otherwise

else {

The following if condition assumes that side1 is the largest and test using Pythagoras Theorem

if(abs(pow(side1,2) - (pow(side2,2) + pow(side3, 2)))<0.001) {

cout<<"Right Angled";

}

The following if condition assumes that side2 is the largest and test using Pythagoras Theorem

else if(abs(pow(side2,2) - (pow(side1,2) + pow(side3, 2)))<0.001) {

cout<<"Right Angled";

}

The following if condition assumes that side3 is the largest and test using Pythagoras Theorem

else if(abs(pow(side3,2) - (pow(side2,2) + pow(side1, 2)))<0.001) {

cout<<"Right Angled";

}

If none of the above conditions is true, then the triangle is not a right angles triangle

else {

cout<<"Not Right Angled";

}

}

return 0;

Download cpp

4 0

3 years ago

What name is used to denote a common field that exists between two tables, but is also the primary key for one of the tables??"

Diano4ka-milaya [45]

Answer:

b. foreign key

Explanation:

In the database world, a foreign key is a field on one table and a primary key for another table. The purpose of a foreign key is to provide linkages between two or more tables. Given two tables A and B, and making A the point of reference, a primary key is a field that is unique in A while a foreign key is unique in B.

On another hand, a composite primary key is a combination of two or more fields/columns on database table that can be used to uniquely identify each row in the table.

In the database lingua, what we have is a unique key not a distinct key, though the two words are similar in meaning.

A duplicate key is used when an information may be repeatedly entered on a table.

So the correct option is a foreign key.

4 0

3 years ago