lenovo AutoSave Off IntHotels Read-Only Excel a Search or call File Home Insert Draw Page Layout Formulas Data Review View Help Search XCut Times New Roman A A 11 e Wrap Text Number Normal Bad 旧Copy V Paste BI U A- Conditional Format as Good Formatting Table $ -% 9 030 Merge & Center V Y Neutral Format Painter Clipboard Font Alignment Number Styles F18 X A B C D E F G H 1 European City 2 Ljubljana 3 Geneva Change in Hotel Costs U.S. City Birmingham Pittsburgh Indianapolis Change in Hotel Costs European City Change in hotel costs Belgrade Tblisi U.S City New York City Orlando Change in hotel costs -0.009 0.074 -0.016 0.043 0.000 0.089 0.052 0.071 4 Zagreb 5 Stockholm 0.060 Zagreb Sarajevo St Petersburg -0.013 San Jose Atlanta -0.008 0.079 Norfolk 0.041 0.070 0.083 0.000 6 Tirana 0.082 Boston 0.071 0.077 Dallas 0.106 7 Riga 8 Istanbul 9 Bucharest 0.076 Winston-Salem Cleveland Kiev 0.074 0.012 0.015 0.021 Stockton Tulsa Glasgow Split -0.004 0.021 0.102 0.073 Laredo Baton Rouge 0.055 0.024 0.089 10 Budapest 11 Minsk 0.045 Jacksonville Corpus Christi 0.057 Sofia 0.088 0.057 0.023 Minneapolis Portland Amsterdam 0.064 0.019 0.020 12 Rome 0.033 Detroit St. Paul Skopje 0.053 -0.001 0.061 13 Antwerp 14 Reykjavik 15 Düsseldorf Memphis Virginia Beach Newark Los Angeles Anchorage Jersey Washington 0.012 Vilnius 0.036 0.027 0.086 -0.002 Essen -0.021 0.055 0.052 0.044 0.016 -0.001 16 Kraków 17 Frankfurt 0.035 Austin 0.071 0.077 Durham 0.057 -0.002 San Francisco 0.102 Phoenix 18 Vilnius 19 Timisora 0.010 Greensboro 0.057 0.053 -0.011 Anaheim Nashville-Davidson 0.030 0.005 Philadelphia 0.020 Chicago 0.072 20 Helsinki 0.085 0.027 El Paso 21 Odessa 0.084 0.028 0.006 Omaha 22 Pristina San Diego Madison 0.080 23 Tallin 0.039 0.105 24 Banja Luka 25 Chisinau 0.082 0.024 Fort Worth 0.015 0.085 Cincinnati 0.032 26 Belfast 0.001 Tampa 0.041 27 Zurich 0.000 Sacramento 28 Copenhagen 29 Bratislava -0.005 0.047 Honolulu 0.020 0.096 St. Petersburg 30 Ankara 31 Athens 0.057 0.006 Lincoln 0.069 0.082 Oakland 0.059 32 Brussels 0.064 St. Louis 33 Кгyvy Rig 34 Volgograd 35 Novi Sad 0.073 0.018 Lubbock 0.038 0.003 Wichita 0.079 Data Ready e X Type here to search ThinkVision 70-DH 212000 POV INT TAX- OF ITEM TAX+ GT R NDING M* OFF MARGIN SET SELL # OST MO d. What is your conclusion? 15. Hotel Prices. Hotel room pricing changes over time (Lodging Magazine), but is there a difference between Europe hotel prices and U.S. hotel prices? The file IntHotels contains changes in the hotel prices for 47 major European cities and 53 major U.S. cities. a. On the basis of the sample results, can we conclude that the mean change in hotel rates in Europe and the United States are different? Develop appropriate null and alternative hypotheses. b. Use a .01. What is your conclusion? ATA file tHotels Cellaga Roord. TL