statistics for managers using microsoft excel, 7e (levine)

51
7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine) http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 1/51

Upload: bibichaw

Post on 10-Feb-2018

227 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 1/51

Page 2: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 2/51

Page 3: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 3/51

Page 4: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 4/51

Page 5: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 5/51

AB8E 2/2

At a meetin" of information systems officers for re"ional offices of a national company' a sur%ey was ta#en todetermine the number of employees the officers super%ise in the operation of their departments' where X  is thenumber of employees o%erseen by each information systems officer.

 X f1 72 - 11( - >

1>) 5eferrin" to able 2/2' how many re"ional offices are represented in the sur%ey results$A) -B) 11C) 1-D) (Answer: DDifficulty: Easy

Keywords: interpretation' freuency distribution

2) 5eferrin" to able 2/2' across all of the re"ional offices' how many total employees were super%ised by thosesur%eyed$A) 1-B) (C) 127D) 2Answer: CDifficulty: &oderateKeywords: interpretation' freuency distribution

21) he width of each bar in a histo"ram corresponds to the

A) differences between the boundaries of the class.B) number of obser%ations in each class.C) midpoint of each class.D) percenta"e of obser%ations in each class.Answer: ADifficulty: EasyKeywords: freuency distribution

2/-

Copyri"ht 0 21( earson Education' nc.

Page 6: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 6/51

Page 7: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 7/51

2() A professor of economics at a small e+as uni%ersity wanted to determine what year in school students wereta#in" his tou"h economics course. 9hown below is a pie chart of the results. !hat percenta"e of the class too# thecourse prior to reachin" their senior year$

A) 1(FB) ((FC) -(FD) 3FAnswer: DDifficulty: EasyKeywords: interpretation' pie chart

2-) !hen poly"ons or histo"rams are constructed' which a+is must show the true Gero or Hori"inH$A) he horiGontal a+isB) he %ertical a+isC) Both the horiGontal and %ertical a+esD) either the horiGontal nor the %ertical a+isAnswer: BDifficulty: EasyKeywords: poly"on' histo"ram

23) !hen constructin" charts' the followin" is plotted at the class midpoints:A) freuency histo"rams.B) percenta"e poly"ons.C) cumulati%e percenta"e poly"on ;o"i%es).D) All of the abo%e.Answer: BDifficulty: EasyKeywords: percenta"e poly"on

2/7

Copyri"ht 0 21( earson Education' nc.

Page 8: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 8/51

Page 9: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 9/51

Page 10: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 10/51

Page 11: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 11/51

Page 12: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 12/51

(1) ?ne of the de%elopin" countries is e+periencin" a baby boom' with the number of births risin" for the fifth yearin a row' accordin" to a BBC ews report. !hich of the followin" is best for displayin" this data$A) A areto chartB) A two/way classification tableC) A histo"ramD) A time/series plotAnswer: DDifficulty: EasyKeywords: time/series plot

(2) !hen studyin" the simultaneous responses to two cate"orical uestions' you should set up aA) contin"ency tableB) freuency distribution tableC) cumulati%e percenta"e distribution tableD) histo"ramAnswer: ADifficulty: EasyKeywords: contin"ency table

() Data on 1'- studentsI hei"ht were collected at a lar"er uni%ersity in the East Coast. !hich of the followin" isthe best chart for presentin" the information$A) a pie chartB) a areto chartC) a side/by/side bar chartD) a histo"ramAnswer: DDifficulty: EasyKeywords: choice of chart' histo"ram

(() Data on the number of part/time hours students at a public uni%ersity wor#ed in a wee# were collected. !hich ofthe followin" is the best chart for presentin" the information$A) a pie chartB) a areto chart

C) a percenta"e tableD) a percenta"e poly"onAnswer: DDifficulty: EasyKeywords: choice of chart' percenta"e poly"on

2/12

Copyri"ht 0 21( earson Education' nc.

Page 13: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 13/51

(-) Data on the number of credit hours of 2' students at a public uni%ersity enrolled in a sprin" semester werecollected. !hich of the followin" is the best for presentin" the information$A) a pie chartB) a areto chartC) a stem/and/leaf displayD) a contin"ency tableAnswer: CDifficulty: EasyKeywords: choice of chart' stem/and/leaf 

