A grocery sells following product, namely: Instant noodle, Cooking oil, Rice, Sugar, Egg and Milk. The following data shows the item being sold within a year (12 months). Cooking Oil Rice [kg] [liter] Month Instant Sugar [kg] Egg [item] Milk [liter] Noodle [item] January February 45 55 56 45 100 34 43 57 60 40 122 30 March 40 58 53 35 134 32 April 56 70 24 28 156 45 May 30 80 35 40 166 40 June 38 78 39 43 165 49 July August September 40 70 45 48 164 50 35 76 44 49 167 52 36 77 43 50 164 55 October 20 85 59 50 167 55 November 21 90 65 52 168 53 December 15 106 87 59 190 53 The unit price of those items is following: Instant noodle 2,500 IDR/item, Cooking oil 10,000 IDR/liter, Rice 7,500 IDR/kg, Sugar 10,000 IDR/liter, Egg 2,000 IDR/item and Milk 15,000 IDR/liter. Develop a Python program to perform the following tasks: a. Calculate the total income for the whole year b. Define which product produces the highest income and when it happens c. Plot the income/month from each product in one graph and show the point of highest income with an arrow and annotation of "Highest Income"

A grocery sells following product, namely: Instant noodle, Cooking oil, Rice, Sugar, Egg and Milk. The following data shows the item being sold within a year (12 months). Cooking Oil Rice [kg] [liter] Month Instant Sugar [kg] Egg [item] Milk [liter] Noodle [item] January February 45 55 56 45 100 34 43 57 60 40 122 30 March 40 58 53 35 134 32 April 56 70 24 28 156 45 May 30 80 35 40 166 40 June 38 78 39 43 165 49 July August September 40 70 45 48 164 50 35 76 44 49 167 52 36 77 43 50 164 55 October 20 85 59 50 167 55 November 21 90 65 52 168 53 December 15 106 87 59 190 53 The unit price of those items is following: Instant noodle 2,500 IDR/item, Cooking oil 10,000 IDR/liter, Rice 7,500 IDR/kg, Sugar 10,000 IDR/liter, Egg 2,000 IDR/item and Milk 15,000 IDR/liter. Develop a Python program to perform the following tasks: a. Calculate the total income for the whole year b. Define which product produces the highest income and when it happens c. Plot the income/month from each product in one graph and show the point of highest income with an arrow and annotation of "Highest Income"

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter5: Working With Multiple Worksheets And Workbooks

Section: Chapter Questions

Problem 4AYK

See similar textbooks

Similar questions

