Explore BrainMass

Statistical Analysis of a Sample with Microsoft Excel

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.


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.