(3) A sur%ey of 1- e+ecuti%es were as#ed what they thin# is the most common mista#e candidates ma#e durin" *obinter%iews. 9i+ different mista#es were "i%en. !hich of the followin" is the best for presentin" the information$A) a bar chart.B) a histo"ramC) a stem/and/leaf displayD) a contin"ency tableAnswer: ADifficulty: EasyKeywords: choice of chart' bar chart

(7) ou ha%e collected information on the mar#et share of - different search en"ines used by 6.9. nternet users in a particular uarter. !hich of the followin" is the best for presentin" the information$A) a pie chartB) a histo"ramC) a stem/and/leaf displayD) a contin"ency tableAnswer: ADifficulty: EasyKeywords: choice of chart' pie chart

() ou ha%e collected information on the consumption by the 1- lar"est coffee/consumin" nations. !hich of thefollowin" is the best for presentin" the shares of the consumption$A) a pie chart

B) a areto chartC) a side/by/side bar chartD) a contin"ency tableAnswer: BE+planation: B) ?E: E%en thou"h a pie chart can also be used' the areto chart is preferable for separatin" theH%ital fewH from the Htri%ial many.HDifficulty: &oderateKeywords: choice of chart' areto chart

2/1

Copyri"ht 0 21( earson Education' nc.

Page 14: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 14/51

Page 15: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 15/51

Page 16: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 16/51

Page 17: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 17/51

Page 18: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 18/51

Page 19: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 19/51

Page 20: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 20/51

Page 21: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 21/51

AB8E 2/>

he freuency distribution below represents the rents of 2- randomly selected federally subsidiGed apartments in asmall town.

5ent in J 4reuency

1'1 but less than 1'2 111'2 but less than 1' -

1' but less than 1'( 2

1'( but less than 1'- 13

1'- but less than 1'3 (

) 5eferrin" to able 2/>' ======== apartments rented for at least J1'2 but less than J1'(.Answer: 117Difficulty: EasyKeywords: freuency distribution

1) 5eferrin" to able 2/>' ======== of the apartments rented for J1'( or more.Answer: F or 22-

Difficulty: EasyKeywords: freuency distribution' cumulati%e percenta"e distribution

2) 5eferrin" to able 2/>' ======== of the apartments rented for at least J1'.Answer: 2.F or -22-Difficulty: &oderateKeywords: freuency distribution' cumulati%e percenta"e distribution

) 5eferrin" to able 2/>' the class midpoint of the second class is ========.Answer: 1'2-Difficulty: EasyKeywords: freuency distribution' class midpoint

() 5eferrin" to able 2/>' the relati%e freuency of the second class is ========.Answer: -2- or 17- or (F or .(Difficulty: EasyKeywords: freuency distribution' relati%e freuency distribution

-) 5eferrin" to able 2/>' the percenta"e of apartments rentin" for less than J1'( is ========.Answer: 22- or 22- or >2F or .>2Difficulty: &oderateKeywords: freuency distribution' cumulati%e percenta"e distribution

2/21

Copyri"ht 0 21( earson Education' nc.

Page 22: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 22/51

Page 23: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 23/51

Page 24: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 24/51

Page 25: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 25/51

Page 26: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 26/51

Page 27: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 27/51

1>) rue or 4alse: n "eneral' "rouped freuency distributions should ha%e between - and 1- class inter%als.Answer: 56EDifficulty: EasyKeywords: freuency distribution' number of classes

11) rue or 4alse: he sum of relati%e freuencies in a distribution always euals 1.Answer: 56EDifficulty: EasyKeywords: relati%e freuency

111) rue or 4alse: he sum of cumulati%e freuencies in a distribution always euals 1.Answer: 4A89EDifficulty: &oderateKeywords: cumulati%e distribution

112) rue or 4alse: n "raphin" two cate"orical data' the side/by/side bar chart is best suited when comparin" *ointresponses.Answer: 56EDifficulty: &oderateKeywords: side/by/side bar chart

