An optional supplementary textbook is the OpenIntro Statistics, and you can read the concepts there.

Use the lab file WS4Practice to practice the Excel skills (includes an Excel hands-on video inside the spreadsheet as a link).

Use the file WS4Homework to demonstrate the Excel skills. Each of the six problems is worth 10 points, for a total of 60 points possible for this assignment.

Prb5

Z Test of Hypothesis for the Proportion DIRECTIONS: Arrival Delay (negatives mean it arrived early)

On time flights. A flight is on time if it arrives no later than 15 minutes after the scheduled arrival time. Test the claim that made by CNN that 79.5% of flights are on time. Use a .05 significance level. -32 How many flights are in this sample?

Data -25 (1 point)

Null Hypothesis p= Enter the hypothesis test amount. (1 point) -26

Level of Significance Enter alpha value. (1 point) -6

Number of Items of Interest Enter how many flights were on time. (1 point) 5 How many flights were on time?

Sample Size Enter the sample size. (1 point) -15 (1 point)

-17

Intermediate Calculations -36

Sample Proportion ERROR:#DIV/0! Access this helpful video: Video -29

Standard Error ERROR:#DIV/0! -18

Z Test Statistic ERROR:#DIV/0! -12

State the results and interpret the results here: -35

Two-Tail Test ( 4 points) 2

Lower Critical Value ERROR:#NUM! -33

Upper Critical value ERROR:#NUM! -5

p-Value ERROR:#DIV/0! 0

ERROR:#DIV/0! 0

-1

Lower-Tail Test These 2 sections are not needed in this problem because it is an equality test with 2 tails. -33

Lower Critical Value ERROR:#NUM! -5

p-Value ERROR:#DIV/0! -14

ERROR:#DIV/0! -39

-21

Upper-Tail Test -32

Upper Critical Value ERROR:#NUM! -5

p-Value ERROR:#DIV/0! -32

ERROR:#DIV/0! -13

-9

-19

49

-30

-23

14

-21

-32

11

-23

28

103

-19

-5

-46

13

-3

13

106

-34

-24

Prb6

DIRECTIONS: TEMP in F

t Test for the Hypothesis of the Mean Calculate sample mean and standard deviation from sample data.

Test the claim that mean body temperature of the population is 98.6 degrees as is commonly believed. 98.6 What is the mean temperature?

Data 98.6 (1 point)

Null Hypothesis m= Enter the hypothesis test amount. (1 point) 98

Level of Significance Enter alpha value. (1 point) 98

Sample Size Enter the sample size. (1 point) 99 What is the standard deviation?

Sample Mean Enter the sample mean. (1 point) 98.4 (1 point)

Sample Standard Deviation Enter the sample standard deviation. (1 point) 98.4

98.4

Intermediate Calculations Access this helpful video: Video 98.4

Standard Error of the Mean ERROR:#DIV/0! 98.6

Degrees of Freedom -1 98.6

t Test Statistic ERROR:#DIV/0! State the results and interpret the results here: 98.8

( 3 points) 98.6

Two-Tail Test 97

Lower Critical Value ERROR:#NUM! 97

Upper Critical Value ERROR:#NUM! 98.8

p-Value ERROR:#DIV/0! 97.6

ERROR:#DIV/0! 97.7

98.8

Calculations Area 98

For one-tailed tests: 98

TDIST value ERROR:#DIV/0! 98.3

1-TDIST value ERROR:#DIV/0! 98.5

97.3

Lower-Tail Test These 2 sections are not needed in this problem because it is an equality test with 2 tails. 98.7

Lower Critical Value ERROR:#NUM! 97.4

p-Value ERROR:#DIV/0! 98.9

ERROR:#DIV/0! 98.6

99.5

Upper-Tail Test 97.5

Upper Critical Value ERROR:#NUM! 97.3

p-Value ERROR:#DIV/0! 97.6

ERROR:#DIV/0! 98.2

99.6

98.7

99.4

98.2

98

98.6

98.6

97.2

98.4

98.6

98.2

98

97.8

98

98.4

98.6

98.6

97.8

99

96.5

97.6

98

96.9

97.6

97.1

97.9

98.4

97.3

98

97.5

97.6

98.2

98.5

98.8

98.7

97.8

98

97.1

97.4

99.4

98.4

98.6

98.4

98.5

98.6

98.3

98.7

98.8

99.1

98.6

97.9

98.8

98

98.7

98.5

98.9

98.4

98.6

97.1

97.9

98.8

98.7

97.6

98.2

99.2

97.8

98

98.4

97.8

98.4

97.4

98

97

Prb7

DIRECTIONS: Departure Delay (negatives mean it arrived early)

t Test for the Hypothesis of the Mean On time flights. A flight is on time if it arrives no later than 15 minutes after the scheduled arrival time. Test the claim that the mean departure delay time for all flights is less than 12.0 minutes. Use .01 level of significance. -2 How many flights are in this sample?

Data -1 (1 point)

Null Hypothesis m= Enter the hypothesis test amount. (1 point) -2

Level of Significance Enter alpha value. (1 point) 2

Sample Size Enter the sample size. (1 point) -2 What is the mean?

Sample Mean Enter the sample mean. (1 point) 0 (1 point)

Sample Standard Deviation Enter the sample standard deviation. (1 point) -2

-3

Intermediate Calculations -5 What is the standard deviation?

Standard Error of the Mean ERROR:#DIV/0! Access this helpful video: Video -4 (1 point)

Degrees of Freedom -1 2

t Test Statistic ERROR:#DIV/0! -2

22

Two-Tail Test This section is not needed in this problem because it is a lower tail test with 1 tail. -11

Lower Critical Value ERROR:#NUM! 7

Upper Critical Value ERROR:#NUM! 0

p-Value ERROR:#DIV/0! -5

