Question: Gather the data from your class members from the Assignment Forum posts and add it to an Excel Spreadsheet. Sort the data. Create a bar

Gather the data from your class members from the Assignment Forum posts and add it to an Excel Spreadsheet. Sort the data. Create a bar graph with each bar being a different color to show variation in age range (you will have to set a range.) You can be creative in your range, for example, Option 1: Child / Teenager / Adult / Geriatric Option 2: Age 1-10, Age 11-20, age 21 - 30, etc. Add the data to create a graph to show the variation of the age range you have chosen with the distance from the floor. The distance from the floor should be shown as an average for each age group. So, for example, if you have 4 different age groups, there should be 4 data points. Create another graph with the data that is not a bar graph. You are free to choose how to display the data, but make sure it makes sense. For example, a line graph just showing the age of each participant would not make sense in the context of this experiment, but a graph with both age and distance to the floor would. Create a legend on the left side of the Excel document. In your spreadsheet: Calculate the sample variance and standard deviation for the whole population (whole data set - do not use the averages you calculated for the graphs for your calculations). Calculate the Z-Score (for each age group) using the average of each age group compared to the average of the whole population and the standard deviation for the whole population

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!