we will write a function to compare the suitability of various alien planets for a space colony. Make up the names of 5 alien planets and enter these in cells B5–B9 of Sheet 1 in your file. For each planet make up in the same row of the sheet a temperature (between -200 and +200) in column C, an oxygen percentage (between 0 and 100) in column D, and a radiation level chosen from “None”, “Low”, “High”, and “Lethal” in column E. Write a function which takes as input a planet name and returns a message as follows: • If the planet is not on the list then return “Pick another planet”. • If the temperature is less than -80 or greater than +80, or the oxygen level is less than 10, or the radiation level is Lethal, return “x is not habitable” where x is the name of the planet.

we will write a function to compare the suitability of various alien planets for a space colony. Make up the names of 5 alien planets and enter these in cells B5–B9 of Sheet 1 in your file. For each planet make up in the same row of the sheet a temperature (between -200 and +200) in column C, an oxygen percentage (between 0 and 100) in column D, and a radiation level chosen from “None”, “Low”, “High”, and “Lethal” in column E. Write a function which takes as input a planet name and returns a message as follows: • If the planet is not on the list then return “Pick another planet”. • If the temperature is less than -80 or greater than +80, or the oxygen level is less than 10, or the radiation level is Lethal, return “x is not habitable” where x is the name of the planet.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter3: Performing Calculations With Formulas And Functions

Section: Chapter Questions

Problem 21RA

See similar textbooks

Similar questions

