Reference no: EM133695

Question

Do problem at the end of the text book.  There are two sets of test scores titled Part 1 and Part 2.  The first three columns are the scores for Part 1 or Computer test scores out of a max score of 50.  The last three columns are the scores for part 2 or the written test scores, out of a max score of 100.  Make sure you label all the solutions in a spreadsheet so they are easy to find.  Save this on the worksheet called Part 1 in a file titled HW7.xls.

For part a you are able to use the built in functions, but you must also use sum and count command to solve the mean and standard deviation equations.

For parts B-D use the built in histogram function and also use the countif or countifs command to count values in each bin.  So you must have two plots for each part.