Activity 3.7 Statistical Analysis with Excel

Activity 3.7 Statistical Analysis with Excel
Spreadsheet On Height

Feet	Inches	Decimal Feet
5	7	5.58
5	9	5.75
5	5	5.42
5	4	5.33
5	10	5.83
5	0	5.00
5	9	5.75
5	8	5.67
5	8	5.67
5	10	5.83
5	11	5.92
4	10	4.83
5	3	5.25
5	2	5.17
5	4	5.33
5	5	5.42
5	10.5	5.88
5	3	5.25
5	10	5.83
5	5	5.42
5	7	5.58
5	3	5.25
5	5	5.42
	Sum	126.38
	Mean	5.49
	Mode	5.42
	Standard Deviation	0.2887547048
	Minimum	4.83
	Maximum	5.92
	Median	5.42
	Range	1.08

Conclusion

1.       Describe the difference between population standard deviation and sample standard deviation. Describe a scenario in which you would use each.

Sample standard deviation involves prediction of entire population by gathering data from a group. While population standard deviation is when the data of the entire population is known.

2.       Which type of standard deviation (population or sample) is displayed when the Data Analysis Tool is used within Excel?

Sample standard deviation is used.d

3.       How do the statistics that you calculated using Excel compare to the statistics that you calculated by hand for the connector depth data? 

It's faster on Excel due to the ability to repeat same functions quickly by dragging from lower right corner.

4.       Other than the calculation of statistics, how could an engineer use a spreadsheet application to increase efficiency?
Spreadsheet is easier to log and share with fellow engineers as well as quickly calculate other functions. Moreover numbers can be quickly organised in orders such as greatest to smallest.