Activity 3.7 Statistical Analysis with Excel
In activity 3.7, we learned about how to get statistics from data inserted in Excel and what those statistics are. Examples of statistics are mean, median, mode, range, and standard deviation.
activity_3.7.xlsx | |
File Size: | 14 kb |
File Type: | xlsx |
Conclusion Questions
1. Describe the difference between population standard deviation and sample standard deviation. Describe a scenario in which you would use each. The difference between population standard deviation and sample standard deviation is that population standard deviation looks at the entire group whereas sample standard deviation only looks at part of the group. An example of sample standard deviation is when a person has 20 people in their class but only measured the height for 6 of them. This would show only part of the population or class instead of all of it. An example of a population standard deviation is when a person has 20 people in their class and measures the height for all of them. This would show the entire population or class.
2. Which type of standard deviation (population or sample) is displayed when the Data Analysis Tool is used within Excel? Population standard deviation is displayed when the Data Analysis Tool is used within Excel.
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 that I calculated using Excel were more in depth and more precise than the statistics that I calculated by hand for the connector depth data.
4. Other than the calculation of statistics, how could an engineer use a spreadsheet application to increase efficiency? An engineer could use a spreadsheet application to increase efficiency by using it to calculate symbol equations and to make pie charts for presentation.
2. Which type of standard deviation (population or sample) is displayed when the Data Analysis Tool is used within Excel? Population standard deviation is displayed when the Data Analysis Tool is used within Excel.
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 that I calculated using Excel were more in depth and more precise than the statistics that I calculated by hand for the connector depth data.
4. Other than the calculation of statistics, how could an engineer use a spreadsheet application to increase efficiency? An engineer could use a spreadsheet application to increase efficiency by using it to calculate symbol equations and to make pie charts for presentation.