Statistical Analysis of a Sample with Microsoft Excel
Not what you're looking for?
Assignment Overview
Take the situation introduced on the Home page of this module:
Suppose you want to know if a new design of a product is actually better than the current product. For example, your design team is working on increasing the speed of the KX Speed Drill. You have produced a small batch of the new design, the KX2, and you want to know if this speed is faster than the current speed of 17.5 revs per second.
To test the new design, QA has taken a sample of 13 KX2's and clocked their speed. The results of this test are shown below.
Is it safe to conclude that the new design for the KX2 has a significantly higher speed with a confidence of 1%?
See attached file for further information.
Purchase this Solution
Solution Summary
This solution involves an analysis of the samples collect by a QA tech of new drills. Each drill's speed was measured to determined the speed. Microsoft Excel was used to provide an analysis of data to determine if the new drill speed was faster than 17.5 revs per second.
Purchase this Solution
Free BrainMass Quizzes
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
Learning Lean
This quiz will help you understand the basic concepts of Lean.