Use the following data to answer questions 7 - 9: A sample of employees participated in a survey of job satisfaction provided information about their...
View the step-by-step solution to:

Question


Use the following data to answer questions 7 - 9:

A sample of employees participated in a

survey of job satisfaction provided information about their hourly wages as the following:

11 14 19 11 17

20 25 11 16 17

14 22 12 24 29

16 18 18 11 21

20 11 29 24 23

14 28 19 29 14

20 26 23 24 18

18 23 20 29 12

23 18 25 26 27

28 22 11 25 19


1)   What is the 60th percentile of the employee hourly wages? Use the method explained in textbook for answering this question (using excel).

A.   26

B.   26.3

C.   22

D.   27


2)   What is the standard deviation of hourly wages for this sample of employees (using excel)?

A.   35.22

B.   24.8

C.   6.18

D.   5.66


Use this information to answer questions 10 and 11:

Kangaroo trucking Inc. keeps mileage records when changing tires to determine the average life of each brand, in order to optimize their costs of purchasing and replacing tires. Lifetime of a tire depends on quality of the tire, quality of the road, temperature, and weight of the cargo. During the past 12 months AFC have collected data about a new type of Bonafici tires, summarized as the following:



Mileage used Number of tires

40000 to under 45000 175

45000 to under 50000 173

50000 to under 55000 170

55000 to under 60000 160

60000 to under 65000 209

65000 to under 70000 229


10) What is the average life of each tire?  

A. Less than 50,000 miles 

B. 53082.75

C. 55824.37

D. Greater than or 60,000 miles


11) What is the standard deviation of recorded mileages for these tires?

A. Less than 7,000 miles 

B. 7324.74

C. 7700.54

D. Greater than 8,500 miles


Use the following data to answer questions 12 - 14:

This table lists ALL ice cream flavors sold at Billy Bob's Ice Cream shop in Apple, Iowa and the number of gallons of each sold during this year and last year's summer.



Flavor

Total Gallons Sold This Summer Total Gallons Sold Last Summer

   Vanilla              37,259  55,343                 

Chocolate                107,948  76,855      


Strawberry 25,539 22,436

                 

Maple Walnut 15,618 11432

                

Praline   19,512 14,609

Butter Pecan 8836 16,253

Chocolate Chip 36,889 35,395

Mint Chocolate Chip 16,167 18,935

Cookie Dough 24,674 23443

                 

Rocky Road 18,103   16,496

Fudge Swirl 21,637   18,394

Peach  21,979 23,504


1)   Find the interquartile range (IQR) for last year sales of different flavors, using excel. This value is:

A.   Less than 12,000

B.   12750

C.   16108.5

D.   Greater than 17,000


2)   Consider this year's sales only. What is the Z score for Maple Walnut flavor sales?

A.   -0.56

B.   0.56

C.   2.32

D.   6.87


3)   Which year's sales statistics are more consistent?

A.   Last summer, because variance of sales for last summer is smaller than this year's sales

B.   Current summer, because standard deviation of sales is greater than last year's sales    

C.   Current summer, because coefficient of variation for current summer is greater than last year

D.   Last summer, because coefficient of variation for this summer is greater than last summer

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes