Question TwoQuestion Three Appendix A

An experiment is performed to calculate the average weight of the $62$ students in the

Data Exploration class.

There is insufficient time to weigh every student so a random sampling technique is

performed.

The average weight of $5$ students $\{55,63,67,50,65\}$ measured is calculated to be

$60Kgs.$

Answer the following sub$-$questions a$)$ to d$)$ in relation to the data set of class weights.

a$)$ Identify the number of people in the population.

b$)$ Identify the number of people in the sample.

$(2$ marks$)$

$(3$ marks$)$

c$)$ Assuming that the Central Limit Theory applies to this experiment, estimate the

class average weight at a $95\%$ confidence.

$(10$ marks$)$

d$)$ Explain the origins of standard error and calculate the standard error for the

experiment.

$(10$ marks$)$

$($Total $25$ marks$)$

The following Employee table records the hours an employee spends working for a

department each week in SQLite:

CREATE TABLE Employee $($

PPSN INTEGER not null PRIMARY KEY,

name TEXT$(20)$ not null,

age INTEGER not null,

salary INTEGER not null,

;

a$)$ Write a valid SQL statement to add an employee into the Employee table.

$(9$ Marks$)$

b$)$ Identify three issues with the assigned data types declared in relation to the

sample case provided below.

H$12345,$ John Kelly, $23,30000\}$

$(6$ Marks$)$

c$)$ Identify the correct data types for storing of the variables in the table.

H$12345,$ John Kelly, $23,30000\}$

$(3$ Marks$)$

d$)$ Provide the SQLite code to delete the table.

$(4$ Marks$)$

e$)$ Identify one issue with the original assigned data types declared in the table

Employee in relation to the proposed wish of the company to prepare an average

wages calculation.

$(3$ Marks$)$

$($Total $25$ marks$)$