No plagiarism, must be original work!!!! this is a 2 part

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:

Mean
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

Continue to order Manage Existing Orders

Place your order

Type of paper

Academic level

Deadline

Pages (550 words)

Approximate price: $22

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.