Use the Excel formula "CORREL" to solve problems 14.5 (circleed one) in the chapter. leave the formula in excel

14.2 Section Cheese Wine Cheese Wine Basic Skills 38.5 2.94 35.3 2.72 14.1 Consider the following ordered pairs: 37.2 2.87 35 2.57 X 6 36.2 2.83 34.6 2.51 y 5 7 35.6 2.84 34.5 2.45 Calculate the sample correlation coefficient. 35.5 2.78 35.2 2.47 14.2 Perform a hypothesis test with the data from Prob- lem 14.1 to determine if the population correlation Determine the sample correlation coefficient between coefficient is not equal to zero using a = 0.05. What the U.S. per capita consumption of cheese and wine- are your conclusions? 14.6 Using the data from Problem 14.5 and a = 0.02, test 14.3 Consider the following ordered pairs: if the population correlation coefficient between the U.S. per capita consumption of cheese and wine is x different than zero. What conclusions can you draw? y 6 8 6 7 Best Buy would like to investigate the linear rela Calculate the sample correlation coefficient. tionship between the selling price of a Canon Pow- 14.4 Perform a hypothesis test with the data from Prob- erShot digital camera and the demand for it. The lem 14.3 to determine if the population correlation following table shows the weekly demand for the coefficient is less than zero using a = 0.05. What are camera in one particular market along with the cor your conclusions? responding price: Applications Demand Price ($) Demand Price ($) 16 300 14.5 The Twin Cities Pioneer Press argued in a 2018 arti- 11 340 cle that wine and cheese were important for world 19 310 12 350 history and the development of human physiology. 14 320 8 360 A researcher was interested in studying if there is 13 actually a strong positive relationship between wine 330 and cheese consumption. The following table shows U.S. per capita cheese and wine consumption for Determine the sample correlation coeffi several years between the selling price and the demand for camera