Discussion | Statistics homework help

 

Use the attached template to answer the following questions.

Homework Assignment 5

Due in Week 6 and worth 30 points.

The data in the table below lists country code and the order to remittance (OTR) time for hardware/software installations for the last 76 installations (from first to last). OTR is the time it takes from an order being placed until the system is installed and payment is received (remittance). Because this company does business internationally, it also notes the country of installation using a country code. This code is listed in the first column.

In this assignment you will create control charts for the following data for each country code.

1. Compute the average cycle time for each country code.

2. Compute the moving range for each country code.

3. Compute the confidence interval for each using the average cycle time plus or minus the product of 2.66 times the average moving range for each country code.

4. Turn in the spreadsheet with calculations.

5. Does the OTR time appear to be stable?  Why or why not?

6. If you were to use a control chart to evaluate stability, which chart would you use?  Why?

7. What can you learn about the distribution of the installation process? 

8. Does it appear that the country has an impact on installation time? Why or why not?

Below is the list of country codes and the cycle time for each.

Country code     Cycle time

1                         65

1                         53

1                         46

1                         45

1                         66

1                         45

1                         31

1                       31

1                       32

1                       65

1                       50

1                       42

1                       30

1                       42

1                       20

1                       75

1                       52

1                       40

1                       44

1                       87

1                       86

1                       45

1                       75

1                       56

1                       75

5                       68

5                       64

5                       70

5                       75

5                       70

5                       50

5                       50

5                       75 

6                       64

6                       36

6                       60

6                       35

6                       45

6                       47

6                       46

6                       46

7                       45

7                       56

7                       41

7                       40

7                       60

7                       53

7                       26

7                       50

7                       30

7                       61

7                       88

7                       42

7                       44

7                       40

7                       53

7                       53

7                       48

8                       43

8                       60

8                       33

8                       42

8                       46

8                       47

14                     56

14                     84

14                     46

14                     56

14                     42

17                     26

17                     25

17                     21

17                     35

17                     62

17                     46

17                     45

Instructions

For each country code you will answer the following questions: 

In this assignment you will create control charts for the following data for each country code.

1. Compute the average cycle time for each country code.

2. Compute the moving range for each country code.

3. Compute the confidence interval for each using the average cycle time plus or minus the product of 2.66 times the average moving range for each country code.

4. Turn in the spreadsheet with calculations.

5. Does the OTR time appear to be stable?  Why or why not?

6. If you were to use a control chart to evaluate stability, which chart would you use?  Why?

7. What can you learn about the distribution of the installation process? 

8. Does it appear that the country has an impact on installation time? Why or why not?

Use the excel template provided by the instructor and use this along with the instructional video to solve for each response per country code.

Once done, you will use the responses in the template which you generate to respond to the questions asked for each country code.

ExpandQuestion Completion Status:

QUESTION 1

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Australia Assessments
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
English 101
I don’t have any comment it’s very good
Customer 454499, June 17th, 2020
Marketing & Advertising
Well researched paper. Fresh and Informative
Customer 463369, September 22nd, 2022
Nursing
Thank you so much for the great paper!
Customer 454007, May 31st, 2020
Human Resources Management (HRM)
Excellent!
Customer 462613, April 10th, 2022
NURSING
This writer did a wonderful job.
Customer 458101, January 19th, 2022
Business and administrative studies
Commendable. Review credentials alignment in APA cover page. Student paper https://owl.purdue.edu/owl/research_and_citation/apa_style/apa_formatting_and_style_guide/apa_sample_paper.html
Customer 453187, March 31st, 2022
Literature
Beautifully written essay!
Customer 462241, November 25th, 2021
Retail
great
Customer 463473, November 14th, 2022
Marketing & Advertising
Excellent work. Looking forward to your future contributions.
Customer 463467, December 1st, 2022
Business and administrative studies
Perfect!
Customer 459467, May 1st, 2022
Business Studies
good
Customer 453413, April 26th, 2020
English 101
Great work.
Customer 456823, May 15th, 2022
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat