Explore BrainMass
Share

Basic descriptive statistics and graphs in Excel

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

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.

© BrainMass Inc. brainmass.com October 25, 2018, 2:43 am ad1c9bdddf
https://brainmass.com/statistics/quantative-analysis-of-data/basic-descriptive-statistics-and-graphs-in-excel-311924

Attachments

Solution Summary

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

$2.19
See Also This Related BrainMass Solution

MLB salaries: Data analysis using descriptive statistics (Excel)

Please see attachment

This research could affect the players of Major League Baseball (MLB) and the fans. The teams that have a lower salary have a lower win rate per year this affects there draft pick they cannot afford well-known plays with high batting averages. These teams have to pick medioka players during the draft, causing the investors and sponsors to back away from the teams, which cause financial difficulties.

1) Calculate the measures of central tendency, dispersion, and skew for data

2) Display your descriptive statistical data using graphic and tabular techniques
a) Line graph
b) Bar graph

View Full Posting Details