11) rue or 4alse: !hen constructin" a freuency distribution' classes should be selected so that they are of eualwidth.Answer: 56EDifficulty: EasyKeywords: freuency distribution

11() rue or 4alse: A research analyst was directed to arran"e raw data collected on the yield of wheat' ran"in"from ( to > bushels per acre' in a freuency distribution. ,e should choose as the class inter%al width.Answer: 4A89EDifficulty: EasyKeywords: freuency distribution' class inter%al

11-) rue or 4alse: f the %alues of the se%enth and ei"hth class in a cumulati%e percenta"e distribution are the same'we #now that there are no obser%ations in the ei"hth class.Answer: 56EDifficulty: &oderateKeywords: cumulati%e percenta"e distribution

113) rue or 4alse: ?ne of the ad%anta"es of a pie chart is that it clearly shows that the total of all the cate"ories ofthe pie adds to 1F.Answer: 56EDifficulty: EasyKeywords: pie chart

2/27

Copyri"ht 0 21( earson Education' nc.

Page 28: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 28/51

Page 29: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 29/51

12-) rue or 4alse: he main principle behind the areto chart is the ability to separate the H%ital fewH from theHtri%ial many.HAnswer: 56EDifficulty: EasyKeywords: areto chart

123) rue or 4alse: A histo"ram can ha%e "aps between the bars' whereas bar charts cannot ha%e "aps.Answer: 4A89EDifficulty: EasyKeywords: histo"ram' bar chart

127) rue or 4alse: ,isto"rams are used for numerical data while bar charts are suitable for cate"orical data.Answer: 56EDifficulty: EasyKeywords: histo"ram' bar chart

12) rue or 4alse: A !almart store in a small town monitors customer complaints and or"aniGes these complaintsinto si+ distinct cate"ories. ?%er the past year' suppose the company has recei%ed -( complaints. ?ne possible"raphical method for representin" these data would be a areto chart.Answer: 56E

Difficulty: &oderateKeywords: areto chart

12>) rue or 4alse: Apple Computer' nc. collected information on the a"e of their customers. 9uppose the youn"estcustomer was 12 and the oldest was 72. o study the distribution of the a"e amon" its customers' it can use a aretochart.Answer: 4A89EDifficulty: &oderateKeywords: areto chart

1) rue or 4alse: Apple Computer' nc. collected information on the a"e of their customers. 9uppose the youn"estcustomer was 12 and the oldest was 72. o study the distribution of the a"e amon" its customers' it is best to use a pie chart.

Answer: 4A89EDifficulty: &oderateKeywords: pie chart

11) rue or 4alse: Apple Computer' nc. collected information on the a"e of their customers. 9uppose the youn"estcustomer was 12 and the oldest was 72. o study the distribution of the a"e amon" its customers' it can use a percenta"e poly"on.Answer: 56EDifficulty: &oderateKeywords: percenta"e poly"on

2/2>

Copyri"ht 0 21( earson Education' nc.

Page 30: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 30/51

12) rue or 4alse: Apple Computer' nc. collected information on the a"e of their customers. 9uppose the youn"estcustomer was 12 and the oldest was 72. o study the percenta"e of their customers who are below a certain a"e' itcan use an o"i%e.Answer: 56EDifficulty: &oderateKeywords: o"i%e

1) rue or 4alse: f you wish to construct a "raph of a relati%e freuency distribution' you would most li#elyconstruct an o"i%e first.Answer: 4A89EDifficulty: &oderateKeywords: o"i%e

1() rue or 4alse: An o"i%e is a cumulati%e percenta"e poly"on.Answer: 56EDifficulty: EasyKeywords: o"i%e' cumulati%e percenta"e poly"on

1-) rue or 4alse: A side/by/side bar chart is two histo"rams plotted side/by/side.Answer: 4A89E

Difficulty: &oderateKeywords: side/by/side bar chart

13) rue or 4alse: A "ood choice for the number of class "roups to use in constructin" freuency distribution is toha%e at least - but no more than 1- class "roups.Answer: 56EDifficulty: EasyKeywords: number of classes

17) rue or 4alse: n "eneral' a freuency distribution should ha%e at least class "roups but no more than 2.Answer: 4A89EDifficulty: EasyKeywords: number of classes

