NO PLAGIARISM, MUST BE ORIGINAL WORK!!!!
THIS IS A 2 PART ASSIGHNMENT
PART 1 EXCEL SHEET, MUST COMPUTE ALL PROBLEMS USING EXCEL WITH APPROPRIATE FORMULAS IN CELLS TO SHOW HOW ANSWERS WERE RECEIVED.
PART 2 WORD DOCUMENT, DEVELOP A STATISTICAL ANALYSIS 700 MINIMUM
MUST INCLUDE AT LEAST 1 IN TEXT CITATIONS WITH ALL REFERENCES LISTED IN APA FORMAT
DO NOT INCLUDE QUESTIONS IN WORD DOCUMENT
Develop a 700-word statistical analysis.
Use descriptive statistics to compute a measure of performance John can use to analyze his delivery performance. Find the following for your measures:
- Standard deviation
- Sample size
- Five-number summary on the total time
Conduct a formal hypothesis testing to help John decide whether to offer the delivery guarantee or not.
Estimate the probability of an order taking longer than 30 minutes.
Make a recommendation in a short narrative including the following:
- Based on the sampled data, should John offer the guarantee?
- What percent of the Saturday deliveries would result in a customer receiving a free order?
- What recommendations might help John improve his Saturday delivery times?
Format your assignment consistent with APA format.