Problem 2a & 3b Answer to Question: Purchasing Survey a. Utilizing the worksheet Problem 2a & 3b, create and locate a scatter chart in the range E2:H14 that uses the variables Overall Service and Satisfaction Level. Show axes labels and include the title Overall Service and Satisfaction Level Ratings. Do you observe a positive or negative LOCATE SCATTER CHART BELOW Answer to Question b. Utilizing the worksheet Problem 2a & 3b, use the CORREL() sample correlation coefficient function to compute the correlation coefficient between variables Overall Service and Satisfaction Level. Locate the function in cell K3. Correlation Coefficient Sample Delivery speed Price level Price flexibility Manufacturing image Overall Service Salesforce image Product quality Satisfaction Level Size of firm Purchasing Structure Industry Buying Type 1 4.1 0.6 6.9 4.7 2.4 2.3 5.2 4.2 0 0 1 1 2 1.8 3.0 6.3 6.6 2.5 4.0 8.4 4.3 1 1 0 1 3 3.4 5.2 5.7 6.0 4.3 2.7 8.2 5.2 1 1 1 2 4 2.7 1.0 7.1 5.9 1.8 2.3 7.8 3.9 1 1 1 5 6.0 0.9 9.6 7.8 3.4 4.6 4.5 6.8 0 0 1 3 6 1.9 3.3 7.9 4.8 2.6 1.9 9.7 4.4 1 1 1 2 4.6 2.4 9.5 6.6 3.5 4.5 7.6 5.8 0 0 1 1 8 1.3 4.2 6.2 5.1 2.8 2.2 6.9 4.3 1 1 0 2 9 5.5 1.6 9.4 4.7 3.5 3.0 7.6 5.4 0 0 1 3 10 4.0 3.5 6.5 6.0 3.7 3.2 8.7 5.4 1 1 0 2 11 2.4 1.6 8.8 4.8 2.0 2.8 5.8 4.3 0 0 0 1 12 3.9 2.2 9.1 4.6 3.0 2.5 8.3 5.0 0 0 2 13 2.8 1.4 8.1 3.8 2.1 1.4 6.6 4.4 1 1 0 1 14 3.7 1.5 8.6 5.7 2.7 3.7 6.7 5.0 0 0 1 1 15 4.7 1.3 9.9 6.7 3.0 2.6 6.8 5.9 0 0 0 3 16 3.4 2.0 9.7 4.7 2.7 1.7 4.8 4.7 0 0 0 3 17 3.2 4.1 5.7 5.1 3.6 2.9 6.2 4.4 0 1 1 2 18 4.9 1.8 7.7 4.3 3.4 1.5 5.9 5.6 0 0 0 2 19 5.3 1.4 9.7 6.1 3.3 3.9 6.8 5.9 0 0 1 3 20 4.7 1.3 9.9 6.7 3.0 2.6 6.8 6.0 0 0 0 3 21 3.3 0.9 8.6 4.0 2.1 1.8 6.3 4.5 0 0 0 2 22 3.4 0.4 8.3 2.5 1.2 1.7 5.2 3.3 0 0 0 1 23 3.0 4.0 9.1 7.1 3.5 3.4 8.4 5.2 0 1 0 3