3.
Question 6. 2. Calculate B, (in units of cm"') for "N"O if r is equal to...
check 1&2 do 3-5 in VBA BAProject (C13-sale Data s Micosoft Excel Objects 1) Caleulate the sum of sales tor January, put the result in B17 Players (Players) Din colunnsum As Integer colunnau0 For i-1 To 13 wSales(Sales) s Modules n columnsum +ActiveWorkbook.Morksheets("Salea").Range ("84:816*).Cellsj. 1).Value Next BAProject (HomeworksWorksheets("Sales").Range "B17")columnsum Microsolft Excel Objects Players (Players) 旬nsales (Sales) Modules 2) Calculate the sum of sales for Febuary, put the result in c1 Module colusnsum- For j-1 To 13 colunnsum -columnsum ActiveWorkbook.Work sbeets(Salea")...
Python Pandas, Series and DataFrame Question (NO Loops, No If Statements, No List Comprehensions) The file bank.csv contains data about bank customers. The last column ('Personal Loan') indicates whether or not the customer was approved for a personal loan or not. Write a function named loan_by_zip that accepts 3 parameters: a file name, a minimum number of records, and a percentage approval rate. The function should return a DataFrame of those zip codes for which we meet the minimum number...