ERROR:#DIV/0! 3

-8

Calculations Area 8

For one-tailed tests: -2

TDIST value ERROR:#DIV/0! -8

1-TDIST value ERROR:#DIV/0! State the results and interpret the results here: -3

-4

Lower-Tail Test ( 2 points) 19

Lower Critical Value ERROR:#NUM! -4

p-Value ERROR:#DIV/0! -5

ERROR:#DIV/0! -1

-4

Upper-Tail Test This section is not needed in this problem because it is a lower tail test with 1 tail. 73

Upper Critical Value ERROR:#NUM! 0

p-Value ERROR:#DIV/0! 1

ERROR:#DIV/0! 13

-1

-8

32

18

60

142

-1

-11

-1

47

13

12

123

1

4

Prb8

DIRECTIONS: Brain Volume (negatives mean it arrived early)

t Test for the Hypothesis of the Mean Brain volume. Test the claim that the mean brain volume for the population is equal to 1100 cm2. 963 How many readings are in this sample?

Data 1027 (1 point)

Null Hypothesis m= Enter the hypothesis test amount. (1 point) 1272

Level of Significance Enter alpha value. (1 point) 1079

Sample Size Enter the sample size. (1 point) 1070 What is the mean?

Sample Mean Enter the sample mean. (1 point) 1173 (1 point)

Sample Standard Deviation Enter the sample standard deviation. (1 point) 1067

1347

Intermediate Calculations 1100 What is the standard deviation?

Standard Error of the Mean ERROR:#DIV/0! Access this helpful video: Video 1204 (1 point)

Degrees of Freedom -1

t Test Statistic ERROR:#DIV/0!

State the results and interpret the results here:

Two-Tail Test

Lower Critical Value ERROR:#NUM! ( 2 points)

Upper Critical Value ERROR:#NUM!

p-Value ERROR:#DIV/0!

ERROR:#DIV/0!

Calculations Area

For one-tailed tests:

TDIST value ERROR:#DIV/0!

1-TDIST value ERROR:#DIV/0!

Lower-Tail Test This section is not needed in this problem because it is a 2-tail test.

Lower Critical Value ERROR:#NUM!

p-Value ERROR:#DIV/0!

ERROR:#DIV/0!

Upper-Tail Test This section is not needed in this problem because it is a 2-tail test.

Upper Critical Value ERROR:#NUM!

p-Value ERROR:#DIV/0!

ERROR:#DIV/0!

Prb9

DIRECTIONS: Systolic blood pressure (negatives mean it arrived early)

t Test for the Hypothesis of the Mean Blood pressure. Test the claim that the mean female population systolic blood pressure level is less than 120 mm Hg. Use a .05 level of significance. 122 How many readings are in this sample?

Data 120 (1 point)

Null Hypothesis m= Enter the hypothesis test amount. (1 point) 90

Level of Significance Enter alpha value. (1 point) 150

Sample Size Enter the sample size. (1 point) 132 What is the mean?

Sample Mean Enter the sample mean. (1 point) 88 (1 point)

Sample Standard Deviation Enter the sample standard deviation. (1 point) 100

114

Intermediate Calculations 94 What is the standard deviation?

Standard Error of the Mean ERROR:#DIV/0! Access this helpful video: Video 100 (1 point)

Degrees of Freedom -1 110

t Test Statistic ERROR:#DIV/0! 188

106

Two-Tail Test This section is not needed in this problem because it is a lower tail test with 1 tail. 130

Lower Critical Value ERROR:#NUM! 126

Upper Critical Value ERROR:#NUM! 90

p-Value ERROR:#DIV/0! 168

ERROR:#DIV/0! 110

98

Calculations Area 112

For one-tailed tests: 116

TDIST value ERROR:#DIV/0! 128

1-TDIST value ERROR:#DIV/0! State the results and interpret the results here: 116

112

Lower-Tail Test ( 2 points) 126

Lower Critical Value ERROR:#NUM! 94

p-Value ERROR:#DIV/0! 120

ERROR:#DIV/0! 94

120

Upper-Tail Test This section is not needed in this problem because it is a lower tail test with 1 tail. 148

Upper Critical Value ERROR:#NUM! 126

p-Value ERROR:#DIV/0! 126

ERROR:#DIV/0! 112

120

110

98

130

114

174

108

Prb10

DIRECTIONS: Voltage (negatives mean it arrived early)

t Test for the Hypothesis of the Mean Voltage. Test the claim that the mean voltage is 120 volts. Use .01 level of significance. 123.8 How many readings are in this sample?

Data 123.9 (1 point)

Null Hypothesis m= Enter the hypothesis test amount. (1 point) 123.9

Level of Significance Enter alpha value. (1 point) 123.3

Sample Size Enter the sample size. (1 point) 123.4 What is the mean?

Sample Mean Enter the sample mean. (1 point) 123.3 (1 point)

Sample Standard Deviation Enter the sample standard deviation. (1 point) 123.3

123.6

Intermediate Calculations 123.5 What is the standard deviation?

Standard Error of the Mean ERROR:#DIV/0! Access this helpful video: Video 123.5 (1 point)

Degrees of Freedom -1 123.5

t Test Statistic ERROR:#DIV/0! 123.7

State the results and interpret the results here: 123.6

Two-Tail Test 123.7

Lower Critical Value ERROR:#NUM! ( 2 points) 123.9

Upper Critical Value ERROR:#NUM! 124.0

p-Value ERROR:#DIV/0! 124.2

ERROR:#DIV/0! 123.9

123.8

Calculations Area 123.8

For one-tailed tests: 124.0

TDIST value ERROR:#DIV/0! 123.9

1-TDIST value ERROR:#DIV/0! 123.6

123.5

Lower-Tail Test This section is not needed in this problem because it is a 2-tail test. 123.4

