Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional Visual Basic 6 Databases

Authors: Charles Williams

1st Edition

1861002025, 978-1861002020

More Books

Students also viewed these Databases questions

Question

Does it avoid using personal pronouns (such as I and me)?

Answered: 1 week ago

Question

Does it clearly identify what you have done and accomplished?

Answered: 1 week ago