In C++ Query the user for the name of a file. Open and process that file, reporting the number of words in the file and the number of words containing each letter, and the length of that word. Assume that any word exceeding nine characters is counted as a ten character word. If the same letter appears more than once, it is counted only once. The result should be a matrix of 26 rows (one row for each letter) and ten columns (one column for each word length (1-10), and the contents of the matrix must be displayed. As an example, assume the file contains only two words - “rotten” and “egg”. When processing “rotten”, rows for r, o, t, e and n would have the contents of column 6 incremented because “rotten” is a six letter word. When processing “egg”, rows for e and g would have the contents of column 3 incremented because “egg” is a three letter word.
The file akaroawindgusts.txt contains hourly maximum wind gusts speeds at the Akaroa Electronic weather station (Ews) through February 2014. Inspect it in any halfway decent text editor (not Microsoft Notepad, but Wing will do) so you can see which column contains the wind speed data, how many rows to skip, and what the column separator (delimiter) is. Then write a function plot_ wind gust histogram(filename) that reads a file in that format and plots a histogram of the peak wind gust speeds. The graph you get should look like the one below. Wind gusts from akaroawindgusts.txt 250 200 150 100 50 0 10 20 30 40 50 60 70 80 90 100 110 120 130 140 Wind gust speed (km/h) Notes: • The bins are all 10 km/h wide, starting at 0 10 and finishing at 130 - 140. You must set these bins explicitly. • It is not a density plot - the vertical axis displays a count of how many records were in each bin. • You will have to explicitly set x ticks every 10 km/h. • Your function is not permitted to use any…
Questions P17 and P18 are related to the code skeleton of the function below. The function readPeople() below takes a string fname as an argument, which is the name of a file containing information about people on each line. The function returns a dictionary containing all of the information contained in the file. Each line of the file contains three items of information about a person: ID number, name, and age. The information stored in each dictionary entry should be the name and age of a person, and it should be associated with a key which is the ID number of that person. def readPeople(fname): infile = open(fname, "r") pDict = {} _______[P17]_______ ldat = l.split() _______[P18]_______ return(pDict) An example file is shown below.example.txt1234 Joe 242345 Jane 353456 Pete 22Assume that the ID numbers are unique for each person. Assume that the names contain only alpha-numeric characters and do not contain spaces. The value of [P17] Group of answer…
Exercise 4. The worksheet “Hours” (see attached Excel file) contains the number of hours that 7 employees have worked over the past 100 days. Some employees have not worked in some days. a) Create a function named employee that takes an employee name as parameter and returns the range of cells starting day 1 until the last consecutive day that the employee has worked from day 1. For instance, this range for Alex should be “B2:B27”. b) Create a sub that takes an employee name as input from the user, checks to ensure the name is valid (returns error message if the name is not one of the 7 names) and if the name is valid then calls on function employee to get the range of consecutive days that the employee has worked starting day 1 and then computes the sum of the number of hours the employee has worked over consecutive days since day. This sum should then be written in a new row under the same data with row name “Cons Days” c) Create a sub that builds a table somewhere on the right side…
R Programming: create a function on your own out of this code for a ggplot. ggplot(pr.cb.fulldata, aes(GD, Alleles, color = Tide)) + geom_point(size = 3) + theme_classic()+ theme(legend.title = element_text(size = 12), legend.text = element_text(size = 10) ) + scale_color_manual(values = wes_palette("Darjeeling2")) write a loop that will iterate through 3 categorical grouping variables and multiple x and y variables (5 of each would be a good multiple otherwise you will be making tons of plots). Make sure you are choosing meaningful x and y variables for the type of plot you are creating. generate all the plots for the variables you specified by using loops.submit R script.
Jupyter Notebook Fixed Income - Certicificate of Deposit (CD) - Compound Interest Schedule An interest-at-maturity CD earns interest at a compounding frequency, and pays principal plus all earned interest at maturity. Write a function, called CompoundInterestSchedule, that creates and returns a pandas DataFrame, where each row has: time (in years, an integer starting at 1), starting balance, interest earned, and ending balance, for an investment earning compoundedinterest. Use a for(or while) loop to create this table. The equation for theith year's ending balance is given by: Ei =Bi (1+r/f)f where: Ei is year i's ending balance Bi is year i's beginning balance (note: B1 is the amount of the initial investment (principal) r is the annual rate of interest (in decimal, e.g., 5% is .05) f is the number of times the interest rate compounds (times per year) The interest earned for a given year is Ei - Bi Note the term of the investment (in years) is not in the above equation; it is used…
Matlab code: Use the create_matrix function from the tutorial file, along with a function a (i.) (which you will have to create) to produce the following 18 x 18 matrix. Then find its determinant.
Write a function special_increament() in "C" to add $100 in the balance of all the customers having more than $1000 in their balance and then print the incremented value of their balance.
Retrieve information from this webpage "https://www.chewy.com/b/dry-food-294", Dry Dog Food. The information you need is 1) the brand and the name of the products, 2) the price for auto ship, and 3) the regular price. For Q1 and Q2, you may need the function trimws() or gsub() to remove unwanted characters.
python function!: a function called popular_color with one parameter, of type dict[str, str] of names and favorite colors. The return type is a str and it is the most commonly occuring color. If two colors are tied for popularity, the first color shown will be picked.
Write the function truck_adjustment_factor(truck_proportion, terrain_type) that takes the proportion of trucks using the motorway and the terrain type as inputs and returns the adjustment factor that is used for calculating the highway capacity. The adjustment factor is calculated according to the following formula: adju stment factor = tprupurtime x(furtor-1) Where proportion is the proportion of trucks and the factor is the car equivalent factor for the given terrain. You should be calling your car_equivalent_factor function to get the factor - don't reinvent the wheel! For example, for rolling terrain and a truck proportion equal to 0.12: adjustment factor = 1/(1 + 0.12 x (4.0 - 1)) = 0.735 Notes: You should include (and call/use) your car_equivalent_factor function in your answer o In general, you should paste in your whole module so far in each question as later functions will call earlier functions. • You can assume the function will always be called with one of the three valid…
4. Write a function called electionResults() that takes 2 lists as parameters. Thefirst list contains the names of political parties, in a given order; the second contains, inthe same order, the vote total each party received in a local election. Your function should print the name of each party followed by the word “Party”, in a column 30characters wide; the number of votes each received in a column 10 characters wide; andthe percentage of the vote each received in a column 10 characters wide, rounded to 2decimal places, followed by the percent sign ‘%’. (Vote totals may not add to exactly100.00% because of rounding.)>>> electionResults(['Sensible', 'Silly', 'Very Silly'], [29412,29397, 37])Sensible Party 29412 49.98%Silly Party 29397 49.96%Very Silly Party 37 0.06%