Lower Critical Value ERROR:#NUM! 123.4

p-Value ERROR:#DIV/0! 123.4

ERROR:#DIV/0! 123.4

123.3

Upper-Tail Test This section is not needed in this problem because it is a 2-tail test. 123.3

Upper Critical Value ERROR:#NUM! 123.5

p-Value ERROR:#DIV/0! 123.6

ERROR:#DIV/0! 123.8

123.9

123.9

123.8

123.9

123.7

123.8

123.8

An optional supplementary textbook is the OpenIntro Statistics, and you can read the concepts there.

Use the lab file WS4Practice to practice the Excel skills (includes an Excel hands-on video inside the spreadsheet as a link).

Use the file WS4Homework to demonstrate the Excel skills. Each of the six problems is worth 10 points, for a total of 60 points possible for this assignment.

Prb5

Z Test of Hypothesis for the Proportion DIRECTIONS: Arrival Delay (negatives mean it arrived early)

On time flights. A flight is on time if it arrives no later than 15 minutes after the scheduled arrival time. Test the claim that made by CNN that 79.5% of flights are on time. Use a .05 significance level. -32 How many flights are in this sample?

Data -25 (1 point)

Null Hypothesis p= Enter the hypothesis test amount. (1 point) -26

Level of Significance Enter alpha value. (1 point) -6

Number of Items of Interest Enter how many flights were on time. (1 point) 5 How many flights were on time?

Sample Size Enter the sample size. (1 point) -15 (1 point)

-17

Intermediate Calculations -36

Sample Proportion ERROR:#DIV/0! Access this helpful video: Video -29

Standard Error ERROR:#DIV/0! -18

Z Test Statistic ERROR:#DIV/0! -12

State the results and interpret the results here: -35

Two-Tail Test ( 4 points) 2

Lower Critical Value ERROR:#NUM! -33

Upper Critical value ERROR:#NUM! -5

p-Value ERROR:#DIV/0! 0

ERROR:#DIV/0! 0

-1

Lower-Tail Test These 2 sections are not needed in this problem because it is an equality test with 2 tails. -33

Lower Critical Value ERROR:#NUM! -5

p-Value ERROR:#DIV/0! -14

ERROR:#DIV/0! -39

-21

Upper-Tail Test -32

Upper Critical Value ERROR:#NUM! -5

p-Value ERROR:#DIV/0! -32

ERROR:#DIV/0! -13

-9

-19

49

-30

-23

14

-21

-32

11

-23

28

103

-19

-5

-46

13

-3

13

106

-34

-24

Prb6

DIRECTIONS: TEMP in F

t Test for the Hypothesis of the Mean Calculate sample mean and standard deviation from sample data.

Test the claim that mean body temperature of the population is 98.6 degrees as is commonly believed. 98.6 What is the mean temperature?

Data 98.6 (1 point)

Null Hypothesis m= Enter the hypothesis test amount. (1 point) 98

Level of Significance Enter alpha value. (1 point) 98

Sample Size Enter the sample size. (1 point) 99 What is the standard deviation?

Sample Mean Enter the sample mean. (1 point) 98.4 (1 point)

Sample Standard Deviation Enter the sample standard deviation. (1 point) 98.4

98.4

Intermediate Calculations Access this helpful video: Video 98.4

Standard Error of the Mean ERROR:#DIV/0! 98.6

Degrees of Freedom -1 98.6

t Test Statistic ERROR:#DIV/0! State the results and interpret the results here: 98.8

( 3 points) 98.6

Two-Tail Test 97

Lower Critical Value ERROR:#NUM! 97

Upper Critical Value ERROR:#NUM! 98.8

p-Value ERROR:#DIV/0! 97.6

ERROR:#DIV/0! 97.7

98.8

Calculations Area 98

For one-tailed tests: 98

TDIST value ERROR:#DIV/0! 98.3

1-TDIST value ERROR:#DIV/0! 98.5

97.3

Lower-Tail Test These 2 sections are not needed in this problem because it is an equality test with 2 tails. 98.7

Lower Critical Value ERROR:#NUM! 97.4

p-Value ERROR:#DIV/0! 98.9

ERROR:#DIV/0! 98.6

99.5

Upper-Tail Test 97.5

Upper Critical Value ERROR:#NUM! 97.3

p-Value ERROR:#DIV/0! 97.6

ERROR:#DIV/0! 98.2

99.6

98.7

99.4

98.2

98

98.6

98.6

97.2

98.4

98.6

98.2

98

97.8

98

98.4

98.6

98.6

97.8

99

96.5

97.6

98

96.9

97.6

97.1

97.9

98.4

97.3

98

97.5

97.6

98.2

98.5

98.8

98.7

97.8

98

97.1

97.4

99.4

98.4

98.6

98.4

98.5

98.6

98.3

98.7

98.8

99.1

98.6

97.9

98.8

98

98.7

98.5

98.9

98.4

98.6

97.1

97.9

98.8

98.7

97.6

98.2

99.2

97.8

98

98.4

97.8

98.4

97.4

98

97

Prb7

DIRECTIONS: Departure Delay (negatives mean it arrived early)

t Test for the Hypothesis of the Mean On time flights. A flight is on time if it arrives no later than 15 minutes after the scheduled arrival time. Test the claim that the mean departure delay time for all flights is less than 12.0 minutes. Use .01 level of significance. -2 How many flights are in this sample?

Data -1 (1 point)

Null Hypothesis m= Enter the hypothesis test amount. (1 point) -2

Level of Significance Enter alpha value. (1 point) 2

Sample Size Enter the sample size. (1 point) -2 What is the mean?

Sample Mean Enter the sample mean. (1 point) 0 (1 point)

Sample Standard Deviation Enter the sample standard deviation. (1 point) -2

-3

Intermediate Calculations -5 What is the standard deviation?

