Question: 4. Conduct a basic statistical analysis on the abalone data. (25 points) It is important to conduct statistical analysis because statistics will help explore the
4. Conduct a basic statistical analysis on the abalone data. (25 points) It is important to conduct statistical analysis because statistics will help explore the fundamental characteristics of the data. As a result, the research team has asked you to create a worksheet to do the statistical analysis. What you need to do: a. Create a new worksheet/tab in the "Firstname_Lastname_ExcData.xlsx". b. Name your worksheet/tab "Statistics". c. Compute the mean, variance, minimum, and maximum values for "Length", "Diameter", "Height", "Whole_weight", "Shucked_weight", "Viscera_weight", "Shell_weight" and "Rings". d. Create a box-and-whisker plot for "Whole_weight" for each gender. Use the data from your Personal Data worksheet. e. Use the proper chart to review the relationship between "Shell_weight" and "Shucked_weight". Use the data from your Personal Data worksheet. f. Use the proper chart to show the distribution of the "Diameter" for each gender. g. Use the proper chart to show the average "Height" for each "Rings" value. h. Design the worksheet using all the design tools that you have learned in module 1 and module 3 of the textbook. For instance: add explanations and descriptions for each table, add proper titles for each table, use different color scheme, apply proper cell format and so
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
