None 2- Suppose the fallowing information about some product in a cloths markets , wherethere are two discount offer (sil ja), that depend on prod type, write a suitableformula find the new price, note : new price old price +(discount rate 8 old price)AC1dis1=-15%dis2=-20%23 prod_type price $2$$ 23.002$new price4134.0026.156.002$67.0056.007?8.124?9.1- Find the new price where the discount value depending on prod_type as fallow:Prod_type= 1→ dis1prod_type=2 dis22- find the sum of all new price3- find the number of prod_type 1 and newprice >=30 $4- Find the average of price for prod_type 25- find the second largest new price

GIven : discount 1=-15% discount2 =-20% product type 1 and product type 2

2- Suppose the fallowing information about some product in a cloths markets, where there are two discount offer (sill ja), that depend on prod type, write a suitable formula find the new price, note : new price old price +(discount rate 8 old price) A D 1 dis1= -15% dis2= -20% 2 3 prod_type price $ 4 new price 1 $34.00 $23.00

2- Suppose the fallowing information about some product in a cloths markets, where there are two discount offer (sill ja), that depend on prod type, write a suitable formula find the new price, note : new price old price +(discount rate 8 old price) A D 1 dis1= -15% dis2= -20% 2 3 prod_type price $ 4 new price 1 $34.00 $23.00

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter8: Working With Advanced Functions

Section: Chapter Questions

Problem 4.4CP

See similar textbooks

Similar questions

Write a function called ValidSupplier(SupplierID) that takes as its only input a SupplierID. If the supplier exists in the database your function should return True otherwise it should return False
Call the function from a PROCEDURE. Name the procedure findDiscPrice. Allow the user to pass a parameter customer ID (customer_id) to the procedure. Calculate and display the new item price for the customer similar to the example below. Assume we will call the procedure from the following Anonymous Block begin findDiscPrice (1); findDiscPrice (2); findDiscPrice (3); end; Expected output: Customer Doctor Who new item price is 990 Customer Harry Potter new item price is 40 Customer Captain Awesome new item price is 2400
Create a nfa for L = {w ∈ {a, b}∗|w begins and ends with different letters.}
ASSIGNMENTS: Question 1: Given: enum cropType {WHEAT, CORN, RYE, BARLEY, OATS}: сгoрТуре crop: Circle the correct answer. a. static_cast(WHEAT) is 0 (i) true (ii) false b. static_cast(static_cast(WHEAT)- 1) is WHEAT (i) true (ii) false c. RYE > WHEAT (i) true (ii) false d. for (crop = wheat; crop <= oats; ++crop) cout << "*". cout << endl; outputs: (i) true (ii) false. *****
get_total_cases() takes the a 2D-list (similar to database) and an integer x from this set {0, 1, 2} as input parameters. Here, 0 represents Case_Reported_Date, 1 represents Age_Group and 2 represents Client_Gender (these are the fields on the header row, the integer value represents the index of each of these fields on that row). This function computes the total number of reported cases for each instance of x in the text file, and it stores this information in a dictionary in this form {an_instance_of_x : total_case}. Finally, it returns the dictionary and the total number of all reported cases saved in this dictionary.
You are given a list of courses that are currently available in Oxford College that looks like the following: courses = ['CSE110','CSE111','MAT620','CSE520','EEE361','CSE650','MAT510']. All courses till 400 level (499) are for the undergraduate students whereas any courses above 500 are for the graduate or masters students. Write a python program that creates a dictionary from the above list where the keys will be each department name (CSE,EEE,MAT for the above example) and their values will be a dictionary of two keys - Undergraduate Courses and Graduate Courses. Each key will have courses that fall in Undergraduate and Graduate level respectively. Sample Input - No need to take input ['CSE110','CSE111','MAT620','CSE520','EEE361','CSE650','MAT510'] Sample Output: (You just have to print the resultant dictionary. No need to follow the pattern below) { 'CSE':{ 'Undergraduate':['CSE110','CSE111'], 'Graduate':['CSE520','CSE650'] },…
library contains books, periodicals, and DVDs (no items of other types are available and a given item belongs to only a single category). All these items can be used by the user of the library. Some of the items (books, periodicals, and DVDs) are only reference items, and others can be borrowed by the users. There are two types of users; registered users and temporary users. While registered users can borrow up to 100 items, the temporary users can borrow only 2 items at a time. In the initial work of the EER modeling, your teammates have identified Item, User, and ItemCopy as entities. Which of the following statements are correct about a possible EER model for this set of requirements? The specialization/generalization hierarchy for items that involve borrowing items and reference items has an optional participation constraint. The specialization/generalization hierarchy for items that involve the books, periodicals, and DVDs has a mandatory participation constraint. The user…
Some rows of the STUGRADE table of a school are shown below: STU_CODE CLS_CODE GRADE YEAR 291 111 3.1 2010 938 101B 2.3 2011 931 M101 3.3 2040 291 M101 3.4 2018 190 111 2.0 2021 931 321 3.9 2003 Suppose that STU_CODE is the student code (foreign key) and CLS_CODE is the class code (foreign key). Which of the following computes the average for each year of the student with code 931? a. SELECT AVG(GRADE) FROM STUGRADE WHERE STU_CODE = 931 GROUP BY YEAR b. SELECT AVG(GRADE) FROM STUGRADE WHERE STU_CODE = 931. c. SELECT AVG(GRADE) FROM STUGRADE GROUP BY STU_CODE = 931 d. SELECT AVG(GRADE) FROM STUGRADE WHERE STU_CODE = 931 GROUP BY AVG(GRADE)
function [ ] = square_spectrum( L,N )%Activity 1 for CEN415 Summer 2022 x=linspace(0,2*L,200);f1=(-1).^floor(x/L);plot(x,f1)f2=0;for n=1:2:N, f2=f2+4*sin(n*pi.*x/L)/n/pi;endhold onplot(x,f2)hold offend Q1= Run the function for L=3 and N=7 and upload the image of the graph plotted USE MATLAP
function [ ] = square_spectrum( L,N )%Activity 1 for CEN415 Summer 2022 x=linspace(0,2*L,200);f1=(-1).^floor(x/L);plot(x,f1)f2=0;for n=1:2:N, f2=f2+4*sin(n*pi.*x/L)/n/pi;endhold onplot(x,f2)hold offend 1-Run the function with L=3 and N=1 and upload the plotted graph use matlap
function [ ] = square_spectrum( L,N )%Activity 1 for CEN415 Summer 2022 x=linspace(0,2*L,200);f1=(-1).^floor(x/L);plot(x,f1)f2=0;for n=1:2:N, f2=f2+4*sin(n*pi.*x/L)/n/pi;endhold onplot(x,f2)hold offend 2-Run the function for L=3 and N=3 and upload the image of the graph plotted use matlap
function [ ] = square_spectrum( L,N )%Activity 1 for CEN415 Summer 2022 x=linspace(0,2*L,200);f1=(-1).^floor(x/L);plot(x,f1)f2=0;for n=1:2:N, f2=f2+4*sin(n*pi.*x/L)/n/pi;endhold onplot(x,f2)hold offend Q1= In which case the bandwidth decreases? a. When N decreases b. When L increases c. When L decreases d. When N increases e. None