Address the following questions in your report:

• Looking at the data for Fitness Club Membership fees, are there any outliers? If so, which cities? *Use the Lower and Upper Bounds to find outliers (Hint: Review about outliers in our textbook: Measures of the Location of the Data)
• Looking at the data for "Cost of Living Index", are there any outliers? If so, which cities? *Again, make sure that you are using the lower and upper bounds to identify outliers.
• The "Cost of Living Index" for New Orleans is 74.98. How does this compare to the other cities in this dataset? *Use the provided statistics on Mean, Median, Min, Q1, Q3, and/or Max to for comparison.
• Looking at the simple linear regression, is there a significant linear relationship between "Cost of Living Index" and Fitness Club Monthly Fee at significance level ? = 0.05? (HINT: Excel uses scientific notation for small numbers. For example, 1.1623E-6 is the method Excel uses to write 0.0000011623). If significant, interpret the relationship between the "Cost of Living Index" and fitness membership fees (i.e., is there a positive relationship, or a negative relationship?)
• The "Cost of Living Index" for New Orleans is 74.98. Predict the Fitness Club Monthly Fee for New Orleans. Provide a 95% prediction interval for your prediction. *This is the ONLY calculation you are asked to do for this project. ALL other calculations are already provided for you in Martha's Excel attachment.
• Looking at the multiple linear regression, are there any significant predictors at significance level ? = 0.05? If significant, interpret the relationship between the significant predictor and fitness membership fees (i.e., is there a positive relationship, or a negative relationship?)
• The average price of gas for New Orleans is $4.11, the price of a one bedroom apartment is $1,634, and the average monthly salary is $5,107. How do these compare to the other cities in this dataset? *Use the provided statistics on Mean, Median, Min, Q1, Q3, and/or Max for comparison.