1) rue of 4alse: o determine the width of class inter%al' di%ide the number of class "roups by the ran"e of thedata.Answer: 4A89EDifficulty: EasyKeywords: class inter%al

1>) rue or 4alse: he percenta"e poly"on is formed by ha%in" the lower boundary of each class represent the datain that class and then connectin" the seuence of lower boundaries at their respecti%e class percenta"es.Answer: 4A89EDifficulty: EasyKeywords: percenta"e poly"on

1() rue or 4alse: A poly"on can be constructed from a bar chart.Answer: 4A89EDifficulty: &oderateKeywords: poly"on

1(1) o e%aluate two cate"orical %ariables at the same time' a ======== could be de%eloped.Answer: contin"ency or cross/classification table or side/by/side bar chartDifficulty: EasyKeywords: contin"ency table' cross/classification table

1(2) 5elationships in a contin"ency table can be e+amined more fully if the freuencies are con%erted into

2/

Copyri"ht 0 21( earson Education' nc.

Page 31: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 31/51

 ========.Answer: percenta"es or proportionsDifficulty: EasyKeywords: contin"ency table

AB8E 2/12

he table below contains the opinions of a sample of 2 people bro#en down by "ender about the latestcon"ressional plan to eliminate anti/trust e+emptions for professional baseball.

For Neutral Against Totals

