The following table lists country code and the order to remittance (OTR) time for a firm’s software installations for the last 76 installations (from first to last). OTR is the time it takes after an order is received 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.
Using the data in the table above, answer the following questions in a Word document and submit:
- Use Excel to create a Moving Range Control Chart for each country code. Based on the control chart, does the OTR time for the country code appears to be stable? Why or why not? Copy-paste your control charts into your word document or attach your Excel file in your submission.
- Explain why the OTR uses a Moving Range Control Chart.
- What can you learn about the distribution of the installation process?
- Does it appear that the country has an impact on installation time? Why or why not