Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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) );

image text in transcribedimage text in transcribed

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) ,

image text in transcribedimage text in transcribedimage text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Discrete Mathematics

Authors: Gary Chartrand, Ping Zhang

1st Edition

1478616261, 9781478616269

More Books

Students also viewed these Mathematics questions

Question

Differentiate y = e ^ ( 2 x ) * sin ( 3 x ) .

Answered: 1 week ago

Question

Always show respect for the other person or persons.

Answered: 1 week ago

Question

Self-awareness is linked to the businesss results.

Answered: 1 week ago

Question

1. Too reflect on self-management

Answered: 1 week ago