document.write( "Question 888698: Can someone help with the following:\r
\n" ); document.write( "\n" ); document.write( "In her first year of university, Mary received the following grades:\r
\n" ); document.write( "\n" ); document.write( "12, 8, 12, 11, 9, 6\r
\n" ); document.write( "\n" ); document.write( "Similarly in his first year, Bob received the following grades:\r
\n" ); document.write( "\n" ); document.write( "5, 9, 9, 6, 5, 7\r
\n" ); document.write( "\n" ); document.write( "Compute the population mean and variance for both.\r
\n" ); document.write( "\n" ); document.write( "My Work:\r
\n" ); document.write( "\n" ); document.write( "Mary's mean 9.67
\n" ); document.write( "Bob's mean 6.83\r
\n" ); document.write( "\n" ); document.write( "not sure of the variance\r
\n" ); document.write( "\n" ); document.write( "thanks Paul
\n" ); document.write( "
\n" ); document.write( "

Algebra.Com's Answer #537604 by Theo(13342)\"\" \"About 
You can put this solution on YOUR website!
sum of squares for mary is 29.33
\n" ); document.write( "sum of squares for bob is 16.83\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "the population variance for mary is 4.89
\n" ); document.write( "the population variance for bob is 2.81\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "the population variance is equal to the sum of squares divided by the count of the number of items.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "for mary, this would be 29.33 / 6 = 4.89
\n" ); document.write( "for bob, this would be 16.83 / 6 = 2.81\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "the sum of squares can be calculated in two basic ways.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "first way is:\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "sum of squares = sum of (x-m)^2, where x is the individual data values and m is the mean of the data set.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "second way is:\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "sum of squares = sum of (x^2) - (sum of x)^2 / n, where x is the individual data values and n is the count of data items.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "both these methods are shown in the excel spreadsheet under sum of squares option 1 and sum of squares option 2.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "sum of squares option 3 is equal to the population variance * the count of items.
\n" ); document.write( "this can be done in excel because excel provides a formula for variance and a formula for count but does not provide a direct formula for sum of squares, so you can get the sum of squares through excel by multiplying the population variation by the count of items.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "the calculations are shown in the following picture of an excel spreadsheet.
\n" ); document.write( "\"$$$\"
\n" ); document.write( "
\n" ); document.write( "
\n" );