Lodging, Car Rental, and Meal Taxes ($) Formula =AVERAGE(A2:A201) 20.58 Sample Mean (2 decimals) 41.91 21.13 64.47 Standard Deviation 8.50 58.21 59.49 Confidence Level 0.95 24.74 38.96 Sigfinicance Level (Alpha) 0.05 #N/A 53.22 44.61 Sample Size 200 #N/A 41.23 47.37 Margin of Error (2 decimals) 2.60 =CONFIDENCE.NORM(D8,D4,D2) 48.66 C.I. Lower Limit (2 decimals) C.I. Upper Limit (2 decimals) 22.21 39.31 =D2-D12 44.26 44.51 =D2+D12 35.35 62.76
Lodging, Car Rental, and Meal Taxes ($) Formula =AVERAGE(A2:A201) 20.58 Sample Mean (2 decimals) 41.91 21.13 64.47 Standard Deviation 8.50 58.21 59.49 Confidence Level 0.95 24.74 38.96 Sigfinicance Level (Alpha) 0.05 #N/A 53.22 44.61 Sample Size 200 #N/A 41.23 47.37 Margin of Error (2 decimals) 2.60 =CONFIDENCE.NORM(D8,D4,D2) 48.66 C.I. Lower Limit (2 decimals) C.I. Upper Limit (2 decimals) 22.21 39.31 =D2-D12 44.26 44.51 =D2+D12 35.35 62.76
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.5: Comparing Sets Of Data
Problem 13PPS
Related questions
Topic Video
Question
In an attempt to asses total daily travel taxes in various cities, the Global Business Travel Association conducted a study of daily travel taxes on lodging, rental cars, and meals
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill