create table breedguides(
breed varchar(15),
gender char(1) check(gender in ('m', 'f')),
minheight integer check(minheight > 0),
maxheight integer check(maxheight > 0),
primary key(breed, gender)
);
create table contestants(
name varchar(30) primary key,
breed varchar(15) not null,
gender char(1) check(gender in ('m', 'f')) not null,
height integer check (height > 0) not null,
points integer check (points >= 0),
foreign key (breed, gender) references breedguides
);
create table contests(
contestID integer primary key,
dateOf date unique not null,
fstplace varchar(30) references contestants(name),
fstplcpts integer check (fstplcpts > 0) not null,
sndplace varchar(30) references contestants(name),
sndplcpts integer check (sndplcpts > 0) not null,
thdplace varchar(30) references contestants(name),
thdplcpts integer check (thdplcpts > 0) not null
);
-- now add the data to the table just created using a series of inserts
insert into breedguides
values
('collie', 'f', 22, 24) ,
('collie', 'm', 24, 26) ,
('beagle', 'f', null, 15) ,
The life expectancy of a male during the course of the past 100 years is approximately Criat Life Span Life Span 27,734 days, Use the table to the right to conduct a test using a = 0.10 to determine whether Justice Days (Dys) the evidence suggests that chief justices live longer than the general population of makes, A 27.143 32 261 Suggest a reason why the conclusion drawn may be flawed. 30.696 30 912 C 26,224 20 150 31,430 32,222 30 80 31.370 N 32 460 27 020 32,110 32.172 P 32.370 O A Do not reject the null hypothesis. There is sufficient evidence to conclude that the mean life span of males is longer than 30,565 days. Thus, there is sufficient evidence to indicate that chief walkes live longer than the general population of males. O B. Do not reject the null hypothesis. There is not sufficient evidence to conclude that the mean life span of males is longer than 27,7:34 days. Thus, there is not sufleient evidence to indicate that chief juanpes live longer than the gonenal population of males. O C. Reject the null hypothesis. There is suficient evidence to conclude that the mean life span of males is longer than 27,7:34 days. Thus, there is suficient evidence to indicate that chief juslens live longer than the ponoral population of males. O D. Reject the null hypothesis. There is not sufficient evidence to conclude that the mein life span of males is longer than 27,7:34 days, Thus, there is not sufficient evidence to indicate that chief justices Bir longer than the general population of males. Suggest a reason why the conclusion driven may be flawed. Choose the correct answer below. O A. The sample is not obtained using simple random sampling or from a randomized experiment. O B. The sample size is very large and the data are normaly distributed. Q C. The sampled values are not independent of each other. O D. The sample consists of outlionProgramming with R ( in R studio ), PLEASE ANSWER THE QUESTION WITH COMMENT and DETAIL explanation using R programming PLEASE UPLOAD R programming CODE 1. A product development engineer is interested in determining if the cotton weight in synthetic fiber affects the tensile strength, and he has run a completely randomised experiment with five levels of cotton weight percentage and five replicates. Test the hypothesis that cotton weight percentage in the fiber significantly affects the mean tensile strength or not at 5% and 1% level of significance. Weight Observed Tensile Strength (Ib/in?) Percentage N 3 5 of Cotton 15 7 7 15 11 9 20 12 17 12 18 18 25 14 18 18 19 19 30 19 25 22 19 23 35 7 10 11 15 11There is no direct intervention from the researcher. Allows for the study of cause and effect where ethically factors could not be manipulated. O Laboratory Experiment O Field Experiment O Correlational Study Natural Experiment Observational Study Secondary Data Analysis Survey Case Study Next Previous