Answer Happy

please use the worksheet provided thanks so much
Excel Lab 2 Instructions/Submit a Start Assignment Submitting a file upload File Types pdf, xls, and xlsx Due Wednesday by Sam Points 44 Available until Apr 29 at 8am Excel Worksheet for Project 2: Stat 200 Project 2 Worksheet BT.xlsx This is due Wednesday 4/27 by 8:00am. Late projects are accepted with a 20% deduction until Friday 4/29 by 8:00am. The Project Scoring Rubric is here. For this project, we will be using Excel to generate a series of confidence interval from random samples, as well as using the statistical functions to setup and run a hypothesis test for a mean. Important: Please watch the project demo video to see how the steps are walked through. Excel functions, formulas, and cell references must be used to demonstrate a working knowledge of Excel. Values that are just typed into Excel cells do not earn credit. You can see examples of how to do this in the demo video. We have tasked with comparing the average weights of athletes to that of the general public. You will pick any sports team in the world (except the Philadelphia Eagles, because that's who I picked) that you can find the weights for the players. Just be sure that you can get data for at least 30 players. There are two worksheets on the Projects spreadsheet, so you'll paste your data into the first column in both sheets. Then, follow along with the demo video to generate random sampling confidence intervals and a hypothesis test. In addition to completing the Excel spreadsheet, you'll write up a brief report explaining your data, what analysis you did in Excel, and what the conclusions are. Using normal font sizes and margins, this could probably be done in a single page. As before, you'll upload 2 files. Your Excel file (as an .XLS or .XLSX only), and your report (as a PDF only). After you've uploaded these two files to Canvas, review what you've uploaded to ensure they're the correct files and are showing up. Submitting blank or wrong files does not earn an extension.
Name: Data: Source/Link: Data Descriptive Statistics Random Samples of size n = 5 5 6 1 3 7 10 Sample Mean, x-bar Sample Std Dev, s Critical Value, t-alpha/2 Margin of Error, E Use the mean from the "descriptive statistics" as your population mean, u Confidence intervals at 95% Is u in C.1.? Yes/no Sample lower limit upper limit 1 Use each of the 10 sample means from your random samples as the x-bar for each f your confidence intervals. 10
Data Random Sample n=12 Descriptive Statistics of Sample two-tailed hypothesis test Null Hypothesis: For the null hypothesis, use the claim that for males, average weight is equal to 195.5 lbs, and for females, average weight is 166.2 lbs. Alternate Hypothesis: Level of Significance: a = 0.01 Critical Value t./2 Test statistic Conclusion: Ip-value: Does p-value agree support your conclusion? Why?