1.
5/5 points
Last Response 
Show Details
All Responses
Notes
part score total submissions
1
1
1
1/4
2
2
2
1/4
3
1
1
3/5
4
1
1
2/5

5
5

The number of books shipped out daily by Amazon.com was recorded for 100 days The
data is in this
Excel file
Draw a histogram for the data as follows:
•
click on the Excel file link above
•
in the dialogue window that opens, make sure the radio button next to "Open
with" is highlighted
•
the window to the right of "Open with" should say "Microsoft Office Excel
(default)" or something similar
•
click OK to open the file in Excel
If you are using Excel 2007:
o
click on "Data" at the top of the Excel window
o
click on "Data Analysis" in the "Analysis" section of the resulting menu
ribbon (if "Data Analysis" is not listed in the "Analysis" section, see the
announcement on the class webassign page)
o
in the resulting dialogue window click Histogram, then click OK
o
in the resulting Histogram dialogue box enter the input range (i.e. the
location of the data in the spreadsheet, for example A2:A101) and click
"Chart Output" at the bottom of the window
o
then click OK
If you are using Excel 2003:
o
in the Excel menu bar click Tools, Data Analysis, Histogram (if "Data
Analysis" is not listed in the "Tools" dropdown menu, see the
announcement on the class webassign page)
o
in the resulting Histogram dialogue window enter the input range (i.e. the
location of the data in the spreadsheet, for example A2:A101) and click
"Chart Output" at the bottom of the window
o
then click OK
Question 1
. After you draw the histogram, select the choice below that describes the
data.
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
(_)
(_)
The histogram is symmetric and moundshaped, with many daily shipment
numbers around 18,000 and fewer daily shipment numbers more than 20,000 and
less than 16,000.
(_)
(_)
The histogram indicates that the interquartile range (IQR) is NOT
appropriate to use as a measure of spread for this data.
(_)
(_)
The histogram is bimodal, with many daily shipment numbers in the
10,000 to 12,000 range and 20,000 to 22,000 range but few daily shipment
amounts bewteen these ranges.
(_)
(_)
The histogram clearly shows that the median
number of books shipped
daily should NOT be used as a measure of center.
(_)
(_)
The histogram is rightskewed with most of the daily shipment numbers
less than about 17,000 and just a few daily shipment numbers greater than 21,000.
(o)
(o)
The histogram is leftskewed, with most of the books shipped daily greater
than about 21,000, but with a few daily shipments less than about 15,000.
Question 2
. What is the median number of books shipped daily by Amazon.com?
22587
22587
median
Question 3
. The value of the lower quartile Q
L
is 19208.75 (using the method for
calculating percentiles discussed in lecture). Use the method for calculating percentiles
discussed in lecture to calculate the upper quartile Q
U
.
This is the end of the preview.
Sign up
to
access the rest of the document.
 Spring '08
 reiland
 Business, Quartile, score total submissions

Click to edit the document details