User Account

All Pages

Basic excel modeling

Assignment Help Basic Computer Science
Reference no: EM13840503

Utilize a dataset posted to the course blackboard site along with this assignment (under ‘practice assignments', then ‘PA: Basic Excel Modeling'). The dataset is titled "water_tower_data.xlsx" and supplies the data recorded from the water tower project demonstration day during three previous EGR 101 class sections. Specifically, in the "raw data" sheet, the file gives the following attributes for 28 teams: team number, water tower design type (speed vs. height), time to build tower (sec), tower height (in), number of cups, and number of rows (levels) in the tower. For this assignment, complete the following tasks and then upload your completed

1. Save the "water_tower_data_2013.xlsx" file to your local machine with the following name: 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 locations in 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 in minutes. Drag this formula down to cell C29 (on the "converted_data" sheet) so that the same 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 value in centimeters. Drag this formula down to cell D29 (on the "converted_data" sheet) so that the 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 the following formula, where tower height is given in centimeters, and time to build is given in minutes. (NOTE: this is not the exact formula that will be used on our demonstration day):

S=Nc +5(NL)+(H/t)

where: S =Score

Nc = Number of Cups

NL= Number of Levels

H = Tower 1 leight in centimeters

t = time to build the tower in minutes

Verbally: score = number of cups + 5(numbcr of levels) 4- (tower height / time to build)

9. Insert the text below in the cells on the sheet titled "averages"

Reference no: EM13840503

Questions Cloud

Average rate of change of the function : Problem 1: Find the average rate of change of the function over the given interval.
Describe potential communication technology tools : Then describe two potential communication technology tools you might use in your public health campaign and explain why these tools would be appropriate for your target audience
What financial report can be prepared based on trial balance : What financial reports can be prepared based on the trial balance? The process of accounting for businesses is moderated by a number of industry codes of practice and standards. Briefly explain the role of the AASB in relation to accounting standar..
Calculate the profit as a percent of the premium paid : Calculate the profit as a percent of the premium paid
Basic excel modeling : 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 in minutes. Drag this formula down to cell C29 (on the "converted_da..
Analyzing financial ratios : Analyzing Financial Ratios
Identification of the elements of the promotion mix : Appreciation of the significance of the concept of integrated marketing communications (IMC) and its impact on marketing management. Identification of the elements of the promotion mix and the pros and cons of each element. Connection of the concept..
What are the potential security risks in implementation : What are the potential security risks in implementation of such a system? For the purpose of this assignment, you will make necessary assumptions, validate the same, and then provide a well-researched and informed report to the CEO.
How would you measure the different forms of debt? : How would you measure the different forms of debt?

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Type of information of microsoft useful inprofessional life

What kind of information on the site do you find to be valuable to you? What kind of information about Microsoft Word do you find to be useful in your personal or professional life? Explain.

  Intentional and unintentional plagiarism

What is the difference between intentional and unintentional plagiarism

  What are the transport protocols

What mechanism is used to detect/avoid/correct data transmission collision in Layer 2, such as Ethernet and WiFi? Describe the mechanism in sufficient details.

  Compute the mean and standard deviation of the rolls

Also, your application should show a table that shows each possible roll of the dice and its frequency of occurrence in the simulation in a listbox. In other words, the table shows the count of a roll of 2, the count of a roll of 3, and so on up t..

  Transport and tunnel modes in ipsec

Distinguish between transport and tunnel modes in IPSec. What are the strengths and weakness of each?

  Create a comprehensive security policy for the company

Demonstrate an understanding of existing and emerging information technologies and strategic impact on organizational operations and evaluate the issues and challenges associated with information technology integration.

  What is the output of the following oddstuff method

What is the output of the following oddStuff method?

  The way to call two functions with the onclick event

add the image so when click on the image it will submit the amount. Also is this the way to call two funtions with the onclick event?

  Write code that fills an array with each set of numbers

Write code that fills an array with each set of numbers below. a. 1 2 3 4 5 6 7 8 9 10 b. 0 2 4 6 8 10 12 14 16 18 c. 1 4 9 16 25 36 49 64 81 100 d. 0 0 0 0 0 0 0 0 0 0 e. 1 4 9 16 9 7 4 9 11

  What is the probability that he is actually guilty

And how can you explain this puzzling result? (First of all, you may need to explain why it is puzzling. Then explain why it really makes sense even though it seems to be puzzling.)

  Discussion question arrays

Discussion question Arrays

  Analyze the current uses of http and https

Analyze THE Current Uses Of Http And Https

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd