Purchase Solution

Basic descriptive statistics and graphs in Excel

Not what you're looking for?

Ask Custom Question

INSTRUCTIONS

1. Obtain the mean and standard deviation of the provided data. See below.
2. Create a histogram for data frequencies using the Microsoft® Excel® program. The bin range can be left blank.
3. Use the histogram to determine how many points are out of control according to the upper control limit and lower control limit.
4. Quality Textiles International (DATA NEED TO CREATE HISTOGRAM)
Quality Textiles International is an organization that weaves fabric and then prepares the required sheet lengths as desired by customers. They have received recent complaints that the fabric weight, measured in ounces per square inch, is not meeting customer requirements, which are very close to the control limits. Quality Textiles International's quality assurance department checks the fabric weight on regular basis and knows that their process for fabric weight has a mean of 2.73 oz/in2 and a standard deviation of 0.31.

The following table shows 50 fabric weight measurements of fabric samples collected by the quality assurance department:

Observation Fabric weight
1 2.78
2 2.46
3 3.00
4 2.80
5 2.71
6 2.61
7 3.12
8 3.02
9 2.94
10 2.44
11 3.06
12 2.90
13 2.74
14 2.57
15 2.06
16 2.32
17 2.62
18 2.41
19 2.43
20 3.44
21 2.69
22 2.36
23 1.92
24 2.00
25 2.63
26 2.75
27 2.79
28 2.81
29 2.81
30 2.43
31 2.86
32 3.09
33 3.18
34 3.26
35 3.29
36 3.30
37 3.30
38 3.31
39 3.33
40 3.35
41 3.35
42 3.34
43 3.50
44 3.55
45 3.65
46 3.78
47 4.00
48 4.01
49 3.99
50 4.00

Provide a summary of the analysis and what it means.

Attachments
Purchase this Solution

Solution Summary

Step by step method for computing basic descriptive statistics and graphs in Excel.

Purchase this Solution


Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.