Does anyone have any idea on how I start this assignment? Here is the random sample link https://ww2.amstat.org/censusatschool/RandomSampleForm.cfmIf someone could help me that would be great
Labor Collect the Data on Now that your topic questions have been approved, it is time to collect and organize the data. Census at School's Random Sampler (opens in a new window) has been used to gather a very large sample for you to take a sample from. This sample is made up of approximately 1000 high school students. You may either download The Project Data Excel File (xIsx, 282 KB) or you may use the Project Data for Probability and Statistics Google Sheet (opens in a new window). Make a copy for yourself to be able to manipulate the data values in the spreadsheet. You need to have a total of at least 50 data points. How will you need to take your random sample(s) in order to get the information you need? For example, if I want to compare middle schoolers to high-schoolers, I would ideally like to have an equal number of middle schoolers and high schoolers. To ensure that happens, I'll need to take TWO random samples of 25 each, one that includes students 6-8, and one that includes students 9-12. All other variables should remain the same. (This would be called a stratified random sample.) If you want to compare the index fingers and height of students, without noting different genders or grades, then you'll just need to pull ONE random sample of 50 students, which is called a Simple Random Sample, or SRS. If your question was "How are the distributions of index finger length similar or different for males and females?" You would want to first sort the larger document by males/females and then take a random sample from each of those to get 25 males and 25 females. The methods for sorting are slightly different depending on whether you're using google sheets or excel. 1. For google sheets, click the very top of the gender column and there will be an arrow you can click and then select "Sort A-Z". 2. For excel, you can right click the title of the column "gender" and then choose sort A-Z. If you are having trouble with this step googling videos with your specific version of excel or computer can be helpful. Once you have sorted, you can use a random number generator or table to randomly select 25 males and 25 females. If your random number generator gives you "461", you would go to row 461, and record the gender and index finger length of that person. If you, select one that does not have that data included, pick a new one, but make a note of that for your conclusion later. You can either write each data point down by hand in your own table or use google sheets or excel from the start to create a data table. It should have headings to represent your variables (gender and index finger length in our example) and have each data point in rows. Here is an example of what your data table would look like, in part Gender Index Finger length female female