All categories

2 years ago

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

Computers and Technology

1 answer:

Brut [27]2 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

A computer retail store has 15 personal computers in stock. A buyer wants to purchase 3 of them. Unknown to either the retail st

Dima020 [189]

Answer:

a. 1365 ways

b. Probability = 0.4096

c. Probability = 0.5904

Explanation:

Given

PCs = 15

Purchase = 3

Solving (a): Ways to select 4 computers out of 15, we make use of Combination formula as follows;

$^nC_r = \frac{n!}{(n-r)!r!}$

Where $n = 15\ and\ r = 4$

$^{15}C_4 = \frac{15!}{(15-4)!4!}$

$^{15}C_4 = \frac{15!}{11!4!}$

$^{15}C_4 = \frac{15 * 14 * 13 * 12 * 11!}{11! * 4 * 3 * 2 * 1}$

$^{15}C_4 = \frac{15 * 14 * 13 * 12}{4 * 3 * 2 * 1}$

$^{15}C_4 = \frac{32760}{24}$

$^{15}C_4 = 1365$

Hence, there are 1365 ways 

Solving (b): The probability that exactly 1 will be defective (from the selected 4)

First, we calculate the probability of a PC being defective (p) and probability of a PC not being defective (q)

From the given parameters; 3 out of 15 is detective;

So;

$p = 3/15$

$p = 0.2$

$q = 1 - p$

$q = 1 - 0.2$

$q = 0.8$

Solving further using binomial;

$(p + q)^n = p^n + ^nC_1p^{n-1}q + ^nC_2p^{n-2}q^2 + .....+q^n$

Where n = 4

For the probability that exactly 1 out of 4 will be defective, we make use of

$Probability = ^nC_3pq^3$

Substitute 4 for n, 0.2 for p and 0.8 for q

$Probability = ^4C_3 * 0.2 * 0.8^3$

$Probability = \frac{4!}{3!1!} * 0.2 * 0.8^3$

$Probability = 4 * 0.2 * 0.8^3$

$Probability = 0.4096$

Solving (c): Probability that at least one is defective;

In probability, opposite probability sums to 1;

Hence;

Probability that at least one is defective + Probability that at none is defective = 1

Probability that none is defective is calculated as thus;

$Probability = q^n$

Substitute 4 for n and 0.8 for q

$Probability = 0.8^4$

$Probability = 0.4096$

Substitute 0.4096 for Probability that at none is defective

Probability that at least one is defective + 0.4096= 1

Collect Like Terms

Probability = 1 - 0.4096

Probability = 0.5904

8 0

2 years ago

An anagram of a string is another string with the same characters in the same frequency, in any order. For example 'ab', 'bca, a

nlexa [21]

Answer:

from collections import Counter

def anagram(dictionary, query):

newList =[]

for element in dictionary:

for item in query:

word = 0

count = 0

for i in [x for x in item]:

if i in element:

count += 1

if count == len(item):

newList.append(item)

ans = list()

for point in Counter(newList).items():

ans.append(point)

print(ans)

mylist = ['jack', 'run', 'contain', 'reserve','hack','mack', 'cantoneese', 'nurse']

setter = ['ack', 'nur', 'can', 'con', 'reeve', 'serve']

anagram(mylist, setter)

Explanation:

The Counter class is used to create a dictionary that counts the number of anagrams in the created list 'newList' and then the counter is looped through to append the items (tuple of key and value pairs) to the 'ans' list which is printed as output.

4 0

2 years ago

Describe ways in which an interpersonal learner prefers to learn. Write a paragraph of two to three sentences that explains your

Artyom0805 [142]

An interpersonal learner prefers to learn through interactions with other people. They learn through use of interpersonal skills and communication. They like to be coached and to coach others. So mentoring and apprenticeship is a good way. Moreover, group activities, like group study and role-play are excellent ways fro interpersonal learners to learn.

5 0

2 years ago

In a typical product-mix problem in linear programming, each general constraint states that

Montano1993 [528]

In a typical product-mix problem in linear programming, each general constraint states the function to minimize and maximize a subject in programming to a finite number. This was created by George Dantzig it was further improved using a new method to solving linear programming last 1984.

6 0

2 years ago

Network access control authenticates users logging into the network and determines what data they can access and actions they ca

erik [133]

Answer:

The answer is letter A

Explanation:

The statement is TRUE

3 0

2 years ago