4emale -( 12 1(

Male 12 3 ( >3

Totals - > 3 2

1() 5eferrin" to able 2/12' construct a table of row percenta"es.Answer:

For Neutral Against Totals

4emale 3.-( -1.>2 11.-( 1.&ale 12.- 7.- -. 1.

otals 2-. (-. . 1.

Difficulty: EasyKeywords: row percenta"es

1(() 5eferrin" to able 2/12' construct a table of column percenta"es.Answer:

For Neutral Against Totals

4emale 73. 3. 2. -2.

&ale 2(. (. . (.

otals 1. 1. 1. 1.

Difficulty: EasyKeywords: column percenta"es

2/1

Copyri"ht 0 21( earson Education' nc.

Page 32: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 32/51

1(-) 5eferrin" to able 2/12' construct a table of total percenta"es.Answer:

For Neutral Against Totals

4emale 1>. 27. 3. -2.

&ale 3. 1. 2(. (.

otals 2-. (-. . 1.

Difficulty: EasyKeywords: total percenta"es

1(3) 5eferrin" to able 2/12' of those for the plan in the sample' ======== percent were females.Answer: 73Difficulty: &oderateKeywords: contin"ency table' column percenta"es

1(7) 5eferrin" to able 2/12' of those neutral in the sample' ======== percent were males.Answer: (Difficulty: &oderateKeywords: contin"ency table' column percenta"es

1() 5eferrin" to able 2/12' of the males in the sample' ======== percent were for the plan.Answer: 12.-Difficulty: &oderateKeywords: contin"ency table

1(>) 5eferrin" to able 2/12' of the females in the sample' ======== percent were a"ainst the plan.Answer: 11.-(Difficulty: &oderateKeywords: contin"ency table

1-) 5eferrin" to able 2/12' of the females in the sample' ======== percent were either neutral or a"ainst the plan.Answer: 3.(3 or ;-1.>2 M 11.-()Difficulty: &oderate

Keywords: contin"ency table

1-1) 5eferrin" to able 2/12' ======== percent of the 2 were females who were a"ainst the plan.Answer: 3Difficulty: &oderateKeywords: contin"ency table

1-2) 5eferrin" to able 2/12' ======== percent of the 2 were males who were neutral.Answer: 1Difficulty: &oderateKeywords: contin"ency table

2/2

Copyri"ht 0 21( earson Education' nc.

Page 33: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 33/51

1-) 5eferrin" to able 2/12' ======== percent of the 2 were females who were either neutral or a"ainst the plan.Answer: Difficulty: DifficultKeywords: contin"ency table

1-() 5eferrin" to able 2/12' ======== percent of the 2 were males who were not a"ainst the plan.Answer: 2(Difficulty: DifficultKeywords: contin"ency table

1--) 5eferrin" to able 2/12' ======== percent of the 2 were not neutral.Answer: --Difficulty: DifficultKeywords: contin"ency table' row percenta"es

1-3) 5eferrin" to able 2/12' ======== percent of the 2 were a"ainst the plan.Answer: Difficulty: &oderateKeywords: contin"ency table' row percenta"es

1-7) 5eferrin" to able 2/12' ======== percent of the 2 were males.Answer: (Difficulty: EasyKeywords: contin"ency table' column percenta"es

1-) 5eferrin" to able 2/12' if the sample is a "ood representation of the population' we can e+pect ======== percent of the population will be for the plan.Answer: 2-Difficulty: &oderateKeywords: contin"ency table' row percenta"es

1->) 5eferrin" to able 2/12' if the sample is a "ood representation of the population' we can e+pect ======== percent of the population will be males.

Answer: (Difficulty: &oderateKeywords: contin"ency table' column percenta"es

13) 5eferrin" to able 2/12' if the sample is a "ood representation of the population' we can e+pect ======== percent of those for the plan in the population will be males.Answer: 2(Difficulty: &oderateKeywords: contin"ency table

2/

Copyri"ht 0 21( earson Education' nc.

Page 34: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 34/51

Page 35: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 35/51

133) 5eferrin" to able 2/1' if a relati%e freuency or percenta"e distribution for the deter"ent data is constructed'usin" H>. but less than 1. "allonsH as the first class' what percenta"e of dri%e/throu"h car wash operations use atleast 1 "allons of deter"ent in a day$Answer: FDifficulty: EasyKeywords: relati%e freuency distribution' percenta"e distribution

137) 5eferrin" to able 2/1' if a relati%e freuency or percenta"e distribution for the deter"ent data is constructed'usin" H>. but less than 1. "allonsH as the first class' what percenta"e of dri%e/throu"h car wash operations use atleast 1 "allons but less than 1 "allons of deter"ent in a day$Answer: FDifficulty: EasyKeywords: relati%e freuency distribution' percenta"e distribution

13) 5eferrin" to able 2/1' construct a freuency distribution for the deter"ent data' usin" H>. but less than 1."allonsH as the first class.Answer:

urchases ;"als) 4reuency

>. but less than 1.

1. but less than 11. -

11. but less than 12. >

12. but less than 1. 3

1. but less than 1(. 2

Difficulty: &oderateKeywords: freuency distribution

13>) 5eferrin" to able 2/1' construct a relati%e freuency or percenta"e distribution for the deter"ent data' usin"H>. but less than 1.H as the first class.Answer:

Nasolineurchases ;"als) ercenta"e

>. but less than 1. 12F

1. but less than 11. 2

11. but less than 12. 3

12. but less than 1. 2(

1. but less than 1(.

Difficulty: &oderateKeywords: relati%e freuency distribution' percenta"e distribution

2/-

Copyri"ht 0 21( earson Education' nc.

Page 36: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 36/51

17) 5eferrin" to able 2/1' construct a cumulati%e percenta"e distribution for the deter"ent data if thecorrespondin" freuency distribution uses H>. but less than 1.H as the first class.Answer:

Nasolineurchases ;"als)

4reuency8ess han

ercenta"e8ess han

>. but less than 1. 12

1. but less than 11. 211. but less than 12. 17 3

12. but less than 1. 2 >2

1. but less than 1(. 2- 1

 Difficulty: &oderateKeywords: cumulati%e percenta"e distribution

171) 5eferrin" to able 2/1' construct a percenta"e histo"ram for the deter"ent data' usin" H>. but less than 1.Has the first class.Answer:

Difficulty: &oderateKeywords: histo"ram' freuency distribution

2/3

Copyri"ht 0 21( earson Education' nc.

Page 37: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 37/51

172) 5eferrin" to able 2/1' construct a cumulati%e percenta"e poly"on for the deter"ent data if the correspondin"freuency distribution uses H>. but less than 1.H as the first class.Answer:

Difficulty: &oderate

Keywords: cumulati%e percenta"e poly"on

17) 5eferrin" to able 2/1' construct a percenta"e poly"on for the deter"ent data if the correspondin" freuencydistribution uses H>. but less than 1.H as the first class.Answer:

Difficulty: &oderateKeywords: percenta"e distribution' percenta"e poly"on

2/7

Copyri"ht 0 21( earson Education' nc.

Page 38: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 38/51

AB8E 2/1(

he table below contains the number of people who own a portable Blu/ray player in a sample of 3 bro#en down by "ender.

Own a orta!le

"lu#ra$ pla$er Male Fe%ale&es >3 (

No 22( 2(

17() 5eferrin" to able 2/1(' construct a table of row percenta"es.Answer:

Own Male Fe%ale Total

&es 7.->F 2>.(1F 1.F

No (.2F -1.72F 1.F

Total -.F (3.37F 1.F

Difficulty: EasyKeywords: row percenta"es

17-) 5eferrin" to able 2/1(' construct a table of column percenta"es.Answer:

Own Male Fe%ale Total

&es .F 1(.2>F 22.37F

No 7.F -.71F 77.F

Total 1.F 1.F 1.F

Difficulty: EasyKeywords: column percenta"es

173) 5eferrin" to able 2/1(' construct a table of total percenta"es.Answer:

Own Male Fe%ale Total&es 13.F 3.37F 22.37F

No 7.F (.F 77.F

Total -.F (3.37F 1.F

Difficulty: EasyKeywords: total percenta"es

177) 5eferrin" to able 2/1(' of those who owned a portable Blu/ray player in the sample' ======== percent werefemales.Answer: 2>.(1Difficulty: &oderateKeywords: contin"ency table' row percenta"es

2/

Copyri"ht 0 21( earson Education' nc.

Page 39: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 39/51

17) 5eferrin" to able 2/1(' of those who did not own a portable Blu/ray player in the sample' ======== percentwere males.Answer: (.2Difficulty: &oderateKeywords: contin"ency table' row percenta"es

17>) 5eferrin" to able 2/1(' of the males in the sample' ======== percent owned a portable Blu/ray player.Answer: Difficulty: &oderateKeywords: contin"ency table' column percenta"es

1) 5eferrin" to able 2/1(' of the females in the sample' ======== percent did not own a portable Blu/ray player.Answer: -.71Difficulty: &oderateKeywords: contin"ency table' column percenta"es

11) 5eferrin" to able 2/1(' of the females in the sample' ======== percent owned a portable Blu/ray player.Answer: 1(.2>Difficulty: &oderateKeywords: contin"ency table' column percenta"es

12) 5eferrin" to able 2/1(' ======== percent of the 3 were females who owned a portable Blu/ray player.Answer: 3.37Difficulty: &oderateKeywords: contin"ency table' total percenta"e

1) 5eferrin" to able 2/1(' ======== percent of the 3 were males who owned a portable Blu/ray player.Answer: 13Difficulty: &oderateKeywords: contin"ency table' total percenta"e

1() 5eferrin" to able 2/1(' ======== percent of the 3 were females who either owned or did not own a portable Blu/ray player.

Answer: (3.37Difficulty: &oderateKeywords: contin"ency table' total percenta"e

1-) 5eferrin" to able 2/1(' ======== percent of the 3 were males who did not own a portable Blu/ray player.Answer: 7.Difficulty: &oderateKeywords: contin"ency table' total percenta"e

13) 5eferrin" to able 2/1(' ======== percent of the 3 owned a portable Blu/ray player.Answer: 22.37Difficulty: &oderateKeywords: contin"ency table' column percenta"es

17) 5eferrin" to able 2/1(' ======== percent of the 3 did not own a portable Blu/ray player.Answer: 77.Difficulty: &oderateKeywords: contin"ency table' column percenta"es

1) 5eferrin" to able 2/1(' ======== percent of the 3 were females.Answer: (3.37Difficulty: EasyKeywords: contin"ency table' row percenta"es

