Question

this assignment, you will need to utilize a dataset posted to the course blackboard site alongwith this assignment

(under ‘practice assignments’, then ‘PA: Basic Excel Modeling’). Thedataset is titled “water_tower_data.xlsx” and supplies the data recorded from the water towerproject demonstration day during three previous EGR 101 class sections. Specifically, in the “rawdata” sheet, the file gives the following attributes for 28 teams: team number, water tower designtype (speed vs. height), time to build tower (sec), tower height (in), number of cups, and numberof rows (levels) in the tower. For this assignment, complete the following tasks and then uploadyour completed1. Save the “water_tower_data_2013.xlsx” file to your local machine with the followingname: PA_YourLastName (e.g., “Bekki.xlsx” or “Smith.xlsx”).2. Copy and columns A and B and E and F from the “raw_data” sheet into the same locationsin the “converted_data” sheet. At the end of this operation, columns A, B, E, and F in the“converted_data” sheet should be identical to their counterparts in the “raw_data” sheet.3. In the “converted_data” sheet, in cell C1, type “time to complete (min)”4. In the “converted_data” sheet, in cell D1, type “tower height (cm)”5. Input a formula in cell C2 of the “converted_data” sheet that convert the “time to complete”value in cell C2 of the “raw_data” sheet (and is in seconds) to a corresponding value inminutes. Drag this formula down to cell C29 (on the “converted_data” sheet) so that thesame calculation is done for all 28 teams.6. Input a formula in cell D2 of the “converted_data” sheet that converts the “tower height”value from cell D2 of the “raw_data” sheet (which is in inches) to a corresponding valuein centimeters. Drag this formula down to cell D29 (on the “converted_data” sheet) so thatthe same calculation is done for all 28 teams.7. In cell G1 on the “converted_data” sheet, type “score”.8. Add a formula in the “score” column that calculates the score for each team based on thefollowing formula, where tower height is given in centimeters, and time to build is givenin minutes. (NOTE: this is not the exact formula that will be used on our demonstrationday):9. Insert the text below in the cells shown below on the sheet titled “averages”

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"