Activity 3.7 Statistical Analysis
Procedure
IMPORTANT: This activity requires the use of the Analysis ToolPak, which is an Add-in to Microsoft Excel that is not available by default in the program. To load the Analysis ToolPak follow the instructions of your instructor or read Analysis ToolPak Loading Instructions. In this activity you will collect data and use Microsoft Excel to perform statistical analyses and create a statistical chart to display your data.
Conclusion
1. Describe the difference between population standard deviation and sample standard deviation. Describe a scenario in which you would use each.
Population standard deviation is the measure of the entire population. Sample standard deviation is a measure of a group. Example for population standard deviation would be asking a classroom the number of people that have siblings. Where in a sample population you would ask the whole population would be not possible to survey the whole population.
2. Which type of standard deviation (population or sample) is displayed when the Data Analysis Tool is used within Excel?
Population is the type of standard deviation that is used to display when the Data Analysis Tool is used within Excel, because its not a random selection its more selected.
3. How do the statistics that you calculated using Excel compare to the statistics that you calculated by hand for the connector depth data?
The statistics in excel are different because when you calculate the stats by hand you may round different than the computer.
4. Other than the calculation of statistics, how could an engineer use a spreadsheet application to increase efficiency?
You can use the spreadsheet to create a dot plot, bar graph, or histogram.
IMPORTANT: This activity requires the use of the Analysis ToolPak, which is an Add-in to Microsoft Excel that is not available by default in the program. To load the Analysis ToolPak follow the instructions of your instructor or read Analysis ToolPak Loading Instructions. In this activity you will collect data and use Microsoft Excel to perform statistical analyses and create a statistical chart to display your data.
Conclusion
1. Describe the difference between population standard deviation and sample standard deviation. Describe a scenario in which you would use each.
Population standard deviation is the measure of the entire population. Sample standard deviation is a measure of a group. Example for population standard deviation would be asking a classroom the number of people that have siblings. Where in a sample population you would ask the whole population would be not possible to survey the whole population.
2. Which type of standard deviation (population or sample) is displayed when the Data Analysis Tool is used within Excel?
Population is the type of standard deviation that is used to display when the Data Analysis Tool is used within Excel, because its not a random selection its more selected.
3. How do the statistics that you calculated using Excel compare to the statistics that you calculated by hand for the connector depth data?
The statistics in excel are different because when you calculate the stats by hand you may round different than the computer.
4. Other than the calculation of statistics, how could an engineer use a spreadsheet application to increase efficiency?
You can use the spreadsheet to create a dot plot, bar graph, or histogram.