can you please provide record all the forumlas used to calcu

can you please provide/ record all the forumlas used to calcuate each coulmn of the data?

original question :

in an Excel spreadsheet create the headings and data similar to the one shown below. Data must be sorted from least to greatest. Note the station process times (in seconds) for only the last 20 cycles[20 cycles for S1 and 20 cycles for S3] should be transferred to this Excel spreadsheet. (Note you only need the ProcTime column. You won’t be analyzing the entity data.)

Deliverables.

-The completed Excel spreadsheet shown below. Use the parameters from the stations’ Plant Simulation process time distributions to compute the percentiles, h(p).

-Give formulas used to find percentile and h(p) for station 1 and 2. Remember to find min, max, average, and standard deviation for the process time data.

Station 1 (uniform dist.)

Station 3 (normal dist.)

‘i’

or

cycle number

percentile

h(p)

or

‘x’-unkown

Process Time (sec.)

Given

Z-score

h(p)

or

‘x’-unkown

Process Time (sec.)

Given

minimum

maximum

average

std. dev.

Expert Answer

6.59176

data calculated ....is below.

			Station 1 (uniform dist.)	Station 3 (normal dist.)
	‘i’ or cycle number	percentile	h(p) or ‘x’-unkown	Process Time (sec.) Given	Z-score	h(p) or ‘x’-unkown	Process Time (sec.) Given
minimum
maximum
average
std. dev.

Solution

Station 1 (Uniform Distribution) Station 3 (Normal Dist..) i Percentile h(p) Process Time(sec) Z-Score h(p) Process Time (sec) S1 0.300959 1594 30.0959 S3 1578 26.3023 S1 0.30438 1353 30.438 S3 1342 26.749 S1 0.314046 1444 31.4046 S3 1428 27.9716 S1 0.31773 1621 31.773 S3 1605 28.339 S1 0.343124 1605 34.3124 S3 1594 28.5264 S1 0.360289 1369 36.0289 S3 1353 28.9898 S1 0.374575 1487 37.4575 S3 1471 30.8037 S1 0.387745 1342 38.7745 S3 1326 30.8143 S1 0.418144 1535 41.8144 S3 1519 32.3141 S1 0.440258 1417 44.0258 S3 1401 35.3382 S1 0.450375 1471 45.0375 S3 1460 35.4463 S1 0.456128 1551 45.6128 S3 1535 36.0986 S1 0.465662 1503 46.5662 S3 1487 38.0539 S1 0.488106 1562 48.8106 S3 1551 38.4679 S1 0.499863 1401 49.9863 S3 1385 39.1737 S1 0.506527 1519 50.6527 S3 1503 39.4027 S1 0.513245 1460 51.3245 S3 1444 39.7996 S1 0.517713 1578 51.7713 S3 1562 41.3397 S1 0.539361 1385 53.9361 S3 1369 44.5993 S1 0.54321 1428 54.321 S3 1417 47.3833 Minmum 30.0959 26.3023 Maximum 54.321 47.3833 Average 42.7072 34.79567 Std.dev 8.114906194 6.022589443 The Min , Max, Avg and Std. Dev can be found by following functions in EXCEL 2013 Minmum =MIN(Row1:Row20) Maximum=MAX(Row1:Row20) Average=AVERAGE(Row1:Row20) Std.Dev=STDEVPA(Row1:Row20)