An airline's data indicate that this past year, the average time it takes to board their flights is 45 minutes. The airline is considering changing their boarding procedures to reduce the boarding time for travelers. The new procedures were implemented and the boarding times for a random sample of 22 customers was taken to determine if there was a statistically significant decrease in boarding times at a= 0.10 with z = - 0.89 and t= - 1.07. Find the p-value using Excel. (give answer to 4 decimal places with no spaces)

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.1: Measures Of Center
Problem 4GP
icon
Related questions
Question
Check my work
An airline's data indicate that this past year, the average time it takes to board their flights is 45 minutes. The airline is considering changing their
boarding procedures to reduce the boarding time for travelers. The new procedures were implemented and the boarding times for a random sample
of 22 customers was taken to determine if there was a statistically significant decrease in boarding times at a= O.10 with z = -0.89 and t = - 1.07. Find
the p-value using Excel. (give answer to 4 decimal places with no spaces)
Transcribed Image Text:Check my work An airline's data indicate that this past year, the average time it takes to board their flights is 45 minutes. The airline is considering changing their boarding procedures to reduce the boarding time for travelers. The new procedures were implemented and the boarding times for a random sample of 22 customers was taken to determine if there was a statistically significant decrease in boarding times at a= O.10 with z = -0.89 and t = - 1.07. Find the p-value using Excel. (give answer to 4 decimal places with no spaces)
Expert Solution
Step 1

Given that

n =22 , z = -0.89 , t = -1.07

P value = ?

 

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill