Sheet1 BaseballIce Hockey Year Population 27.027.5 19002.2 24.424.1 19102.6 31.525.0 19202.9 30.525.8 19302.9 25.025.4 19403.1 29.223.8 19503.4 30.327.2 19603.9 29.227.0 19704.6...

This is a statistics assignment to be done in Exel or Statcrunch.


Sheet1 BaseballIce HockeyYear Population 27.027.519002.2 24.424.119102.6 31.525.019202.9 30.525.819302.9 25.025.419403.1 29.223.819503.4 30.327.219603.9 29.227.019704.6 27.324.019805.5 24.722.619906.5 24.426.820008.2 25.027.020109.7 28.223.4 25.926.8 30.727.3 25.826.6 24.727.4 24.023.0 27.628.8 27.123.1 28.026.3 29.525.7 27.126.1 34.026.7 25.828.0 25.824.8 24.427.0 27.225.5 29.825.7 25.127.5 28.527.0 25.7 30.2 27.7 28.1 23.8 23.7 25.5 27.1 28.6 28.6 30.6 27.8 26.7 26.9 25.5 26.6 29.8 28.9 MATH 2000 Project Due Date: May 2 (Sunday) To turn in the project: Prepare all your work and the answers including Statcrunch output in Microsoft Word and submit it through D2L. There will be some deduction (10%) for late projects. May 6 is the last day you can submit the project with deduction. Open the Excel file for the data. 1. BMI (Body MASS Index) is a value derived from the weight and height of an individual. We want to test a claim that average BMI of professional baseball players is equal to the average BMI of professional ice hockey players. Let the significance level equal to 0.05. Do not assume that the population standard deviations are equal. 49 professional baseball players and 31 professional ice hockey players are randomly selected. See the first two columns in Excel file. The mean BMI of professional baseball players is denoted by and the mean BMI of professional ice hockey players is denoted by . To use Statcrunch See Sec 9.2 Testing two independent population means document in Week 12 module. Check Example 1 and 3 ( second part is Statcrunch tutorial ) Alternative hypothesis you see in that example may not be the answer for this project. a) (10 pts) What are the null and alternative hypotheses? (Select one) a-1) , a-2) , a-3) , a-4) , b) (15 pts) Provide statcrunch output. To copy the table from statcrunch: highlight the table with your mouse, copy(ctrl+C) and paste (+V) into Word. Example : you should have a table like this here Hypothesis test results: Difference Sample Diff. Std. Err. DF T-Stat P-value μ1 - μ2 34.75 23.939093 15.073909 1.4516005 0.0836 c) (5pts) Write the test statistic. (Round to three decimal places.) d) (5pts) Write p-value. (Round to three decimal places.) e) (10pts) Do we claim that these two average BMI values are equal or not? Provide the reason for your conclusion. 2. We have population records in GA from year 1900 to year 2010 in Excel file. Let x be the number of years after 1900 and y be the population in millions. Note: year 1900 becomes x = 0, year 1910 becomes x = 10, year 1920 becomes x = 20, and so on. We want to test whether X and Y are linearly related using a correlation coefficient and a regression equation. A significance level of 0.05 is used in this study. To use Statcrunch See Sec 10.1-10.2 Correlation and Regression document in Week 13 module and check example 6 a) (15 pts)Provide statcrunch output. (You need two: Simple Linear Regression Results: Parameter Estimates) Example : you need to provide the following two outputs using the data from this project. Simple linear regression results: Dependent Variable: Left Independent Variable: Right Left = 59.371642 + 0.9547053 Right ---- Regression Equation Sample size: 10 R (correlation coefficient) = 0.8346584 ---- Correlation coefficient R-sq = 0.69665465 Estimate of error standard deviation: 5.9386605 Parameter Estimate Std. Err. Alternative DF T-Stat P-value Intercept 59.371642 20.599476 ≠ 0 8 2.8821918 0.0204 Slope 0.9547053 0.22273283 ≠ 0 8 4.2863249 0.0027 b) (5pts) Provide the scatter plot with the regression line. To copy: Right Click the image, Select Copy image. Then, select paste special in Word and choose Device Independent Bitmap. Example: You need to provide the graph like the one below. c) (5pts) Write a correlation coefficient. d) (5pts) Write a regression equation. e) (5pts) Write p-value. f) (10pts) Do we claim that these two groups of data are linearly related or not? Provide the reason for your conclusion. g) (10pts) Using your model to predict the population in year 2020.