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