Explore BrainMass
Share

Statistical Analysis of a Sample with Microsoft Excel

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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.

© BrainMass Inc. brainmass.com October 25, 2018, 9:51 am ad1c9bdddf
https://brainmass.com/business/six-sigma/statistical-analysis-of-a-sample-with-microsoft-excel-589023

Attachments

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.

$2.19
See Also This Related BrainMass Solution

Descriptive Statistics Data Analysis

2. Descriptive Statistics Paper
Adding to your Week 3 paper, prepare and submit a 1,050-1,750-word paper examining the data you have collected, and drawing conclusions based on your findings. In your paper, be sure to include the following:
a. Data analysis using descriptive statistics
1) Calculate the measures of central tendency, dispersion, and skew for your data
2) Display your descriptive statistical data using graphic and tabular techniques
a) Line graph
b) Bar graph
3) Based on your measures of central tendency and graphs, discuss the best measures of central tendency and dispersion of your data. Justify your selection
b. Conclusions
Discuss whether your research findings answered your problem statement (research question), or whether more research might be necessary hide problem

View Full Posting Details