Standard Error of the Mean ERROR:#DIV/0! Access this helpful video: Video -4 (1 point)

Degrees of Freedom -1 2

t Test Statistic ERROR:#DIV/0! -2

22

Two-Tail Test This section is not needed in this problem because it is a lower tail test with 1 tail. -11

Lower Critical Value ERROR:#NUM! 7

Upper Critical Value ERROR:#NUM! 0

p-Value ERROR:#DIV/0! -5

ERROR:#DIV/0! 3

-8

Calculations Area 8

For one-tailed tests: -2

TDIST value ERROR:#DIV/0! -8

1-TDIST value ERROR:#DIV/0! State the results and interpret the results here: -3

-4

Lower-Tail Test ( 2 points) 19

Lower Critical Value ERROR:#NUM! -4

p-Value ERROR:#DIV/0! -5

ERROR:#DIV/0! -1

-4

Upper-Tail Test This section is not needed in this problem because it is a lower tail test with 1 tail. 73

Upper Critical Value ERROR:#NUM! 0

p-Value ERROR:#DIV/0! 1

ERROR:#DIV/0! 13

-1

-8

32

18

60

142

-1

-11

-1

47

13

12

123

1

4

Prb8

DIRECTIONS: Brain Volume (negatives mean it arrived early)

t Test for the Hypothesis of the Mean Brain volume. Test the claim that the mean brain volume for the population is equal to 1100 cm2. 963 How many readings are in this sample?

Data 1027 (1 point)

Null Hypothesis m= Enter the hypothesis test amount. (1 point) 1272

Level of Significance Enter alpha value. (1 point) 1079

Sample Size Enter the sample size. (1 point) 1070 What is the mean?

Sample Mean Enter the sample mean. (1 point) 1173 (1 point)

Sample Standard Deviation Enter the sample standard deviation. (1 point) 1067

1347

Intermediate Calculations 1100 What is the standard deviation?

Standard Error of the Mean ERROR:#DIV/0! Access this helpful video: Video 1204 (1 point)

Degrees of Freedom -1

t Test Statistic ERROR:#DIV/0!

State the results and interpret the results here:

Two-Tail Test

Lower Critical Value ERROR:#NUM! ( 2 points)

Upper Critical Value ERROR:#NUM!

p-Value ERROR:#DIV/0!

ERROR:#DIV/0!

Calculations Area

For one-tailed tests:

TDIST value ERROR:#DIV/0!

1-TDIST value ERROR:#DIV/0!

Lower-Tail Test This section is not needed in this problem because it is a 2-tail test.

Lower Critical Value ERROR:#NUM!

p-Value ERROR:#DIV/0!

ERROR:#DIV/0!

Upper-Tail Test This section is not needed in this problem because it is a 2-tail test.

Upper Critical Value ERROR:#NUM!

p-Value ERROR:#DIV/0!

ERROR:#DIV/0!

Prb9

DIRECTIONS: Systolic blood pressure (negatives mean it arrived early)

t Test for the Hypothesis of the Mean Blood pressure. Test the claim that the mean female population systolic blood pressure level is less than 120 mm Hg. Use a .05 level of significance. 122 How many readings are in this sample?

Data 120 (1 point)

Null Hypothesis m= Enter the hypothesis test amount. (1 point) 90

Level of Significance Enter alpha value. (1 point) 150

Sample Size Enter the sample size. (1 point) 132 What is the mean?

Sample Mean Enter the sample mean. (1 point) 88 (1 point)

Sample Standard Deviation Enter the sample standard deviation. (1 point) 100

114

Intermediate Calculations 94 What is the standard deviation?

Standard Error of the Mean ERROR:#DIV/0! Access this helpful video: Video 100 (1 point)

Degrees of Freedom -1 110

t Test Statistic ERROR:#DIV/0! 188

106

Two-Tail Test This section is not needed in this problem because it is a lower tail test with 1 tail. 130

Lower Critical Value ERROR:#NUM! 126

Upper Critical Value ERROR:#NUM! 90

p-Value ERROR:#DIV/0! 168

ERROR:#DIV/0! 110

98

Calculations Area 112

For one-tailed tests: 116

TDIST value ERROR:#DIV/0! 128

1-TDIST value ERROR:#DIV/0! State the results and interpret the results here: 116

112

Lower-Tail Test ( 2 points) 126

Lower Critical Value ERROR:#NUM! 94

p-Value ERROR:#DIV/0! 120

ERROR:#DIV/0! 94

120

Upper-Tail Test This section is not needed in this problem because it is a lower tail test with 1 tail. 148

Upper Critical Value ERROR:#NUM! 126

p-Value ERROR:#DIV/0! 126

ERROR:#DIV/0! 112

120

110

98

130

114

174

108

Prb10

DIRECTIONS: Voltage (negatives mean it arrived early)

t Test for the Hypothesis of the Mean Voltage. Test the claim that the mean voltage is 120 volts. Use .01 level of significance. 123.8 How many readings are in this sample?

Data 123.9 (1 point)

Null Hypothesis m= Enter the hypothesis test amount. (1 point) 123.9

Level of Significance Enter alpha value. (1 point) 123.3

Sample Size Enter the sample size. (1 point) 123.4 What is the mean?

Sample Mean Enter the sample mean. (1 point) 123.3 (1 point)

Sample Standard Deviation Enter the sample standard deviation. (1 point) 123.3

123.6

Intermediate Calculations 123.5 What is the standard deviation?

Standard Error of the Mean ERROR:#DIV/0! Access this helpful video: Video 123.5 (1 point)

Degrees of Freedom -1 123.5

t Test Statistic ERROR:#DIV/0! 123.7

State the results and interpret the results here: 123.6

Two-Tail Test 123.7

Lower Critical Value ERROR:#NUM! ( 2 points) 123.9

