Helicopter performance Assignment. Layout References Mailings Review View Add-in

Question

Helicopter performance Assignment.
Layout References Mailings Review View Add-ins ?Tell me what you want to do aBbC ItNormaljTNo Spae..-Heading 1 AaBbCel Heading 2 Aa Title a-.a- s- a- Paragraph Styles thout interruption, please reactivate now.Reactivate Helicopter Performance Assignment In teams of one or two, do the following exercise. You must do it in Excel. All calculations should be made with formulas in the Excel cells (showing your work), and answers labeled clearly with the numbers/letters below. It is due by email by midnight on Wednesday, November 15 1. Make a helicopter. You may use any of the three sizes on the template below. 2. 3. Select a high height (about seven feet) from which to drop the helicopter. Practice flying your helicopter, timing the flight time imagine your job is to fly helicopters. Your operation is flying your helicopter and your performance measure is how long your helicopter stays in the air, For your operation, you want to answer two questions about it: 1) is it stable? 2) is it capable? To answer the first question, you will use a control chart. To answer the second question, you will calculate a process capability index. 4. To construct a control chart, you need to collect samples. You will use a sample size of two (n 2). Fly your helicopter two times, recording the flight times. This is your first sample of size two. Imagine some time passes in your operation and vou want to take a second sample of size two. Fly your helicopter two times for this sample. Imagine gathering samples of size two, allowing time to pass between 5. samples, for a total of 40 samples. You now have 40 samples of size two, for a total of 80 flight times. Put this on an Excel spreadsheet page titled "Data Calculate the average and range of the two flight times that make up each sample. You will have 40 averages and 40 ranges. 6. 7. On an Excel spreadsheet page titled "Histograms," draw a histogram of the individual fight times (80 flight times). (20 Points) a) What are the boundaries of the histogram by looking at it? b) what are the boundaries of the histogram using ± 3a (calculate the standard deviation of the 80 flights)? c) Compare the two sets of boundaries. Do ± 3 boundaries agree with what you visually see? On the Excel spreadsheet page titled "Histograms", draw a histogram of the sample average flight times (40 sample averages) using the same X axis as for the histogram of individual flight times. (20 Points) a) What are the boundaries of this histogram by looking at it? 8.

Explanation / Answer

This is a good exercise which will help you understand normal distribution and how we use it unknowingly in our day to day lives.

Since you have not given any data pertaining to the 80 flights along with the question, and I too tried pulling out some data about flight durations but unfortunately I haven't been able to get any relevant information. I trust this data is already with you.

I shall tell you how to solve this problem, it is pretty simple:

Above is just a sample

Next, plot a histogram or a simple bar chart will also do. The frequency buckets will be on the x axis, and the frequencies on the y axis

Next, calculate the standard deviation.

You will have to do this from the raw data containing the 80 data points

Simply use the excel function =STDDEV()

Now, multiply the standard deviation by 3. These are your 3 sigma limits. Statistics tells you that over 97% of your data should fall within these limits.

You should be able to look at the histogram you've generated in excel and easily confirm the same.

Duration Frequency <1 hour 25 1-2 hours 30 2-3 hours 20 >3 hours 5

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.