FPST $4333$ System & Process Safety Analysis Laboratory $1$

Aug$-24$

Statistics and Probability Analysis using Excel

This is an individual assignment.

Using Microsoft Excel, create a spreadsheet with a separate tab for each dataset appropriately labeled

$($dataset $1,$ dataset $2,$ etc.$)$ For best calculation results, enter the data provided below in column format.

Each data set is a complete sample. Calculations should use the appropriate Excel formula. Hand or

manual calculations will not be given credit.

Within each dataset tab, imbed a textbox and provide a paragraph description of your analysis of the data

and the results of each problem. What does the data mean, what is the significance of the statistical

analysis, what can be learned from the data$/$calculations etc.

Upload one single Excel file and name your file yourlastnameLab$1.$xls

DATA SET $1$

Determine the mean, median and appropriate standard deviation for the following selected sample of test

scores from last year$$s FPST $4333$ final exam. Explain your results