2/>

Copyri"ht 0 21( earson Education' nc.

Page 40: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 40/51

Page 41: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 41/51

AB8E 2/1-

he fi"ure below is the o"i%e for the amount of fat ;in "rams) for a sample of 3 piGGa products where the upper boundaries of the inter%als are: -' 1' 1-' 2' 2-' and .

1>() 5eferrin" to able 2/1-' rou"hly what percenta"e of piGGa products contains less than 1 "rams of fat$A) FB) 1(FC) -FD) 7-FAnswer: BDifficulty: EasyKeywords: cumulati%e percenta"e poly"on' o"i%e' interpretation

1>-) 5eferrin" to able 2/1-' what percenta"e of piGGa products contains at least 2 "rams of fat$A) -FB) 2-F

C) 7-FD) >3FAnswer: BDifficulty: EasyKeywords: cumulati%e percenta"e poly"on' o"i%e' interpretation

1>3) 5eferrin" to able 2/1-' what percenta"e of piGGa products contains between 1 and 2- "rams of fat$A) 1(FB) ((FC) 32FD) 1FAnswer: DDifficulty: EasyKeywords: cumulati%e percenta"e poly"on' o"i%e' interpretation

2/(1

Copyri"ht 0 21( earson Education' nc.

Page 42: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 42/51

AB8E 2/13

he fi"ure below is the percenta"e poly"on for the amount of calories for a sample of 3 piGGa products where theupper limits of the inter%als are: 1' (' 7' ( and (.

1>7) 5eferrin" to able 2/13' rou"hly what percenta"e of piGGa products contains between ( and ( calories$A) FB) 11FC) >FD) 1FAnswer: BDifficulty: EasyKeywords: percenta"e poly"on' interpretation

