BNAL 306 Business Analytics II Problem For the data in the excel file Rin's Gym, do the following: a. Do three scatterplots: 1) weight vs height, 2) BMI vs height and 3) BMI vs weight b. Interpret the scatterplot BMI vs height. c. find the matrix of sample correlations among height, weight and calculated BMI. d. Provide an interpretation of the correlation coefficients 1) weight vs height, 2) BMI vs height and 3) BMI vs weight. The general procedure is outlined below. 1. Open the file "Excel files for Assignment 3." In the first tab, you will find the table. 2. Use Insert > scatterplot to generate the graphs. 3. Go to Data > Data Analysis. Select Correlations. Highlight the range with labels. Problem For the President's Inn Guest database, find the following: a. mean length of a stay, mean daily rate and the mean number of guests per party. b. Do a scatterplot of the number of guest vs length of stay and daily rate vs length of stay. c. Compute the correlation between the number of guests and the length of stay. Interpret the result. d. Compute the correlation between the daily rate and the length of stay. Interpret the result. The general procedure is outlined below.

1. Open the file "Excel files for Assignment 3." In the second tab tab, you will find the table. 2. Compute the averages using the SUM function. 3. Use Insert > scatterplot to generate the graphs. 4. Use the Excel function CORREL to generate the correlations. Problem The Excel file Auto Survey contains a sample of data about vehicles owned, whether they were purchased new or used and other type of data. Find the following: a. Do three scatterplots: 1) vehicle age vs mileage, 2) vehicle age vs MPG and 3) mileage vs MPG b. Interpret the scatterplot mileage vs vehicle age. c. Find the matrix of sample correlations among vehicle age, mileage and MPG. d. Provide an interpretation of the correlation coefficients 1) vehicle age vs mileage, 2) vehicle age vs MPG and 3) mileage vs MPG The general procedure is outlined below. 1. Open the file "Excel files for Assignment 3." In the third tab, you will find the table. 2. Use Insert > scatterplot to generate the graphs 3. Go to Data > Data Analysis. Select Correlations. Highlight the range with labels.