Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Part Two Q8. An Excel file is found in the download folder. This file stores anthropometric measurements of different students. Anthropometric measurements are body dimensions
Part Two Q8. An Excel file is found in the download folder. This file stores anthropometric measurements of different students. Anthropometric measurements are body dimensions in centimeters. In addition, the dataset stores the "Gender" of the students. Use this dataset to answer the below questions. Write your answers in the blanks (if required) and upload your code that you used, generated plots, and MS Excel file. Write a code to answer all questions from ag. a. Get to know the dataset by displaying the columns names and the number of rows in the dataset. (2pts) b. The "Stature" of the sixth student in the database is cm. (1pt) c. The average "Shoulder Breadth" for "Male" students is cm.(2pts) d. Store the "Shoulder Breadth" values in a new data structure and change its unit from cm to inches. (2 pts) e. Store the difference between "Stature" and "Eye Height" in a new data structure. (2 pts) f. Plot the average "Shoulder Breadth" and "Hip Breadth (sitting)" for "Male" students. On the same plot, plot the corresponding values for "Female" students. Select an appropriate plot, add labels and a legend. [only one plot, no subplots] (6pts) Comment on the plot. (1 pt) g. Construct a new dataset and save it in an Excel file. Name the Excel file by your name. The new dataset should consist of the following columns: "Student no.", "Stature", "Eye Height", values stored in Q8.d. and values stored in Q8.e. (3 pts)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started