Upper Critical Value ERROR:#NUM! 124.0

p-Value ERROR:#DIV/0! 124.2

ERROR:#DIV/0! 123.9

123.8

Calculations Area 123.8

For one-tailed tests: 124.0

TDIST value ERROR:#DIV/0! 123.9

1-TDIST value ERROR:#DIV/0! 123.6

123.5

Lower-Tail Test This section is not needed in this problem because it is a 2-tail test. 123.4

Lower Critical Value ERROR:#NUM! 123.4

p-Value ERROR:#DIV/0! 123.4

ERROR:#DIV/0! 123.4

123.3

Upper-Tail Test This section is not needed in this problem because it is a 2-tail test. 123.3

Upper Critical Value ERROR:#NUM! 123.5

p-Value ERROR:#DIV/0! 123.6

ERROR:#DIV/0! 123.8

123.9

123.9

123.8

123.9

123.7

123.8

123.8

An optional supplementary textbook is the OpenIntro Statistics, and you can read the concepts there.

Use the lab file WS4Practice to practice the Excel skills (includes an Excel hands-on video inside the spreadsheet as a link).

Use the file WS4Homework to demonstrate the Excel skills. Each of the six problems is worth 10 points, for a total of 60 points possible for this assignment.

Prb5

Z Test of Hypothesis for the Proportion DIRECTIONS: Arrival Delay (negatives mean it arrived early)

On time flights. A flight is on time if it arrives no later than 15 minutes after the scheduled arrival time. Test the claim that made by CNN that 79.5% of flights are on time. Use a .05 significance level. -32 How many flights are in this sample?

Data -25 (1 point)

Null Hypothesis p= Enter the hypothesis test amount. (1 point) -26

Level of Significance Enter alpha value. (1 point) -6

Number of Items of Interest Enter how many flights were on time. (1 point) 5 How many flights were on time?

Sample Size Enter the sample size. (1 point) -15 (1 point)

-17

Intermediate Calculations -36

Sample Proportion ERROR:#DIV/0! Access this helpful video: Video -29

Standard Error ERROR:#DIV/0! -18

Z Test Statistic ERROR:#DIV/0! -12

State the results and interpret the results here: -35

Two-Tail Test ( 4 points) 2

Lower Critical Value ERROR:#NUM! -33

Upper Critical value ERROR:#NUM! -5

p-Value ERROR:#DIV/0! 0

ERROR:#DIV/0! 0

-1

Lower-Tail Test These 2 sections are not needed in this problem because it is an equality test with 2 tails. -33

Lower Critical Value ERROR:#NUM! -5

p-Value ERROR:#DIV/0! -14

ERROR:#DIV/0! -39

-21

Upper-Tail Test -32

Upper Critical Value ERROR:#NUM! -5

p-Value ERROR:#DIV/0! -32

ERROR:#DIV/0! -13

-9

-19

49

-30

-23

14

-21

-32

11

-23

28

103

-19

-5

-46

13

-3

13

106

-34

-24

Prb6

DIRECTIONS: TEMP in F

t Test for the Hypothesis of the Mean Calculate sample mean and standard deviation from sample data.

Test the claim that mean body temperature of the population is 98.6 degrees as is commonly believed. 98.6 What is the mean temperature?

Data 98.6 (1 point)

Null Hypothesis m= Enter the hypothesis test amount. (1 point) 98

Level of Significance Enter alpha value. (1 point) 98

Sample Size Enter the sample size. (1 point) 99 What is the standard deviation?

Sample Mean Enter the sample mean. (1 point) 98.4 (1 point)

Sample Standard Deviation Enter the sample standard deviation. (1 point) 98.4

98.4

Intermediate Calculations Access this helpful video: Video 98.4

Standard Error of the Mean ERROR:#DIV/0! 98.6

Degrees of Freedom -1 98.6

t Test Statistic ERROR:#DIV/0! State the results and interpret the results here: 98.8

( 3 points) 98.6

Two-Tail Test 97

Lower Critical Value ERROR:#NUM! 97

Upper Critical Value ERROR:#NUM! 98.8

p-Value ERROR:#DIV/0! 97.6

ERROR:#DIV/0! 97.7

98.8

Calculations Area 98

For one-tailed tests: 98

TDIST value ERROR:#DIV/0! 98.3

1-TDIST value ERROR:#DIV/0! 98.5

97.3

Lower-Tail Test These 2 sections are not needed in this problem because it is an equality test with 2 tails. 98.7

Lower Critical Value ERROR:#NUM! 97.4

p-Value ERROR:#DIV/0! 98.9

ERROR:#DIV/0! 98.6

99.5

Upper-Tail Test 97.5

Upper Critical Value ERROR:#NUM! 97.3

p-Value ERROR:#DIV/0! 97.6

ERROR:#DIV/0! 98.2

99.6

98.7

99.4

98.2

98

98.6

98.6

97.2

98.4

98.6

98.2

98

97.8

98

98.4

98.6

98.6

97.8

99

96.5

97.6

98

96.9

97.6

97.1

97.9

98.4

97.3

98

97.5

97.6

98.2

98.5

98.8

98.7

97.8

98

97.1

97.4

99.4

98.4

98.6

98.4

98.5

98.6

98.3

98.7

98.8

99.1

98.6

97.9

98.8

98

98.7

98.5

98.9

98.4

98.6

97.1

97.9

98.8

98.7

97.6

98.2

99.2

97.8

98

98.4

97.8

98.4

97.4

98

97

Prb7

DIRECTIONS: Departure Delay (negatives mean it arrived early)

t Test for the Hypothesis of the Mean On time flights. A flight is on time if it arrives no later than 15 minutes after the scheduled arrival time. Test the claim that the mean departure delay time for all flights is less than 12.0 minutes. Use .01 level of significance. -2 How many flights are in this sample?

