Assignment Exerise 3.45) employees at Rs Sam\'s Oub warehouse unit. Approximater

Question

Assignment Exerise 3.45) employees at Rs Sam's Oub warehouse unit. Approximaterly half of the layots will be data represent the percentage of hourly emploeyees laid off for 15 Sam's Club stor houty enployees (The Woltl Street Journal, January 25-26, 2014), Suppose the foilewing 55 6 4 44 6 60 62 the mean and median percentage of hourly employees being laid off at these stores Comoute t b. Compute the fest third quarties . Cempute the varance and standand deviation, Round your anewers to four decimal paces commandoptionL

Explanation / Answer

For the given data

A ) we want to calculate mean

By using Excel we can calculate mean as

Put all the data in excel worksheet then

Excel command is =AVERAGE(SELECT ALL THE DATA VALUES)

we get mean = 52

2 )

By using Excel we can calculate median as

Put all the data in excel worksheet then

Excel command is =Median(SELECT ALL THE DATA VALUES)

we get mean = 55

b) 1 ) First quartile Q1 :

By using Excel we can calculate First quartile Q1 as

Excel command is =Quartile(array,1)

we get Q1 = 44

2)

1 )Third quartile Q3 :

By using Excel we can calculate third quartile Q3 as

Excel command is =Quartile(array,3)

we get Q3 = 59.25

C ) 1 )Range = largest observation - smallest observation

= 69 - 36

= 33

2 ) Interquartile range = Q3 -Q1 = 59.25-44 = 15.25

D ) 1 ) variance : By using excel we can calculate the variance as

Excel command is =VAR.S(select all the data )

we get variance = 100.14

2 ) Standard deviation :

By using excel we can calculate the standard deviation as

Excel command is =STDEV.S(select all the data )

we get standard deviation = 10.01

E ) By using interquartile range fences we can find out the outliers

interquartile range fences = ( Q1–1.5 × IQR , Q3+1.5 × IQR  )

anything outside this range is Outlier.

Here Q1–1.5 × IQR = 44 - 1.5*15.25 = 21.125

  Q3+1.5 × IQR = 59.25+1.5*15.25 = 82.125

There is no outliers present in the data

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.