Answer:
=IF(A1<40000,(18%*I18),(27%*A1))
Step-by-step explanation:
The spreadsheet expression to be used is the "IF" function. The "IF" function is one that returns a value based on the conditions stated thereafter in the spreadsheet formula. Like every spreadsheet function, this also starts with =
In the question given,
The value to be examined is in cell A1. if A1 is less than $40000 is written as A1<40000, is true, the spreadsheets executes the next function stated as (18%*I18) otherwise (which in this case can be interpreted as A1 greater than or equal to $40000), compute the next command as shown above; (27%*A1)
The final parenthesis closes the command.
Hence the expression is IF(A1<40000,(18%*I18),(27%*A1)).
Answer:
38.7°
Step-by-step explanation:
You are basically looking at a triangle with a 90° angle (check picture).
Since we are looking for the ramp's angle and are given the length of the opposite and the hypothenuse, we have to solve the following equation:
which is equivalent to
Answer:
angle 4= 20
Step-by-step explanation:
Answer:
0.97547
Step-by-step explanation:
Given That:
Mean (m) = 102
Standard deviation (σ) = 12
Sample size (n) = 63
Probability that sample mean would differ from Population mean by less than 3.4 watts
P(m - s < X < m + s)
P(102 - 3.4 < Z < 102 + 3.4)
Using the Z formula :
Zscore = (x - m) / (σ/√n)
x = 102 - 3.4 = 98.6 ; x = 102 + 3.4 = 105.4
Z = (98.6 - 102) / (12/√63) = −2.248888
P(Z < - 2.2488) = 0.012263 (Z probability calculator)
Z = (105.4 - 102) / (12/√63) = 2.2488886
P(Z < 2.2488) = 0.98774 (Z probability calculator)
0.98774 - 0.012263 = 0.97547