Data -1 (1 point)

Null Hypothesis m= Enter the hypothesis test amount. (1 point) -2

Level of Significance Enter alpha value. (1 point) 2

Sample Size Enter the sample size. (1 point) -2 What is the mean?

Sample Mean Enter the sample mean. (1 point) 0 (1 point)

Sample Standard Deviation Enter the sample standard deviation. (1 point) -2

-3

Intermediate Calculations -5 What is the standard deviation?

Standard Error of the Mean ERROR:#DIV/0! Access this helpful video: Video -4 (1 point)

Degrees of Freedom -1 2

t Test Statistic ERROR:#DIV/0! -2

22

Two-Tail Test This section is not needed in this problem because it is a lower tail test with 1 tail. -11

Lower Critical Value ERROR:#NUM! 7

Upper Critical Value ERROR:#NUM! 0

p-Value ERROR:#DIV/0! -5

ERROR:#DIV/0! 3

-8

Calculations Area 8

For one-tailed tests: -2

TDIST value ERROR:#DIV/0! -8

1-TDIST value ERROR:#DIV/0! State the results and interpret the results here: -3

-4

Lower-Tail Test ( 2 points) 19

Lower Critical Value ERROR:#NUM! -4

p-Value ERROR:#DIV/0! -5

ERROR:#DIV/0! -1

-4

Upper-Tail Test This section is not needed in this problem because it is a lower tail test with 1 tail. 73

Upper Critical Value ERROR:#NUM! 0

p-Value ERROR:#DIV/0! 1

ERROR:#DIV/0! 13

-1

-8

32

18

60

142

-1

-11

-1

47

13

12

123

1

4

Prb8

DIRECTIONS: Brain Volume (negatives mean it arrived early)

t Test for the Hypothesis of the Mean Brain volume. Test the claim that the mean brain volume for the population is equal to 1100 cm2. 963 How many readings are in this sample?

Data 1027 (1 point)

Null Hypothesis m= Enter the hypothesis test amount. (1 point) 1272

Level of Significance Enter alpha value. (1 point) 1079

Sample Size Enter the sample size. (1 point) 1070 What is the mean?

Sample Mean Enter the sample mean. (1 point) 1173 (1 point)

Sample Standard Deviation Enter the sample standard deviation. (1 point) 1067

1347

Intermediate Calculations 1100 What is the standard deviation?

Standard Error of the Mean ERROR:#DIV/0! Access this helpful video: Video 1204 (1 point)

Degrees of Freedom -1

t Test Statistic ERROR:#DIV/0!

State the results and interpret the results here:

Two-Tail Test

Lower Critical Value ERROR:#NUM! ( 2 points)

Upper Critical Value ERROR:#NUM!

p-Value ERROR:#DIV/0!

ERROR:#DIV/0!

Calculations Area

For one-tailed tests:

TDIST value ERROR:#DIV/0!

1-TDIST value ERROR:#DIV/0!

Lower-Tail Test This section is not needed in this problem because it is a 2-tail test.

Lower Critical Value ERROR:#NUM!

p-Value ERROR:#DIV/0!

ERROR:#DIV/0!

Upper-Tail Test This section is not needed in this problem because it is a 2-tail test.

Upper Critical Value ERROR:#NUM!

p-Value ERROR:#DIV/0!

ERROR:#DIV/0!

Prb9

DIRECTIONS: Systolic blood pressure (negatives mean it arrived early)

t Test for the Hypothesis of the Mean Blood pressure. Test the claim that the mean female population systolic blood pressure level is less than 120 mm Hg. Use a .05 level of significance. 122 How many readings are in this sample?

Data 120 (1 point)

Null Hypothesis m= Enter the hypothesis test amount. (1 point) 90

Level of Significance Enter alpha value. (1 point) 150

Sample Size Enter the sample size. (1 point) 132 What is the mean?

Sample Mean Enter the sample mean. (1 point) 88 (1 point)

Sample Standard Deviation Enter the sample standard deviation. (1 point) 100

114

Intermediate Calculations 94 What is the standard deviation?

Standard Error of the Mean ERROR:#DIV/0! Access this helpful video: Video 100 (1 point)

Degrees of Freedom -1 110

t Test Statistic ERROR:#DIV/0! 188

106

Two-Tail Test This section is not needed in this problem because it is a lower tail test with 1 tail. 130

Lower Critical Value ERROR:#NUM! 126

Upper Critical Value ERROR:#NUM! 90

p-Value ERROR:#DIV/0! 168

ERROR:#DIV/0! 110

98

Calculations Area 112

For one-tailed tests: 116

TDIST value ERROR:#DIV/0! 128

1-TDIST value ERROR:#DIV/0! State the results and interpret the results here: 116

112

Lower-Tail Test ( 2 points) 126

Lower Critical Value ERROR:#NUM! 94

p-Value ERROR:#DIV/0! 120

ERROR:#DIV/0! 94

120

Upper-Tail Test This section is not needed in this problem because it is a lower tail test with 1 tail. 148

Upper Critical Value ERROR:#NUM! 126

p-Value ERROR:#DIV/0! 126

ERROR:#DIV/0! 112

120

110

98

130

114

174

108

Prb10

DIRECTIONS: Voltage (negatives mean it arrived early)

t Test for the Hypothesis of the Mean Voltage. Test the claim that the mean voltage is 120 volts. Use .01 level of significance. 123.8 How many readings are in this sample?

Data 123.9 (1 point)

Null Hypothesis m= Enter the hypothesis test amount. (1 point) 123.9

Level of Significance Enter alpha value. (1 point) 123.3

Sample Size Enter the sample size. (1 point) 123.4 What is the mean?

Sample Mean Enter the sample mean. (1 point) 123.3 (1 point)

