65 9. The table P2.1 shows the number of paid transactions on the website during the period 2012 to 2020. 66 (i) In cell E70, write a formula using RRI function to compute the Compounded Annual Growth Rate (CAGR) for the period 2012 to 2020. 67 68 69 70 71 72 73 74 75 76 77 78 79 00 Year Table P2.1 2012 2013 2014 2015 2016 2017 2018 2019 2020 Number of transactions 10000 15000 35000 68000 122400 232560 488376 976752 2441880 CAGR Correct Answer CAGR 98.823%

65 9. The table P2.1 shows the number of paid transactions on the website during the period 2012 to 2020. 66 (i) In cell E70, write a formula using RRI function to compute the Compounded Annual Growth Rate (CAGR) for the period 2012 to 2020. 67 68 69 70 71 72 73 74 75 76 77 78 79 00 Year Table P2.1 2012 2013 2014 2015 2016 2017 2018 2019 2020 Number of transactions 10000 15000 35000 68000 122400 232560 488376 976752 2441880 CAGR Correct Answer CAGR 98.823%

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 2.10CP

See similar textbooks

Similar questions

Using paython Functions and list
Order Number: 5678 Customer Number: 9123 Customer Name: Thomas Customer Address: 51 Samora Machel Street City- Country: Durban, South Africa ProductNo A 123 B 234 C 345 Description A4 Paper Order Form Toner Staples Normal Form Quantity 100 200 1000 Date: 25/12/2020 Unit Price R1.00 R150.00 R5.00 1.1 Using normalization principles, depict the ONF, 1NF, 2nd NF and 3rd NF of the data above. Example: Below is an example of the table information converted to zero normal form, read chapter five in your module guide and convert the table to first, second and third normal form. The format of your answer must be as depicted below: • ORDER( order number, customer number, name, address, order date(product number, description, quantity, unit price))
Need ans ASAP
Homework2 (1 solution Using Python A database has 5 transactions. Let min_sup = 60 % and min_conf = 80 % . TID T100 T200 T300 T400 T500 (a) Find all frequent itemsets using Apriori items_bought {M, O, N, K, E, Y} { D, O, N, K, E, Y} { M, A, K, E }{M,U,C,K,Y}{C,0,0,K, 1, E}(b) List all of the strong association rules (with supports and confidence c) matching the following metarule , where X is a variable representing customers , and item , denotes variables representing items ( eg,"A","B", etc. ) : Va e transaction , buys ( X , item, ) A buys (X, item, ) → buys ( X , item3 ) ) [s,c] II
Find your group number• The remainder after division of second to last digit of your student id by 3 is a.• The last digit of your student id is b.• Your group number is ab, which is an integer between 0 and 29.• If your group number is equal to ab=00 then take it as ab=01.Examples:• Student Id = 290316027 → Group = 27• Student Id = 290315043 → Group = 13• Student Id = 280315061 → Group = 01• Student Id = 270316085 → Group = 25• Student Id = 290315027 → Group = 27 my student Id is 280316014 but i didnt calculate ab.Can you help me .Thank you.
Table (A) shows the individual income tax rates for assessment year 2020. Table (A): Income tax rates assessment year 2020 Chargeable Income (RM) 0- 5,000 Calculation (RM) On the First 5,000 On the First 5,000 Next 15,000 On the First 20,000 Rate % Таx (RM) 5,001 – 20,000 1 150 150 20,001 – 35,000 3 Next 15,000 450 On the First 35,000 Next 15,000 600 35,001 – 50,000 8 1,200 Write a complete C program to prompt the user to enter the total chargeable income (RM), and then calculate the tax based on the calculation given in Table (A). For example: Prem's chargeable income = RM30,000 (RM20,000 + RM10,000) Total tax = RM150 (for first RM20,000) + RM300 (3% x RM10,000) = RM450 The program will then display the result which is the total amount tax needed to be paid in Ringgit Malaysia (RM), up to three significant digits after the decimal point. Requirements: Apply one return value function, include parameter list if necessary - Apply one non-return value function, include parameter list if…
Use Python Code Your task is : Visualization of confirmed cases of COVID-19 by country . (Use pandas to read the data table csv. Example df = pd.read_csv('COVID19.csv' ) then make a visualization using that csv table) Province/State Country 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 0 0 0 0 0 0 0 0…
The following is a table of applicants to be considered for admission into 07BSAM: POINTS MATH SYMBOL 123 450 NAMES STUDENT NUMBER ENG SYMBOL To qualify for admission, an applicant should have at least 25 points, minimum of B symbol in Mathematics and a minimum of E symbol in English. If an applicant has a C symbol in Mathematics, then the applicant must pass an entrance test to be considered for admission. Hints: There are three modes of study: The Full-time mode, the Part-time mode and the Distance mode. Applicants can choose which mode they want provided there is space in that mode. Each of the Full- time and the Part-time modes cannot accommodate more 30 admitted students. After these two modes are full, every other qualified applicant is admitted in the Distance mode. The admission exercise is first come first served. Write a pseudocode that identifies the applicants that qualify for admission and outputs their names, student numbers and modes of study. Use a FOR-LOOP /…
The following table shows the student grades for Q1 and Q2 assessment activities. Calculate the mean and mode for Q1 and Q2 grades Calculate the range and standard deviation for Q1 grades and Q2 grades Student Number Q1 Grade Q2 Grade Total student Grade 1 85 79 164 2 96 85 181 3 84 76 160 4 75 76 151 5 64 94 158 6 83 83 166 7 92 92 184 8 74 71 145 9 67 81 148 10 81 93 174 11 93 72 165
What is the Manhattan distance between different points as shown below? Fill the table with appropriate Manhattan distances. As an example, the distance between points A and C is computed in the appropriate table cell
Consider the following Employee table: ID Name Hire Date Address Salary *** 15/5/2010 Isa Town 20/6/2012 Hamad Town 5/6/1989 Zahra Town 1/10/2005 Salman Town 17/5/2017 Hessa Town Isa $4000.00 $3500.00 $6500.00 $9000.0 $4500.00 Hamad Zahra Salman Hessa Write a PUSQL program segment to retrieve the id, name, and Salary of the employees whose salaries greater than 4000 using an explicit cursor. Use the editor to format your answer 123 45
4, Use the given data to classify the record below using the k-NN algorithm for k=1 to 5. Loan Purpose Checking Savings Months Customer Months Employed Repairs 0 900 25 4 Complete the table below for the nearest neighbors and for the classification of the new record for each value of k. k Distance Classification 1 enter your response here ▼ High Low Tie 2 enter your response here ▼ High Low Tie 3 enter your response here ▼ High Low Tie 4 enter your response here ▼ Low High Tie 5 enter your response here ▼ High Tie Low (Round to four decimal places as needed.) Loan Purpose Checking Savings Months Customer Months Employed Credit Risk Business 322 578 10 14 Low New Car 0 821 25 63 High New Car 0 10723 11 15 Low Small Appliance 0 407 13 2 Low Business 16647 895…