An auto mobile company manufacture both a two wheeler and a four wheeler.A company manager wants to make the production of both types of vehicle according to the given data below . 1st data , total no of vehicle (two-wheeler+four-wheeler)=v The task is to find how many two wheelers as well as four wheelers need to manufacture as per the given data.
*In R please How many non-NA and how many NA values are there in the table? Create a new variable ans of class table that gives total number of non-NA as well as NA entries. The first component should be number of non-NA's, the second should be number of NA's. (You should have just one line of a code). New York Air Quality Measurements Description Daily air quality measurements in New York, May to September 1973. Usage airquality Format A data frame with 153 observations on 6 variables. [,1]OzonenumericOzone (ppb)[,2]Solar.RnumericSolar R (lang)[,3]WindnumericWind (mph)[,4]TempnumericTemperature (degrees F)[,5]MonthnumericMonth (1--12)[,6]DaynumericDay of month (1--31) Details Daily readings of the following air quality values for May 1, 1973 (a Tuesday) to September 30, 1973. Ozone: Mean ozone in parts per billion from 1300 to 1500 hours at Roosevelt Island Solar.R: Solar radiation in Langleys in the frequency band 4000–7700 Angstroms from 0800 to 1200 hours at Central Park Wind:…
Saira owns a small business and she frequently makes transactions. Sometimes she makes payments and other times payments are credited in her account. One of her customer Tania purchased a product and credited payment while another payment by Saira was in progress. Now the sequence of transaction is as follows:1. Tania’s account read amount in saira’s account2. Saira’s account read amount in saira’s account3. Tania added Rs. 500/- in original amount (that was lets suppose Rs. 60,000/ 4. Saira’s account subtracted Rs. 2000/- that she debited in someone else’s account form the original amount (that was Rs. 60,000) 5. Tania’s account committed the transaction 6. Saira’s account committed the transaction Draw the above-mentioned sequence in form of a table and see if there is a problem. What this problem is called and how can we avoid such kind of problem? Propose some solutions (at least two) and then explain which one is better and why?
In R, what does the bins meaning in the following code. bins <- seq(floor(min(x)),ceiling(max(x))) hist(x,breaks=bins,xlab="Height",main="Adult men heights")
E5.2.7 Display the total amount HAFH spends on manager salaries (as TotalSalary) and the total amount HAFH spends onmanager bonuses (as TotalBonus).
P1 - Loan Payment Schedule Main Street Bank is offering an annual interest rate discount based on the client’s credit score. The discount for each credit score level is provided in the table below. The lowest credit score is 300 while the highest credit score is 850. For example, the new interest rate for a client with a credit score of 755 and a current interest rate of 4.25% would be 4.25 – 0.75 = 3.50% interest rate Credit Score Rating Interest Rate Discount 300 - 579 Very Poor 0.00 580 – 669 Fair 0.25 670 - 739 Good 0.50 740 - 799 Very Good 0.75 800 - 850 Exceptional 1.00 Use modular programming concepts Create a program that includes a WHILE loop to generate a payment schedule for loans that are paid in equal monthly payments Input the loan number and retrieve required loan account from MS_LOANS table Output is shown below Monthly interest is calculated by dividing the yearly interest rate by 12 to get a monthly interest…
Customer ID 123 4 5 6 7 8 9 10 Items of transaction {A,B,E,D}{A,C,D,E}{D,E,A} {E,B,A,C} {B,B,E} {A,E,B} {E,D,E,C} {D,C} {B,D,E} {C,D,E,A} (a) Use the table shown to compute the support for the itemsets {B,D} and {B,C,E}. (b) Use the results in part (a) to compute the confidence for the association rules {b,d} {e} (c) How many itemsets can be generated from these items(d) How many association rules can be generated from the itemset {A,B,C,D,E,F}?
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)
DECLARE v_ave_sal NUMBER(10,2); v_deptno NUMBER NOT NULL := 60; BEGIN SELECT AVERAGE(salary) INTO v_ave_sal FROM emp WHERE deptid = v_deptno; DBMS_OUTPUT.PUT_LINE('Dep #60 Average Salary: ' || v_ave_sal); END; a. Dep #60 Average Salary:500 b. Dep #60 Average Salary:400 c. Dep #60 Average Salary:1000 d. Dep #60 Average Salary:600
A data set has 4 columns--index, CUSTOMER_EMAIL, Net Revenue, and Year. For each year we need the following information: New Customer Revenue e.g., new customers not present in previous year only Lost Customers New Customers Total Customers Previous Year Total Customers Current Year Please implement it using python.
Please due in C A sample run is as follows: ---=== EMPLOYEE DATA ===--- 1. Display Employee Information 2. Add Employee 3. Update Employee Salary 4. Remove Employee 0. Exit Please select from the above options: 5 ERROR: Incorrect Option: Try Again 1. Display Employee Information 2. Add Employee 3. Update Employee Salary 4. Remove Employee 0. Exit Please select from the above options: 1 EMP ID EMP AGE EMP SALARY ====== ======= ========== 1. Display Employee Information 2. Add Employee 3. Update Employee Salary 4. Remove Employee 0. Exit Please select from the above options: 2 Adding Employee =============== Enter Employee ID: 222 Enter Employee Age: 22 Enter Employee Salary: 22222.22 1. Display Employee Information 2. Add Employee 3. Update Employee Salary 4. Remove Employee 0. Exit Please select from the above options: 2 Adding Employee =============== Enter Employee ID: 333 Enter Employee Age: 33 Enter Employee Salary: 33333.33 1. Display Employee Information 2. Add Employee 3.…
Use Python Code Your task is : Number of reported COVID-19 deaths by country. (Use pandas to read the csv table. Example : df = pd.read_csv('Covid19Deaths.csv') then do the code using the dataframe) COVID-19 Deaths table (csv): Province/State Country/Region Lat Long ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## 2/1/2020 2/2/2020 2/3/2020 2/4/2020 2/5/2020 2/6/2020 2/7/2020 2/8/2020 2/9/2020 ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## 3/1/2020 3/2/2020 3/3/2020 3/4/2020 3/5/2020 3/6/2020 3/7/2020 3/8/2020 3/9/2020 ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## 4/1/2020 4/2/2020 4/3/2020 4/4/2020 4/5/2020 4/6/2020 4/7/2020 Afghanistan 33 65 0 0 0 0 0 0 0 0…