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 In an attempt to assess total daily travel taxes in various cities, the Global business Travel Association conducted a study of daily travel taxes on lodging, rental car, andmeals. The data consistent with the findings of the study for business travel to Chicago are contained in the Excel Online file below. Construct a spreadsheet to answer thefollowing questions.Open spreadsheetAssume the population standard deviation is known to be $8.50 and develop a 95% confidence interval of the population mean total daily travel taxes for Chicago. Roundyour answer to two decimal places.(2439.3143.06 Lodging, Car Rental, andMeal Taxes ($)20.58FormulaSample Mean (2 decimals)41.91=AVERAGE(A2:A201)21.1364.47Standard Deviation8.5058.2159.49Confidence Level0.9524.7438.96Sigfinicance Level (Alpha)0.05#N/A53.2244.61Sample Size200#N/A41.2347.37Margin of Error (2 decimals)2.60=CONFIDENCE.NORM(D8,D4,D2)48.66C.I. Lower Limit (2 decimals)C.I. Upper Limit (2 decimals)22.2139.31=D2-D1244.2644.51=D2+D1235.3562.7653.80

Name: In an attempt to asses total daily travel taxes in various cities, the
Uploaded: 2024-03-20T07:07:37.000Z
Channel: Bartleby
Description: 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 In an attempt to assess total daily travel taxes in various cities, t