The number of weekly sales calls by a sample of 25 pharmaceutical salespersons is below. 24, 56, 43, 35, 37, 27, 29, 44, 34, 28, 33, 28, 46, 31, 38, 41, 48, 38, 27, 29, 37, 33, 31, 40, 50 What is the shape of the distribution of the data?
please expalin how you use this on excel in step by step
Step 1 : Enter data in excel in a single column
Step 2 : calculate five number summary for that use function
Minimum = QUARTILE.INC(data range, 0)
Quartile 1 =QUARTILE.INC(datarange,1)
Quartile 2 =QUARTILE.INC(datarange,2)
Quartile 3 =QUARTILE.INC(datarange,3)
Maximum =QUARTILE.INC(datarange,4)
So we get excel output
Therefore,
We get
Q3 - Q2 = 6
Q2 - Q1 = 6
We get
Q3 -Q2 = Q2 - Q1
Hence shape of distribution is symmetric distribution.
Thank you!
Get Answers For Free
Most questions answered within 1 hours.