Activity 3.7 Statistical Analysis with Excel
Introduction
Engineers use various tools to make their jobs easier. Spreadsheets can greatly improve the accuracy and efficiency of repetitive and common calculations; therefore, engineers often employ spreadsheet applications in their work.
In this activity you will collect data and use Microsoft Excel to perform statistical analyses and create a statistical chart to display your data.
Engineers use various tools to make their jobs easier. Spreadsheets can greatly improve the accuracy and efficiency of repetitive and common calculations; therefore, engineers often employ spreadsheet applications in their work.
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 refers to an entire group of people or things (Blocks: All the blocks). Sample standard deviation is the standard deviation of a group of a population. If you were to take the total number of students in a School and then find the standard deviation of a class' population, that'd be sample standard deviation.
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 using the Data Analysis Tool in 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?
4. Other than the calculation of statistics, how could an engineer use a spreadsheet application to increase efficiency? An engineer could use a spreadsheet for just general organization of that data they collected statistics for.
1. Describe the difference between population standard deviation and sample standard deviation. Describe a scenario in which you would use each. Population standard deviation refers to an entire group of people or things (Blocks: All the blocks). Sample standard deviation is the standard deviation of a group of a population. If you were to take the total number of students in a School and then find the standard deviation of a class' population, that'd be sample standard deviation.
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 using the Data Analysis Tool in 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?
4. Other than the calculation of statistics, how could an engineer use a spreadsheet application to increase efficiency? An engineer could use a spreadsheet for just general organization of that data they collected statistics for.