Reference no: EM13872669
Overall Objective: Create an X bar Control Chart and a Run Chart:
An altimeter is a device on an airplane for measuring the plane's distance above the ground at any given instant. It's obviously a critically important performance and safety instrument. The Air Force does frequent testing on their fighter jet altimeters to ensure they are operating effectively and within statistical control. Your Excel data for this assignment represents the testing of a particular altimeter in a fighter jet over the course of twenty days. Utilizing the data, create a Control Chart and a Run Chart for your altimeter testing.
The testing took place over 20 days with 4 observations per day. The process standard deviation for altimeter performance is 6.8 and you will calculate your UCL and LCL with a Z value of 3.
Please complete the following for your submission:
1. Complete the data chart (in Excel file), filling in all highlighted cells correctly and adding your CL, LCL and UCL values to the data you will plot.
2. Create an X bar Control Chart for these data. Provide an appropriate graph title & series labels (legends).
3. In a small chart, calculate and list Zone A, B & C limits
4. Insert a text box on your worksheet and indicate if the process is in or out of control. If out of control, list all out of control rules that are met.
5. On a separate tab sheet (label the tab sheet), re-list the data in date order (Day 1 Test Readings 1-4, then Day 2 Test Readings 1-4, etc.) as a single row or column.
6. Plot your 80 readings as a Run Chart (line chart) and observe the performance of your altimeter for all test observations over time (the 20 days).
7. Insert a text box with your observations of the run chart. Do you see noise, seasonal/cyclic or trend behavior? Is there degradation of performance over time?
8. Finally, add a textbox with your recommendation for the Air Force: pull this altimeter for further testing and re-calibration or leave it alone and send it back into the wild blue yonder?
Attachment:- Practice Data.xlsx
|
Arlette''s pet shop purchases a building
: Arlette's Pet Shop purchases a building.
|
|
Use of the beta measure as indicator of portfolio risk
: Tom Max TMP, quantitative analyst, has developed a portfolio construction model about which he is excited. To create the model, TMP made a list of the stocks currently in the S&P 500 Stock Index and obtained annual operating cash flow, price, and tot..
|
|
Reality of green businesses such as organic foods
: Evaluate and debate the promise, drawbacks, and reality of green businesses such as organic foods and ecotourism?
|
|
Prepare budgetary and proprietary journal entries
: Prepare budgetary and proprietary journal entries to record the following year end adjustments: 1. An accrual of $ 60,000 was made for salaries earned the last week of September, to be paid in October. Budgetary funds were available for this purpo..
|
|
Create an x bar control chart for these data
: Create an X bar Control Chart for these data. Provide an appropriate graph title & series labels (legends) - Complete the data chart, filling in all highlighted cells correctly and adding your CL, LCL and UCL values to the data you will plot.
|
|
What are the health risks of overweight and obesity
: Need help in writing a one to two page 1-2 page essay Assignment 3 Obesity in America . The essay should be short and manageable from the article from the National Heart, Lung, and Blood Institute and the sections noted in the text. Use the suggeste..
|
|
Depreciation of general property, plant, and equipment
: Depreciation of general property, plant, and equipment is reported as an expense in the consolidated U. S. government statement of net cost, but not in the statement of net cost prepared by individual agencies.
|
|
How does the heckscher-ohlin theory differ from ricardian
: How does the Heckscher-Ohlin theory differ from Ricardian theory
|
|
Company assign to the land and to the building
: Utica Corporation paid $360,000 to purchase land and a building.
|