Q4.(15) One random sample of the height of one type of tree was recorded.
7, 9 ,10, 7 ,12 ,10, 8, 13 ,15, 9
1.(5) Apply the backward empirical rule to check normality of the data, and conclude if any evidence of non-normality.
2.(5) Assume the height of the tree is normal, calculate the 99% two-sided confidence interval for the true population average height.
3.(5) Assume that we know the population variance σ^2=9,
and we request the bound on the error of estimation of 99% confidence interval to be 2, find the minimum sample size n.

Q4.(15) One random sample of the hours of one type of user watch TV per day was recorded: 2.9, 3.5, 3, 3.2, 3.3, 3.5, 3.3, 3, 3.5.

1.(5) Apply the backward empirical rule to check normality of the data, and conclude if any evidence of non-normality.

2.(5) Assume that the underlying population is normal. Find a two-sided 99% confidence interval for the the true population average hours

3.(5) Assume that population variance σ2=0.09σ2=0.09 and the bound on the error of estimation of 99% confident interval to be 0.2. Find the minimum sample size nn.

Q4.(15) One random sample of the height of one type of tree was recorded. 7, 9 ,10, 7 ,12 ,10, 8, 13 ,15, 9 1.(5) Apply the backward empirical rule to check normality of the data, and conclude if any evidence of non-normality. 2) Assume the height of the tree is normal, calculate the 99% two-sided confidence interval for the true population average height. 3.(5) Assume that we know the population variance σ2=9, and we request the bound on the error of estimation of 99% confidence interval to be 2, find the minimum sample size n.

DBMS Create/Insert/Update SQL

I need the create, insert, and update SQL statement for this table as if it were being added to MySQL (please give explanations for each line of SQL code and a copy of the code as it would be entered into the query by itself:

Vendor is the name of the table the FK comes from.

• Use Excel to conduct a regression of the values of the security against the predictors and verify the validity of underlying assumptions
  • Check for homoscedasticity and serial correlation
  • If necessary, rerun the regression using robust standard errors
  • Look for evidence of multicollinearity and eliminate redundant predictors if necessary

Record the following in John’s two-column cash book. Balance the cash book and bring down the balances of cash in hand and cash at bank at the end of the period. and open the necessary ledger account.

2018

October 1st Introduced ₦5,000 cash into the business as capital

October 5th Paid rent of ₦2000 cash

October 11th Receive cheque of ₦1000 from sales

October 15th Purchase good and paid ₦2000 by cheque

October 19th Pay Insurance ₦500 by cheque

October 24th Cash sales ₦500

October 25th Receive rent by cheque ₦1000

October 28th    Cash paid into bank ₦2,000

October 31st    paid wages by cash ₦500

Let’s work through another type of problem:

                 Butane is a ‘hydrocarbon’ compound containing only carbon and hydrogen. Butane is used as fuel in lighters. It’s empirical formula is C2H5, and it’s molar mass is 58.12 g/mole. Based on this data, what is the molecular formula of butane?

                 Begin by determining the empirical formula mass.

                 Next, divide the molar mass by the empirical formula mass.

                 Finally, multiply the empirical formula by this number.

    This results in a molecular formula of :

Putting all the steps together!

1.    A compound with the following mass percent composition has a molar mass (formula mass) of 60.10 g/mol. Find both the empirical formula and the molecular formula.

                                   39.97% C              13.41% H             46.62% N

2.    A compound was analyzed and found to contain the following percentages of the elements by mass: cobalt, 71.06%; oxygen, 28.94%. Determine the empirical formula.

3.    When 4.01 grams of mercury is strongly heated in air, the resulting oxide weighs 4.33 grams. Calculate the empirical formula of the resulting mercury oxide.

4.    A compound with empirical formula C2H5OH was analyzed and found to have a molar mass of approximately 90 g. What is the molecular formula of this compound?

5.    A 1.2569 gram sample of a new compound has been analyzed and found to contain the following masses of elements: carbon, 0.7238 g; hydrogen, 0.07088 g; nitrogen, 0.1407 g; and oxygen, 0.3214 g. Calculate the empirical formula of the compound.

    *Further analysis shows that the formula mass (molecular mass) is approximately 376-377 grams. Determine the molecular formula.

1. The molar mass of a compound is 126 g/mol, and it's empirical formula is C2H2O. What is compound's molecular formula?

2. A compound consist of 26.18g Si and 29.82g O. Calculate its empirical formula?

3. Calculate the empirical formula of the compound that consist of 70.4%F and 29.6%O.

1. You are the DBA in the service of the British Royal Museum. You need to update the database of all Britons that have been knighted in the past. You want to build in a validation of the data to find all these people.

   Which of the following metacharacter combinations would you use?

   	A.	'Sir .'
   	B.	'Sir +'
   	C.	'Sir ?1'
   	D.	'Sir EG*1'

2. ou query the database with this SQL statement:

   SELECT *

   FROM transaction;
   
   

   For which purpose was this statement created?

   	A.	to insert data into the TRANSACTION table
   	B.	to view the data in the TRANSACTION table
   	C.	to review the structure of the TRANSACTION table
   	D.	to delete selected data from the TRANSACTION table

3. The four phases that indicate the different phases of SQL statement execution are as follows:

   1. execute

   2. fetch

   3. parse

   4. bind

   Which option represents the correct sequence of events while executing a statement?

   	a.	1, 2, 3, 4
   	b.	2, 3, 4, 1
   	c.	3, 4, 1, 2
   	d.	4, 3, 1, 2

4. Which three statements about constraints are true? (Choose three.)

   	A.	Constraints only enforce rules at the table level.
   	B.	Constraints prevent rows with dependencies from being deleted.
   	C.	You must provide a name for each constraint at the time of its creation.
   	D.	Constraint names are not required to follow the standard object-naming rules.
   	E.	Constraints can be created at the same time as the table or after the table is created.