BUSN312 week 7 forum 7 20211 x X Math 302 Final Project - 2022 W x X Math 302 Final Project - 2022 W x + Math - Google Sheets X + X > C A docs.google.com/spreadsheets/d/11uSomjg9sorqxpockV3esp81Rf-8qm316Avhtff1qCo/edit#gid=1347048170 Search the menus (Alt+/) 100% * $ % .0 .00 123- Calibri 11 BISA A1 fx city A B C D E F G H I J K L M N 0 Fitness Club, Monthly Fee City for 1 Adult Cost of Living Index 2 Los Angeles $ 44.81 78.91 3 San Francisco $ 93.13 94.41 4 Sacramento $ 54.38 78.41 5 San Diego $ 43.52 77.51 6 Denver 50.17 75.99 7 Washington $ 83.01 35.49 8 Miami $ 45.43 77.39 9 Atlanta $ 37.63 75.88 10 Chicago 53.30 75.61 11 New York $ 107.69 100.00 12 Portland 51.10 78.50 13 Houston $ 40.38 66.06 14 Austin 49.33 65.93 15 Dallas $ 37.79 68.71 16 San Antonio $ 31.42 52.25 17 Seattle 53.52 89.33 18 19 Mean $ 55.41 78.15 20 Median $ 50.22 77.45 21 Standard Deviation $ 21.27 10.25 22 Min $ 31.42 62.25 23 Q1 $ 42.74 73.89 24 Q3 $ 55.83 80.56 or + Simple Linear Regression . Multiple Linear Regression + Explore 3 19:51BUSN312 week 7 forum 7 20211 x X Math 302 Final Project - 2022 W x X Math 302 Final Project - 2022 W x + Math - Google Sheets X + X > C A docs.google.com/spreadsheets/d/11uSomjg9s6rqxpockV3esp81Rf-8qm316Avhtff1qCo/edit#gid=1347048170 Search the menus (Alt+/) 100% * $ % .0 .00 123- Calibri 11 BISA A1 fx city A B C D E F G H I J K L M N 0 25 Max $ 107.69 100.00 26 IOR 13.09 6.67 27 Lower Bound 23.10 53.88 28 Upper Bound S 75.47 90.56 29 30 SUMMARY OUTPUT 31 32 Regression Statistics 33 Multiple R 0.8505372032 34 R Square 0.723413534 35 Adjusted R Square 0.7036573578 36 Standard Error 11.57899303 37 Observations 16 38 39 ANOVA 40 df SS MS F Significance F 41 Regression 1 4909.36503 4909.36503 36.61708261 0.00002981026 42 Residual 14 1877.023114 134.0730796 43 Total 15 6786.388144 44 45 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 46 Intercept 82.51080415 22.97588887 -3.591190948 0.002949593! -131.7891847 -33.23242355 -131.7891847 -33.23242355 47 Cost of Living Index 1.764889767 0.2916592234 6.051205054 0.000029810: 1.139342947 2.390436586 1.139342947 2.390436586 48 + Simple Linear Regression Multiple Linear Regression + Explore M 2 19:51BUSN312 week 7 forum 7 20211 x X Math 302 Final Project - 2022 W x X Math 302 Final Project - 2022 W x + Math - Google Sheets X + X > C A docs.google.com/spreadsheets/d/11uSomjg9sorqxpockV3esp81Rf-8qm316Avhtff1qCo/edit#gid=1094662404 Search the menus (Alt+/) 100% * $ % .0 .00 123- Calibri 11 BISA A1 - fx city A B C F G H I J K L M N Fitness Club, Apartment Average Monthly Fee for | Gasoline per (1 bedroom) Monthly Net City 1 Adult gallon in City Centre Salary 2 Los Angeles $ 44.81 $ 4.47 $ 2,336.03 5,848.84 3 San Francisco 93.13 $ 4.54 $ 2,929.14 $ 7,996.29 Sacramento 54.38 $ 4.28 $ 1,619.00 4,042.06 5 San Diego 13.52 4.35 2,341.45 $ 5,540.39 6 Denver 60.17 $ 3.33 $ 1,792.80 5,160.12 Washington 33.01 3.07 $ 2,191.39 $ 5,870.95 8 Miami 45.43 $ 3.26 $ 2,121.67 $ 3,945.90 Atlanta 37.63 S 3.10 $ 1,610.37 $ 4,861.35 10 Chicago 53.30 $ 3.33 $ 1,830.11 $ 5,466.52 11 107.69 Screen capture . now New York 3.22 $ 3,328.49 $ 6,043.48 12 Portland 51.10 $ 3.60 $ 1,706.04 4,171.05 Screenshot taken 13 Houston 10.38 $ 2.80 $ 1,450.66 $ 5,594.76 Show in folder 14 Austin 49.33 2.88 2,070.56 $ 5,703.37 15 Dallas 37.79 2.57 $ 40 185 1,636.16 $ 5,879.08 16 San Antonio 31.42 $ 2.65 $ 1,305.08 $ 4,202.31 17 Seattle 53.52 3.90 $ 2,023.75 $ 6,915.83 18 19 Mear $ 55.41 $ 3.46 $ 2,018.29 $ 5,452.64 20 Median $ 50.22 3.29 $ 1,926.93 $ 5,567.58 21 Standard Deviation 21.27 S 0.66 534.26 $ 1,079.07 22 Min 31.42 $ 2.57 $ 1,305.08 $ 3,945.90 Copied to clipboard Search + V 23 Q1 42.74 $ 3.02 $ 1,631.87 $ 4,696.59 EDIT DELETE + Simple Linear Regression Multiple Linear Regression M 1 3 19:52BUSN312 week 7 forum 7 20211 x X Math 302 Final Project - 2022 W x X Math 302 Final Project - 2022 W x + Math - Google Sheets X + X > C A docs.google.com/spreadsheets/d/11uSomjg9sorqxpockV3esp81Rf-8qm316Avhtff1qCo/edit#gid=1094662404 Search the menus (Alt+/) 100% * $ % .0 .00 123- Calibri 11 BISA A1 - fx city A B C D E F G H I J K L M N 21 Standard Deviation $ 21.27 $ 0.66 $ 534.26 $ 1,079.07 22 Min $ 31.42 $ 2.57 1,305.08 $ 3,945.90 23 Q1 42.74 3.02 $ 1,631.87 $ 4,696.59 24 Q3 $ 55.83 $ 3.99 $ 2,227.55 $ 5,872.98 25 Max $ 107.69 4.54 $ 3,328.49 $ 7,996.29 26 OR $ 13.09 $ 0.97 $ 595.68 $ 1,176.39 27 Lower Bound $ 23.10 $ 1.56 $ 738.35 $ 2,932.00 28 Upper Bound 75.47 $ 5.46 $ 3,121.07 $ 7,637.57 29 30 31 SUMMARY OUTPUT 32 33 Regression Statistics 34 Multiple R 0.8318282408 35 R Square 0.6919382223 36 Adjusted R Square 0.6149227778 37 Standard Error 13.19920072 38 Observations 16 30 40 ANOVA 41 df SS MS F Significance F 42 Regression 3 4695.761348 1565.253783 8.984408613 0.00214963275 43 Residual 12 2090.626796 174.2188997 44 Total 15 6786.388144 + Simple Linear Regression . Multiple Linear Regression + Explore M 2 19:52BUSN312 week 7 forum 7 20211 x X Math 302 Final Project - 2022 W x X Math 302 Final Project - 2022 W x + Math - Google Sheets X + X > C A docs.google.com/spreadsheets/d/11uSomjg9sorqxpockV3esp81Rf-8qm316Avhtff1qCo/edit#gid=1094662404 Search the menus (Alt+/) 100% * $ % .0 .00 123- Default (Ca.. * 11 . B I S A N28 - fx | A B C D E F G H I J K L M N 35 R Square 0.6919382223 36 Adjusted R Square 0.6149227778 37 Standard Error 13.19920072 38 Observations 16 39 40 ANOVA 41 df SS MS F Significance F 42 Regression 3 4695.761348 1565.253783 8.984408613 0.00214963275 43 Residual 12 2090.626796 174.2188997 44 Tota 15 6786.388144 45 46 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upp Screen capture . now 47 Intercept -3.565401306 22.08242486 -0.1614587768 0.874418607 -51.67887189 44.54806928 -51.67887189 44.5 Screenshot taken 48 Gasoline per gallon -4.70004543 5.754836054 -0.8167123071 0.4300087104 -17.23875606 7.838665196 -17.23875606 7.83 Show in folder 49 Apartment (1 bedroom) in City Centre 0.03346773417 0.00837280569 3.997194657 0.001770612: 0.01522495771 0.051710510 0.0152249577 0.05: 50 Average Monthly Net Salary 0.001409938447 0.003917703219 0.359889039 0.7251843437-0.0071260035 0.009945880.-0.007126003: 0.00: 51 52 53 54 55 56 57 Copied to clipboard Search + V 58 EDIT DELETE + Simple Linear Regression . Multiple Linear Regression 9 1 3 19:52