Help with statistics and standard deviation please?

Question

Is there anyone out there who can figure this out??

1. Using the following key, complete the chart below with the given data set #1 and #2.
X = variable
d = deviation (X – mean)
d2 = deviation squared

Data Set #1:
20 17 16 16 17
13 16 18 11 12
13 14 19 12 15
13 17 12 17 18
14 12 16 11 17
12

Data Set #2:
5 4 4 5 1
3 3 5 5 4
2 5 4 5 5
5

I also need to figure out how to find the standard deviation and population using the population formula for each set of data. Can anyone help me with this?

Answer 1

Use Excel. In one coloumn put X and underneath enter 20 then 17 then 16 etc. eg cell A1 says 'X'. A2 should be 20, A3 17 etc etc. Then after you have entered the last digit, in the cell below (cell A28) type '=sum(a2:a27)' hit return and this will give you the sum. In the cell below type '=a28/26' .This is the mean.



Now in cell B1 type 'd' and in B2 type '=a2-$a$29' Drag this cell down so that every a cell up to a27 has a corresponding b cell. In cell C1 type 'd2'. in cell c2 type '=c1*c1'. Again drag down to c27.The standard deviation is the sum of all the c cells divided by 27.

Answer 2

think loads of scholars went into do an examination. The extra the extra useful. On a countrywide scale, if each and all of the outcomes have been taken and plotted onto a graph, some scholars will do poorly, some will do alright and maximum folk will lie in between the two extremes. by utilising human nature, the graph plotted would be a typical distribution graph, it is going to appear as if a bell shape layout. the optimal ingredient of the graph stands out as the recommend, and at this ingredient while a line is drawn down vertically to cut back the x-axis, it is going to divide the graph in 2 equivalent areas. this form of shape is what's huge-unfold as a typical distribution curve and that's symmetrical approximately that's centre line which coincides with the recommend (x bar) of the observations. the huge-unfold deviation is a level of ways this awareness is unfold out. One huge-unfold deviation of the two aspects of the recommend (x bar ±?) will incorporate sixty 8% of the training. 2 huge-unfold deviation of the two aspects of the recommend (x bar ±2?) will incorporate ninety 5% of the training. 3 huge-unfold deviation of the two aspects of the recommend (x bar ±3?) will incorporate ninety 9?7% of the training. those values prepare for a typical distribution. So the huge-unfold distribution is a level of the unfold of archives from the recommend.

Answer 3

Xmean = (1/16)*(5+4+4+5+1+3+3+5+5+4+2+5+4+5+5+5) = 65/16 = 4.0625



S^2(X) = 1/15*(5^2+4^2+4^2+5^2+1^2+3^2+3^2+5^2+5^2+4^2+2^2+5^2+4^2+5^2+5^2+5^2-16*4.0625^2)

= 1.529166667



SD(X) = sqrt(S^2(X)) = sqrt(1.529166667) = 1.236594787



Working with population data, use n instead (n - 1) for σ^2(X)