Webassign 2

Webassign 2 - 1. 5/5 points Last Response | Show Details...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
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" drop-down 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.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
(_) (_) The histogram is symmetric and mound-shaped, 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 right-skewed 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 left-skewed, 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 . 25307.75
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 13

Webassign 2 - 1. 5/5 points Last Response | Show Details...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online