A.1.12.2 Investigating Standard Deviation (Part 2)

Clear the data from the spreatsheet by slecting each column and hitting the delete button on your keyboard. Now make up your own set of data and enter it into column B so that it fits these conditions : Your new data set needs to have 10 numbers that have a standard deviation the same as the data in the first dot plot, but with a mean of 6. This was the first dot plot and the data should still be in column A of the spreadsheet:



You'll probably need to do some guess and check on this - enter some data you think fits these conditions and then find the mean and standard deviation - keep changing the data values you made up in coulumn B until you can get the mean and standard deviation you need. Once you've got it - type the data set here:

Now make up another data set and enter it into column C so that it fits these conditions : Your second new data set needs to have 10 numbers that have a standard deviation that is three times greater than the data in the first dot plot. This was the first dot plot and the data should still be in column A of the spreadsheet:



Again, do some guess and check on this - enter some data you think fits these conditions and then find the mean and standard deviation - keep changing the data values you made up in coulumn C until you can get the mean and standard deviation you need. Once you've got it - type the data set here:

One last data set to amke up and enter it into column D that it fits these conditions : Your third new data set needs to have 10 different numbers that have a standard deviation as close to 2 as you can. This was the first dot plot and the data should still be in column A of the spreadsheet:



Again, do some guess and check on this - enter some data you think fits these conditions and then find the mean and standard deviation - keep changing the data values you made up in coulumn C until you can get the mean and standard deviation you need. Once you've got it - type the data set here: