Si for estadistic

Computer Assignment #1 Due (Wednesday 4-9-25) For this assignment I want you to use DATA SET # 23 (Noble Laureates and Chocolate). Go to www.TriolaStats.com to download the data to your computer. You want the data that is already in excel format. Using Microsoft Excel, I would like you to complete the following: 1. Create a scatter plot. (a) Let the Chocolate be the x-variable and the Noble Laureates be the y-variable, be sure to label each axis appropriately. (b) Click on your chart to make it active, then click on add chart element, use the trend line feature. Make sure to select a linear trend line. Under the more chart options of add a trend line, click on add an equation to the chart. 2. Use the function (correl) to calculate the correlation coefficient for the data on Chocolate and Noble Laureates. 3. Use the function (slope) to calculate the slope of the prediction equation for the data on Chocolate and Noble Laureates. 4. Use the function (intercept) to calculate the y-intercept of the prediction equation for the data on Chocolate and Noble Laureates. 5. Does the scatterplot imply any relation between Chocolate and Noble Laureates? 6. Use the average function to find the mean for Noble Laureates. 7. Use the median function to find the median for Noble Laureates. 8. Use the standard deviation function to find the standard deviation for Noble Laureates. 9. Given Classes Frequency 70 -79 80-89 2 90 -99 11 100 - 109 10 110 - 119 5 120 - 129 NU 130-139 Enter the frequency table into excel and create a pie chart. I need you to print me a copy of the results and a copy of the formulas. Staple the formula printout behind the results printout