1>) 5eferrin" to able 2/13' rou"hly what percenta"e of piGGa products contains between ( and ( calories$A) 22FB) 2-FC) 2FD) -FAnswer: DDifficulty: &oderateKeywords: percenta"e poly"on' interpretation

1>>) 5eferrin" to able 2/13' rou"hly what percenta"e of piGGa products contains at least ( calories$A) 2-FB) 2FC) >FD) 31FAnswer: DDifficulty: &oderateKeywords: percenta"e poly"on' interpretation

2/(2

Copyri"ht 0 21( earson Education' nc.

Page 43: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 43/51

AB8E 2/17

he followin" table presents total retail sales in millions of dollars for the leadin" apparel companies o%er a two/year period.

AA'L COMAN& &ear &ear 2

Nap 1'1->. >32PQ 71.7 >>

8imited ->3.- 32.(

KohlIs -((.> 37.>

 ordstrom (2.3 (1.

albots 1>.> 1.1

Annaylor 11(.2 12(.

2) 5eferrin" to able 2/17' construct a table of column percenta"es.Answer:

Apparel Co%pan$ &ear &ear 2

Nap 1.F 2-.>F

PQ 2.>1F 2.(-F

8imited 1-.>-F 13.1FKohlIs 1(.-7F 17.71F

 ordstrom 1.77F 1.>1F

albots .7(F .>F

Annaylor .-F .23F

otal 1.F 1.F

Difficulty: &oderateKeywords: column percenta"es

2/(

Copyri"ht 0 21( earson Education' nc.

Page 44: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 44/51

Page 45: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 45/51

Page 46: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 46/51

Page 47: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 47/51

21) rue or 4alse: Ni%en below is the scatter plot of the priceearnin"s ratio %ersus earnin"s per share of 2 6.9.companies. here appears to be a positi%e relationship between priceearnin"s ratio and earnin"s per share.

Answer: 4A89EDifficulty: &oderateKeywords: scatter plot

21() rue or 4alse: Ni%en below is the scatter plot of the mar#et %alue ;thousandsJ) and profit ;thousandsJ) of -6.9. companies. ,i"her mar#et %alues appear to be associated with hi"her profits.

Answer: 56EDifficulty: EasyKeywords: scatter plot

2/(7

Copyri"ht 0 21( earson Education' nc.

Page 48: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 48/51

Page 49: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 49/51

Page 50: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 50/51

Page 51: Statistics for Managers Using Microsoft Excel, 7e (Levine)

7/22/2019 Statistics for Managers Using Microsoft Excel, 7e (Levine)

http://slidepdf.com/reader/full/statistics-for-managers-using-microsoft-excel-7e-levine 51/51