Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

Question 1: Using the data given below, complete Task 1 and provide a very brief, general description of whether or not you believe NEWS is effectively satisfying their customer's desired shipment date. ANSWER: Question 2: Using the data given below, complete Task 2 and provide a brief statistical description of how the results relate to the customer's requirements. NOTE: A statistically significant answer to the question requires a hypothesis test using inferential statistics, which is not required.

/in /by
 NEWS customers require a delivery time of 30 days at their door from the date that the order was received. 
 NEWS has provided data of their last 50 shipments:  Duration = Delivery Date at the Door – Date Order was Received    
 Question 1:  Using the data given below, complete Task 1 and provide a very brief, general description of whether or not you believe 
 NEWS is effectively satisfying their customer’s desired shipment date. 
 ANSWER:   
 
 
 Question 2:  Using the data given below, complete Task 2 and provide a brief statistical description of how the results 
 relate to the customer’s requirements. 
 NOTE:  A statistically significant answer to the question requires a hypothesis test using inferential statistics, which is not required. 
 ANSWER:   
 
 
 
 
 Order Duration (Calendar Days)             
          1 11 
          2 30  Task 1:  Create a Histogram 
          3 19  Step 1: Select DATA from the tool bar above and then the DATA ANAYSIS TOOL icon on the far right. 
          4 35  Step 2: Select HISTOGRAM, and in the Input Range, highlight the column of DURATION (Calendar Days).   
          5 13  Step 3: Leave the Bin Blank (Excel will determine this for you). In “New Worksheet Ply” type “Histogram Bins” 
          6 39  Step 4: Excel creates a new Worksheet named Histogram Bins with a count of each data point per Bin. 
          7 4  Step 5: In the Histogram Bin worksheet, highlight the data and then select the Quick Analysis icon.   
          8 23  Step 6: Select Charts. Select Clustered Vertical Bars and then repeat and select Lines.   
          9 34  Step 7: The first provides a Histogram; the second provides a Frequency Plot. 
        10 37  Place the Histogram and Frequency Plot side by side below this row 

"Order a similar paper and get 15% discount on your first order with us
Use the following coupon
"FIRST15"

Order Now