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.