Search for question
Question

5 points 1 eBook Required: Create a control chart for website response time data over the past 52 weeks. Data: Lab 10-4 Data.xlsx Specify the Question: When did average website response time begin to increase beyond acceptable times? Obtain the Data: This lab uses the data in Lab 10.4 Data.xlsx. The file consists of 52 weeks of slow response time counts for a company website. Analyze the Data: Refer to lab 10.4 in your text for additional instructions and steps. Print References Answer the following questions based on the details computed. Question 1. What is the upper control limit line value for 3 Standard Deviations? (Round to the nearest integer) 2. What is the lower control limit line value for 3 Standard Deviations? (Round to the nearest integer) 3. How many data points are outside (i.e., below) the lower control limit line for 3 Standard Deviations? 4. How many data points are outside (i.e., above) the upper control limit line for 3 Standard Deviations? 5. Which of the following interpretive statements make the most sense about the data? Answer ! 2 Part 1 of 2 5 points Required information [The following information applies to the questions displayed below.] Lab Insight: Apply the same steps in Lab 10.4 to the Alt Lab 10.4 Data.xlsx dataset. For decision-making context, please see the start of Lab 10.4. Required: Create control charts for website response time data over the past 52 weeks. Data: Alt Lab 10-4 Data.xlsx eBook Specify the Question: When did average website response time begin to increase beyond acceptable times? Print Analyze the Data: Refer to lab 10.4 in your text for additional instructions and steps. References Upload the Word or PDF document containing your Lab screenshots using the button below. Note: Please submit your file attachment response in one of the approved file formats; Word file (.doc or .docx), Excel file (.xls or .xlsx), or PDF. To submit photo or image files please paste them into Word or PDF. Consult with your instructor as needed on their preferred file attachment format. Take a screenshot of the control chart, and copy it into a Word document named "Alt Lab 10.4 Tableau Submission.docx". ! 3 Part 2 of 2 5 points Required information [The following information applies to the questions displayed below.] Lab Insight: Apply the same steps in Lab 10.4 to the Alt Lab 10.4 Data.xlsx dataset. For decision-making context, please see the start of Lab 10.4. Required: Create control charts for website response time data over the past 52 weeks. Data: Alt Lab 10-4 Data.xlsx eBook Specify the Question: When did average website response time begin to increase beyond acceptable times? Print Analyze the Data: Refer to lab 10.4 in your text for additional instructions and steps. References Answer the following questions based on the details computed. Question 1. What is the upper control limit line value rounded to the nearest integer for 1 Standard Deviation? 2. What is the upper control limit line value rounded to the nearest integer for 2 Standard Deviations? 3. What is the lower control limit line value rounded to the nearest integer for 2 Standard Deviations? 4. What happens to the "in control area" as you move from the 3 standard deviations to 1 standard deviations? 5. What happens to the number of data points that are outside of the upper control limit (i.e., above) as you move from 3 standard deviations to 1 standard deviation? Answer