Sample Standard Deviation Enter the sample standard deviation. (1 point) 123.3

123.6

Intermediate Calculations 123.5 What is the standard deviation?

Standard Error of the Mean ERROR:#DIV/0! Access this helpful video: Video 123.5 (1 point)

Degrees of Freedom -1 123.5

t Test Statistic ERROR:#DIV/0! 123.7

State the results and interpret the results here: 123.6

Two-Tail Test 123.7

Lower Critical Value ERROR:#NUM! ( 2 points) 123.9

Upper Critical Value ERROR:#NUM! 124.0

p-Value ERROR:#DIV/0! 124.2

ERROR:#DIV/0! 123.9

123.8

Calculations Area 123.8

For one-tailed tests: 124.0

TDIST value ERROR:#DIV/0! 123.9

1-TDIST value ERROR:#DIV/0! 123.6

123.5

Lower-Tail Test This section is not needed in this problem because it is a 2-tail test. 123.4

Lower Critical Value ERROR:#NUM! 123.4

p-Value ERROR:#DIV/0! 123.4

ERROR:#DIV/0! 123.4

123.3

Upper-Tail Test This section is not needed in this problem because it is a 2-tail test. 123.3

Upper Critical Value ERROR:#NUM! 123.5

p-Value ERROR:#DIV/0! 123.6

ERROR:#DIV/0! 123.8

123.9

123.9

123.8

123.9

123.7

123.8

123.8

Use the lab file WS4Practice to practice the Excel skills (includes an Excel hands-on video inside the spreadsheet as a link).

Use the file WS4Homework to demonstrate the Excel skills. Each of the six problems is worth 10 points, for a total of 60 points possible for this assignment.

Prb5

Z Test of Hypothesis for the Proportion DIRECTIONS: Arrival Delay (negatives mean it arrived early)

Data -25 (1 point)

Null Hypothesis p= Enter the hypothesis test amount. (1 point) -26

Level of Significance Enter alpha value. (1 point) -6

Sample Size Enter the sample size. (1 point) -15 (1 point)

-17

Intermediate Calculations -36

Sample Proportion ERROR:#DIV/0! Access this helpful video: Video -29

Standard Error ERROR:#DIV/0! -18

Z Test Statistic ERROR:#DIV/0! -12

State the results and interpret the results here: -35

Two-Tail Test ( 4 points) 2

Lower Critical Value ERROR:#NUM! -33

Upper Critical value ERROR:#NUM! -5

p-Value ERROR:#DIV/0! 0

ERROR:#DIV/0! 0

-1

Lower Critical Value ERROR:#NUM! -5

p-Value ERROR:#DIV/0! -14

ERROR:#DIV/0! -39

-21

Upper-Tail Test -32

Upper Critical Value ERROR:#NUM! -5

p-Value ERROR:#DIV/0! -32

ERROR:#DIV/0! -13

-9

-19

49

-30

-23

14

-21

-32

11

-23

28

103

-19

-5

-46

13

-3

13

106

-34

-24

Prb6

DIRECTIONS: TEMP in F

Test the claim that mean body temperature of the population is 98.6 degrees as is commonly believed. 98.6 What is the mean temperature?

Data 98.6 (1 point)

Null Hypothesis m= Enter the hypothesis test amount. (1 point) 98

Level of Significance Enter alpha value. (1 point) 98

Sample Size Enter the sample size. (1 point) 99 What is the standard deviation?

Sample Mean Enter the sample mean. (1 point) 98.4 (1 point)

Sample Standard Deviation Enter the sample standard deviation. (1 point) 98.4

98.4

Intermediate Calculations Access this helpful video: Video 98.4

Standard Error of the Mean ERROR:#DIV/0! 98.6

Degrees of Freedom -1 98.6

t Test Statistic ERROR:#DIV/0! State the results and interpret the results here: 98.8

( 3 points) 98.6

Two-Tail Test 97

Lower Critical Value ERROR:#NUM! 97

Upper Critical Value ERROR:#NUM! 98.8

p-Value ERROR:#DIV/0! 97.6

ERROR:#DIV/0! 97.7

98.8

Calculations Area 98

For one-tailed tests: 98

TDIST value ERROR:#DIV/0! 98.3

1-TDIST value ERROR:#DIV/0! 98.5

97.3

Lower Critical Value ERROR:#NUM! 97.4

p-Value ERROR:#DIV/0! 98.9

ERROR:#DIV/0! 98.6

99.5

Upper-Tail Test 97.5

Upper Critical Value ERROR:#NUM! 97.3

p-Value ERROR:#DIV/0! 97.6

ERROR:#DIV/0! 98.2

99.6

98.7

99.4

98.2

98

98.6

98.6

97.2

98.4

98.6

98.2

98

97.8

98

98.4

98.6

98.6

97.8

99

96.5

97.6

98

96.9

97.6

97.1

97.9

98.4

97.3

98

97.5

97.6

98.2

98.5

98.8

98.7

97.8

98

97.1

97.4

99.4

98.4

98.6

98.4

98.5

98.6

98.3

98.7

98.8

99.1

98.6

97.9

98.8

98

98.7

98.5

98.9

98.4

98.6

97.1

97.9

98.8

98.7

97.6

98.2

99.2

97.8

98

98.4

97.8

98.4

97.4

98

97

Prb7

DIRECTIONS: Departure Delay (negatives mean it arrived early)

Data -1 (1 point)

Null Hypothesis m= Enter the hypothesis test amount. (1 point) -2

Level of Significance Enter alpha value. (1 point) 2

Sample Size Enter the sample size. (1 point) -2 What is the mean?

Sample Mean Enter the sample mean. (1 point) 0 (1 point)

Sample Standard Deviation Enter the sample standard deviation. (1 point) -2

-3

Intermediate Calculations -5 What is the standard deviation?

