I need help on 2 excel sheets

P6-11 Statistics

Problem 6-11
Twenty First Century Laundry
Summary Statistics Using Excel Data Analysis Tool - "Descriptive Statistics"
								Copy below data into yellow highlighted column, and sort in ascending order
Summary Data in						Original Data
Ascending Order		Place descriptive stats output below
						69	3	1	72	93	3	80	6	5	36
						42	2	64	44	15	77	49	85	82	102
						28	70	41	30	25	45	31	49	49	49
						13	42	27	13	45	31	14	34	32	39
						19	29	12	19	30	14	21	14	14	52
						7	13	18	8	14	19	18	21	21	5
						94	19	6	107	19	2	41	7	15	15
						53	8	90	55	2	64	16	12	27	53
						35	16	35	38	3	9	9	9	11	39
						16	17	18	23	74	25	26	58	59	62
							Analyze the data output as presented by Descriptive Statistics Analyze and explain what the Descriptive Statistics output means. Incorporate analysis of the data, and your responses to the problem questions in the text, in a narrative format using the Report Template

P6-11 Histogram

Problem 6-11
Twenty First Century Laundry
Bin Size
		Bin	Frequency
15
30
45
60
75
90
105
		More
Using the Data from the Statistics tab, and using the Bin Sizes above, determine the frequency of each bin. Transfer the bin size and frequency count into the yellow highlighted cells. The graph will self-create. Follow instructions under the Chart to comply with required analysis of the chart.					Analyze chart data. Do not describe the chart! Analyze and explain what the chart data means. Incorporate analysis of the data, and your responses to the problem questions in the text, in a narrative format using the Report Template.

Histogram

Frequency More

Bin

Frequency

Prob 6-13

Problem 6- 13
Fillmore Metalwork Foundry
Descriptive Statistics and Frequency Chart
DATA		(x - x-bar)^2		Step 2
1		0		Manually calculate mean & sample standard deviation
2		0
3		0		Mean (x-bar) =		Calculate each to 4 decimals
4		0		Sample SD =
5		0
6		0
7		0		Step 3
8		0		Place Descriptive Statistics below. **Ensure the Mean is listed in cells E21 and F21**
9		0
10		0
11		0					Step 1	Original Data set			Copy below data into yellow highlighted column. Copy and paste each column left to right.
12		0
13		0
14		0						38.1	38.5	38.3	37.3	38.4	39.2	38.9	38.5	39.0	38.6
15		0						38.1	38.8	38.6	38.6	38.6	38.6	38.9	38.8	39.0	38.6
16		0						38.5	38.5	38.8	38.7	38.7	38.7	38.9	38.6	39.1	38.7
17		0						38.5	38.6	38.5	38.5	38.7	38.8	38.9	38.7	38.7	38.6
18		0						38.7	38.6	38.7	38.6	38.9	38.7	38.9	38.5	38.6	38.5
19		0						38.8	38.6	38.4	38.6	38.6	38.7	39.0	38.7	38.7	38.5
20		0						38.6	38.6	38.5	38.6	38.5	38.6	38.7	38.7	39.1	38.6
21		0						38.3	38.6	38.4	38.1	38.4	39.5	38.8	38.8	39.1	38.6
22		0						38.3	38.6	38.4	38.1	38.5	39.6	38.7	38.8	39.2	38.8
23		0						38.3	38.6	38.4	38.1	38.5	39.3	39.0	38.8	39.2	38.7
24		0
25		0
26		0
27		0
28		0							Analyze the data output as presented by Descriptive Statistics Analyze and explain what the Descriptive Statistics output means. Incorporate analysis of the data, and your responses to the problem questions in the text, in a narrative f in a narrative format using the Report Template.
29		0
30		0
31		0
32		0
33		0
34		0
35		0
36		0
37		0
38		0
39		0
40		0
41		0
42		0
43		0
44		0
45		0
46		0
47		0
48		0
49		0
50		0
51		0
52		0
53		0
54		0
55		0
56		0
57		0
58		0
59		0
60		0
61		0
62		0
63		0
64		0
65		0
66		0
67		0
68		0
69		0
70		0
71		0
72		0
73		0
74		0
75		0
76		0
77		0
78		0
79		0
80		0
81		0
82		0
83		0
84		0
85		0
86		0
87		0
88		0
89		0
90		0
91		0
92		0
93		0
94		0
95		0
96		0
97		0
98		0
99		0
100		0