Activity 3.7: Statistical Analysis Excel
In this activity you will collect data and use Microsoft Excel to perform statistical analyses and create a statistical chart to display your data.
Your browser does not support viewing this document. Click here to download the document.
Conclusion
1. Describe the difference between population standard deviation and sample standard deviation. Describe a scenario in which you would use each.
It is better for dealing with data and better for small groups.
2. Which type of standard deviation (population or sample) is displayed when the Data Analysis Tool is used within Excel?
Population is the standard deviation displayed.
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 is more accurate but still close.
4. Other than the calculation of statistics, how could an engineer use a spreadsheet application to increase efficiency?
it could be used for conversion and other things.
1. Describe the difference between population standard deviation and sample standard deviation. Describe a scenario in which you would use each.
It is better for dealing with data and better for small groups.
2. Which type of standard deviation (population or sample) is displayed when the Data Analysis Tool is used within Excel?
Population is the standard deviation displayed.
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 is more accurate but still close.
4. Other than the calculation of statistics, how could an engineer use a spreadsheet application to increase efficiency?
it could be used for conversion and other things.