Answer:
Use the HLOOKUP function in the cell E2 by specifying the student's hourly rate value, the range of cells of the table holding the information, the row from which to return the value, and a value of true or false for approximate or exact match respectively.
Explanation:
Microsoft Excel is a statistics tool used for data analysis. It has several functions and graphical properties for cleaning and representing data.
The HLOOKUP function is an example of a search function in excel, it returns a value based on another value from a range of cells. The function accepts four arguments, they are, the value to be searched, the range table or cell range to search, the row to get the search value, and a mode of return value to return, could be either true for an approximate match or false for an exact match.
Answer:
The correct Answer is 0.0571
Explanation:
53% of U.S. households have a PCs.
So, P(Having personal computer) = p = 0.53
Sample size(n) = 250
np(1-p) = 250 * 0.53 * (1 - 0.53) = 62.275 > 10
So, we can just estimate binomial distribution to normal distribution
Mean of proportion(p) = 0.53
Standard error of proportion(SE) =
=
= 0.0316
For x = 120, sample proportion(p) =
=
= 0.48
So, likelihood that fewer than 120 have a PC
= P(x < 120)
= P( p^ < 0.48 )
= P(z <
) (z=
)
= P(z < -1.58)
= 0.0571 ( From normal table )
Answer:
cout << setprecision(2)<< fixed << number;
Explanation:
The above statement returns 12.35 as output
Though, the statement can be split to multiple statements; but the question requires the use of a cout statement.
The statement starts by setting precision to 2 using setprecision(2)
This is immediately followed by the fixed manipulator;
The essence of the fixed manipulator is to ensure that the number returns 2 digits after the decimal point;
Using only setprecision(2) in the cout statement will on return the 2 digits (12) before the decimal point.
The fixed manipulator is then followed by the variable to be printed.
See code snippet below
<em>#include <iostream> </em>
<em>#include <iomanip>
</em>
<em>using namespace std; </em>
<em>int main() </em>
<em>{ </em>
<em> // Initializing the double value</em>
<em> double number = 12.3456; </em>
<em> //Print result</em>
<em> cout << setprecision(2)<< fixed << number; </em>
<em> return 0; </em>
<em>} </em>
<em />
This depends on what computer and
System it's running on