Standard Error of the Mean ERROR:#DIV/0! Access this helpful video: Video -4 (1 point)

Degrees of Freedom -1 2

t Test Statistic ERROR:#DIV/0! -2

22

Lower Critical Value ERROR:#NUM! 7

Upper Critical Value ERROR:#NUM! 0

p-Value ERROR:#DIV/0! -5

ERROR:#DIV/0! 3

-8

Calculations Area 8

For one-tailed tests: -2

TDIST value ERROR:#DIV/0! -8

1-TDIST value ERROR:#DIV/0! State the results and interpret the results here: -3

-4

Lower-Tail Test ( 2 points) 19

Lower Critical Value ERROR:#NUM! -4

p-Value ERROR:#DIV/0! -5

ERROR:#DIV/0! -1

-4

Upper Critical Value ERROR:#NUM! 0

p-Value ERROR:#DIV/0! 1

ERROR:#DIV/0! 13

-1

-8

32

18

60

142

-1

-11

-1

47

13

12

123

1

4

Prb8

DIRECTIONS: Brain Volume (negatives mean it arrived early)

Data 1027 (1 point)

Null Hypothesis m= Enter the hypothesis test amount. (1 point) 1272

Level of Significance Enter alpha value. (1 point) 1079

Sample Size Enter the sample size. (1 point) 1070 What is the mean?

Sample Mean Enter the sample mean. (1 point) 1173 (1 point)

Sample Standard Deviation Enter the sample standard deviation. (1 point) 1067

1347

Intermediate Calculations 1100 What is the standard deviation?

Standard Error of the Mean ERROR:#DIV/0! Access this helpful video: Video 1204 (1 point)

Degrees of Freedom -1

t Test Statistic ERROR:#DIV/0!

State the results and interpret the results here:

Two-Tail Test

Lower Critical Value ERROR:#NUM! ( 2 points)

Upper Critical Value ERROR:#NUM!

p-Value ERROR:#DIV/0!

ERROR:#DIV/0!

Calculations Area

For one-tailed tests:

TDIST value ERROR:#DIV/0!

1-TDIST value ERROR:#DIV/0!

Lower-Tail Test This section is not needed in this problem because it is a 2-tail test.

Lower Critical Value ERROR:#NUM!

p-Value ERROR:#DIV/0!

ERROR:#DIV/0!

Upper-Tail Test This section is not needed in this problem because it is a 2-tail test.

Upper Critical Value ERROR:#NUM!

p-Value ERROR:#DIV/0!

ERROR:#DIV/0!

Prb9

DIRECTIONS: Systolic blood pressure (negatives mean it arrived early)

Data 120 (1 point)

Null Hypothesis m= Enter the hypothesis test amount. (1 point) 90

Level of Significance Enter alpha value. (1 point) 150

Sample Size Enter the sample size. (1 point) 132 What is the mean?

Sample Mean Enter the sample mean. (1 point) 88 (1 point)

Sample Standard Deviation Enter the sample standard deviation. (1 point) 100

114

Intermediate Calculations 94 What is the standard deviation?

Standard Error of the Mean ERROR:#DIV/0! Access this helpful video: Video 100 (1 point)

Degrees of Freedom -1 110

t Test Statistic ERROR:#DIV/0! 188

106

Lower Critical Value ERROR:#NUM! 126

Upper Critical Value ERROR:#NUM! 90

p-Value ERROR:#DIV/0! 168

ERROR:#DIV/0! 110

98

Calculations Area 112

For one-tailed tests: 116

TDIST value ERROR:#DIV/0! 128

1-TDIST value ERROR:#DIV/0! State the results and interpret the results here: 116

112

Lower-Tail Test ( 2 points) 126

Lower Critical Value ERROR:#NUM! 94

p-Value ERROR:#DIV/0! 120

ERROR:#DIV/0! 94

120

Upper Critical Value ERROR:#NUM! 126

p-Value ERROR:#DIV/0! 126

ERROR:#DIV/0! 112

120

110

98

130

114

174

108

Prb10

DIRECTIONS: Voltage (negatives mean it arrived early)

Data 123.9 (1 point)

Null Hypothesis m= Enter the hypothesis test amount. (1 point) 123.9

Level of Significance Enter alpha value. (1 point) 123.3

Sample Size Enter the sample size. (1 point) 123.4 What is the mean?

Sample Mean Enter the sample mean. (1 point) 123.3 (1 point)

Sample Standard Deviation Enter the sample standard deviation. (1 point) 123.3

123.6

Intermediate Calculations 123.5 What is the standard deviation?

Standard Error of the Mean ERROR:#DIV/0! Access this helpful video: Video 123.5 (1 point)

Degrees of Freedom -1 123.5

t Test Statistic ERROR:#DIV/0! 123.7

State the results and interpret the results here: 123.6

Two-Tail Test 123.7

Lower Critical Value ERROR:#NUM! ( 2 points) 123.9

Upper Critical Value ERROR:#NUM! 124.0

p-Value ERROR:#DIV/0! 124.2

ERROR:#DIV/0! 123.9

123.8

Calculations Area 123.8

For one-tailed tests: 124.0

TDIST value ERROR:#DIV/0! 123.9

1-TDIST value ERROR:#DIV/0! 123.6

123.5

Lower-Tail Test This section is not needed in this problem because it is a 2-tail test. 123.4

Lower Critical Value ERROR:#NUM! 123.4

p-Value ERROR:#DIV/0! 123.4

ERROR:#DIV/0! 123.4

123.3

Upper-Tail Test This section is not needed in this problem because it is a 2-tail test. 123.3

Upper Critical Value ERROR:#NUM! 123.5

p-Value ERROR:#DIV/0! 123.6

ERROR:#DIV/0! 123.8

123.9

123.9

123.8

123.9

123.7

123.8

123.8