statistics for managers using microsoft excel, 7e (levine)
TRANSCRIPT
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
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
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
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
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.
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
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.
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
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
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
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
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.
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.
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
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
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
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
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
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
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
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.
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
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
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
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
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
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.
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
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.
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.
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.
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.
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.
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
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.
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.
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.
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.
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.
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
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.
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.
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.
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
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
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
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.
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
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
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
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