Answer:
Step-by-step explanation:
I have taken out time to prepare the raw file as a CSV file (comma separated variable) please see attached the excel format.
Z-SCORE= (DataPoint-AVERAGE(DataSet))/STDEV(DataSet)
IN EXCEL,
AVERAGE, an excel function that calculates the Average of data set
STDEV.S: calculates the standard deviation while treating the data as a ‘sample’ of a population.
STDEV.P: This function calculates the standard deviation while treating the data as the entire population.
kindly find attached the excel sheet, with calculations done
Kindly let me know if you need more information,