Homework template

Task 3: Amazon wants to find the best customer and likes to reward 50% discount on his next purchase. Find the Customer with the highest amount of total purchase amount. The output should the one as below: ]: 1 from IPython.display import Image 2 Image(filename = "Screenshot_72.jpg') ]: Custoner ID:16229 is the best custoner since he has spent a lot on our business. His total purchase amount is 3702.12 pesos.5e1 discount will be given on his next purchase

(c) Table below shows a dataset of contacts: Max Temp (°C) Weight (kg) 67 Height (cm) 163 Gender Company Good Friend Abu 37 M Ben 37 51 154 M Good Christine 28 76 182 Bad Dennis 29 68 159 M Good Eliza 28 99 151 F Bad Farhan 38 105 184 M Good Gina 34 51 160 Bad Hua 26 96 156 F Bad Iris 25 60 184 Bad John 26 63 184 M Good Kelvin 27 72 167 M Bad Latifa 26 106 155 F Good Maria 36 86 185 F Bad Ning 29 105 174 M Good Based on the table below, plot any TWO(2) charts to represent the CS Scanujingifomationn Scanner Max Temp ii. Weight

1 Datal.head(200) InvoiceNo StockCode Description Quantity InvoiceDate UnitPrice CustomerlD Country 536385 85123A WHITE HANGING HEART T-LIGHT HOLDER 01/12/2010 8:28 2.55 17850 United Kingdom 536365 71053 WHITE METAL LANTERN 6 01/12/2010 8:26 3.39 17850 United Kingdom 2 536365 84406B CREAM CUPID HEARTS COAT HANGER 01/12/2010 8:28 2.75 17850 United Kingdom 536365 84029G KNITTED UNION FLAG HOT WATER BOTTLE 01/12/2010 8:26 3.39 17850 United Kingdom 4 536365 84029E RED WOOLLY HOTTIE WHITE HEART. 01/12/2010 8:26 3.39 17850 United Kingdom 194 536388 21115 ROSE CARAVAN DOORSTOP 4 01/12/2010 9:59 6.75 18250 United Kingdom 195 536388 22469 HEART OF WICKER SMALL 12 01/12/2010 9:59 1.65 18250 United Kingdom 196 536388 22242 5 HOOK HANGER MAGIC TOADSTOOL 12 01/12/2010 9:59 1.65 18250 United Kingdom 197 536389 22941 CHRISTMAS LIGHTS 10 REINDEER 6 01/12/2010 10:03 8.50 12431 Australia 198 536389 21622 VINTAGE UNION JACK CUSHION COVER 8 01/12/2010 10:03 4.95 12431 Australia 199 rows x 8 columns Task…

Using KNN algorithm to find the 05 similar movies from the movies below. Movie ID Movie Name IMDB Rating Biography Drama Thriller Comedy Crime Mystery History Label 58 The Imitation Game 8 1 1 1 0 0 0 0 0 8 Ex Machina 7.7 0 1 0 0 0 1 0 0 46 A Beautiful Mind 8.2 1 1 0 0 0 0 0 0 62 Good Will Hunting 8.3 0 1 0 0 0 0 0 0 97 Forrest Gump 8.8 0 1 0 0 0 0 0 0 98 21 6.8 0 1 0 0 1 0 1 0 31 Gifted 7.6 0 1 0 0 0 0 0 0 3 Travelling Salesman 5.9 0 1 0 0 0 1 0 0 51 Avatar 7.9 0 0 0 0 0 0 0 0 47 The Karate Kid 7.2 0 1 0 0 0 0 0 0 50 A Brilliant Young Mind 7.2 0 1 0 0 0 0 0 0 49 A Time To Kill 7.4 0 1 1 0 1 0 0 0 30 Interstellar 8.6 0 1 0 0 0 0 0 0 94 The Wolf of…

Year Qtr 1 Qtr 2 Qtr 3 Qtr 4 Total 2009 312 406 393 487 1,598 2010 239 373 271 440 1,323 2011 268 284 290 486 1,328 2012 307 357 333 507 1,504 2013 333 409 354 524 1,620 2014 330 388 379 516 1,613 2015 294 376 385 535 1,590 Year Qtr Planes 2009 Qtr1 312   Qtr2 406   Qtr3 393   Qtr4 487 2010 Qtr1 239   Qtr2 373   Qtr3 271   Qtr4 440 2011 Qtr1 268   Qtr2 284   Qtr3 290   Qtr4 486 2012 Qtr1 307   Qtr2 357   Qtr3 333   Qtr4 507 2013 Qtr1 333   Qtr2 409   Qtr3 354   Qtr4 524 2014 Qtr1 330   Qtr2 388   Qtr3 379   Qtr4 516 2015 Qtr1 294   Qtr2 376   Qtr3 385   Qtr4 535   (c) Use MegaStat or Minitab to calculate estimated seasonal indexes and trend. (Round your answers to 3 decimal places.)  Qtr1Index   Qtr2Index   Qtr3Index   Qtr4Index    ?      ?      ?      ?                    (d) In which quarters are shipments highest? Lowest? (You may select more than one answer. Click the box with a check mark for…

Task-2: Amazon wants to reward the customer who has done the most number of transactions, by providing a gift hamper worth 1000 pesos. Find out the customer who has done the most number of transactions [Note: One invoice number corresponds to one transaction]. The output should the one as below: Hurray!The most number of transactions is done by Customer ID: 17850. He has made 45 transactions. He will be rewarded with ou gift hamper worth 1000 pesos

A correlation coefficient equal to means 100% correlation in the opposing sense O -1 O -100 O 1

Calibri (Body) 9 B I U S aAv 11 fx A B K M 1 COMPUTER CSc 4210/6210 Spring 2022 2 ARCHITECTURE HW 1 Due 25-Jan 11:59 PM 3 Name: Your GSU email: @student.gsu.edu (last 4 digits of your ID) 4 total hw questions=9 This hw covers Lect1 - Lect3 1- Use truth table to prove the following expressions by inserting either logic 'O' or '1', for the left hand side (LHS) and the right hand side (RHS): 6 [(XÂY)+Z*(X+ZX)]L= [X°Y+X°Z*+XY*]L (Solved Example) i- A=XOR to display Å as XOR highlight it and change the font to symbol X Y LHS RHS 1 1 1 1 1 1. 1 1 1 1 1 ii- [v'u +v't'u +v°t]L = [v°(vÅtÂu ")+v°(v'At+vAu )]L V u LHS RHS 1 1 1 1 1 1 1 1 1 1

Section Mean Standard Deviation English 20.3 6.8 Math 20.7 5.4 Reading 21.4 6.5 Science 20.9 5.5 STEM 21.0 5.2 Aisha and Amber both took the ACT on the same day. They both earned a 27, but in different sections. Aisha had a 27 on her Science, but Amber had a 27 on her Math. Which of the girls did better with respect to the other students who took that section? Aisha's z-score:  z =  Amber's z-score:  z =  Who did better?

Using the data below. Estimate the amount of particulate removed when daily rainfall is x = 4.8 units. Daily rainfall, x Particulate removed, y (0.01) (mcg/cum) 4.3 126 4.5 121 5.9 116 5.6 118 6.1 114 5.2 118 3.8 132 2.1 141 7.5 108 O 123 O 125 O 121 O 122 о O 120

a) Normalize the following table to the third normal form. PROJ NUM PROJ NAME 15 Evergreen 18 22 25 Amber Wave Rolling Tide Starflight EMP_NUM 103 101 105 106 102 114 118 104 112 105 104 113 111 106 107 115 101 114 108 118 112 EMP NAME June E Arbough John G News Alice K Johnson William Smithfield David H. Senior Annelise Jones James J. Frommer Anne K. Ramoras * Darlene M. Smithson Alice K Johnson Anne K. Ramoras Delbert K. Joenbrood Geoff B. Wabash William Smithfield Maria D. Alonzo Travis B Bawangi John G. News T Annelise Jones Ralph B. Washington James J. Frommer Darlene M. Smithson 8 JOB CLASS Elect Engineer Database Designer Database Designer Programmer Systems Analyst Applications Designer General Support Systems Analyst DSS Analyst Database Designer Systems Analyst Applications Designer Clerical Support Programmer Programmer Systems Analyst Database Designer Applications Designer Systems Analyst General Support DSS Analyst CHG HOUR HOURS 84.50 105.00 105.00 35.75 96.75 48 10…

Year Airfare 2004 402.26 2005 391.5 2006 405.48 2007 390.3 2008 400.27 2009 359.91 2010 383.48 2011 402.45 2012 406.13 2013 407.99 2014 411.67 2015 395.7 2016 361.94 2017 352.85 2018 346.49 In R language,1) Conduct time series plot of the average airfare data. Question #1: What patterns do you notice in the time series plot of average annual airfare from 2004 to 2018? (a. horizontal pattern, b. clear upward trend, c. clear seasonal effects, d. clear downward trend) 2) Use a simple moving average with n = 3 (3 years) to calculate a forecast for the average airfare in 2019. Question #2: What is the 2019 forecast for average airfare using the simple moving average technique? (Round to two decimal places) 3) Based on the predicted values up to 2018, calculate accuracy measures (MAE, MSE, RMSE, and MAPE) for the simple moving average method. Question #3: What is the MAE for the simple moving average method?(Round to two decimal places) 4) Use a simple…

Computer Science pamuk_uretimi YEAR_ birincifarki alinmis_ser var var var 1 19579 1932 2 27791 1933 8212 3 37762 1934 9971 4 52228 1935 14466 51068 1936 -1160 6 67185 1937 16117 64731 1938 -2454 8 63950 1939 -781 9 77115 1940 13165 10 64184 1941 -12931 11 74055 1942 9871 12 53392 1943 -20663 13 58916 1944 5524 14 54379 1945 -4537 15 59027 1946 4648 16 51456 1947 -7571 17 58198 1948 6742 18 104156 1949 45958 19 118377 1950 14221 20 150000 1951 31623 21 165000 1952 15000 Do it using Box and Jenkins Method and R program.

M = C mod n %3D 29 M =32 mod 65 %3D M =

Try these problems: 1) 910 - 710 = 210 0000 1001 0000 0111 = 2) 1710 - 1210 = 510 0001 0001 0000 1100 = 3) 1810 - 2210 = - 410 0001 0010 - 0001 0110 = %3D 4) 710 - 1910 = - 1210 0000 0111 0001 0011 = 5) - 2610 + 1010 = - 1610 1001 1010 + 0000 1010 = 6) - 1910 + 610 = - 1310 1001 0011 + 0000 0110 =

Calculate the Pearson correlation coefficient.

235 U as The material that formed the earth was created in a supernova explosion approximately 6 billion years ago. The two most common isotopes of uranium, 238 U and 235 U were created in roughly equal amounts. Today, the earth contains more than 100 times as much 238 U ▾ Part A Which isotope has a longer half-life? Select the correct answer and explanation. 238 O 8U has a longer half-life because more of it have decayed. O235 U has a longer half-life because less of it have decayed. O238 U has a longer half-life because less of it have decayed. 235 U has a longer half-life because more of it have decayed.

I have these data sets (A) Emissions Year Country Continent Emission 0 2008 Aruba South America 24.750133 1 2009 Aruba South America 24.876706 2 2010 Aruba South America 24.182702 3 2011 Aruba South America 23.922412 4 2008 Andorra Europe 6.296125 .. ... ... ... ... 783 2011 Zambia Africa 0.212450 784 2008 Zimbabwe Africa 0.569255 785 2009 Zimbabwe Africa 0.600521 786 2010 Zimbabwe Africa 0.646073 787 2011 Zimbabwe Africa 0.691698 (B) Gap_long Country Year Population 0 Afghanistan 2008 27700000 1 Albania 2008 3000000 2 Algeria 2008 34700000 3 Andorra 2008 83900 4 Angola 2008 21700000 .. ... ... ... 775 Venezuela 2011 28900000 776 Vietnam 2011 88900000 777 Yemen 2011 23800000 778 Zambia 2011 14000000 779 Zimbabwe 2011 12900000 Using pandas in python code How do I create a new dataframe that only contains the rows that were present in both emissions and gap_long . Name this dataframe emissions_both. I was given this Hint by another user: Looking at the _merge column may be helpful. I…

ID Student Number Surname Name Test 1 Test 2 Test 3 Test 4 Final mark PASS/FAIL 1 217545455 Johaness Wheeler 45% 34% 49% 21% 37 FAIL 2 217452154 David Albertina 45% 34% 49% 4% 33 FAIL 3 217454151 Waldo Gertze 75% 75% 63% 88% 75 PASS 4 217486414 Kalimbo Andreas 51% 56% 90% 90% 72 PASS 5 217454155 Hakweenda Junior 44% 28% 35% 14% 30 FAIL Answer  the following  questions using the table above  Use student 2017 table to create a query that will display Student Number, Surname, Name and Pass/Fail field for all the students whose final result is "PASS". Save the query as "Pass".     Use student 2017 to create a query that will display the student's surname and final mark field for all the students whose final mark is between 0 -  40. Save the query as "Fail"         Use student 2017 to create a query that will display the student number and surname for all the students whose surname consist of letter "O" in it. Save the query as "Surname".

Evaluate the expression (11011∧01011)⊕(00001∨00111) . A) 01011 B) 00111 C) 01100 D) 01010

Convert the following by showing all the steps necessary a) (1001111)2 b) (11000001)2 c) (E16)16 d) (56)10 e) (63)10 )10 16 10 )16 %3D %3D = ( = ( Rubrics (Scoring Guide) - Steps = 80% - Correct Answer = 20%

A video frame displayed onscreen consists of many pixels, with eachpixel, or cell, representing one unit of video output. A videodisplay’s resolution is typically specified in horizontal and verticalpixels (such as 1920 3 1080), and the number of pixels onscreen issimply the product of these numbers (1920 3 1080 5 2,073,600 pixels).A pixel’s data content is one or more unsigned integers. For ablack-and-white display, each pixel is a single number (usuallybetween 0 and 255) representing the intensity of the color white.Color pixel data is typically represented as one or three unsignedintegers.When three numbers are used, the numbers are usually between 0 and255, and each number represents the inten- sity of a primary color(red, green, or blue). When a single number is used, it represents apredefined color selected from a table (palette) of colors.Motion video is displayed onscreen by copying frames rapidly to thevideo display controller. Because video images or frames require manybytes…

Find the values of x and y using pseudoinverse. x + 3y = 17;  5x + 7y = 19;   11x + 13y = 23

Quarter Revenue 2014Q1 1050 2014Q2 1005 2014Q3 1169 2014Q4 1420 2015Q1 1566 2015Q2 1824 2015Q3 2085 2015Q4 2405 2016Q1 2566 2016Q2 2886 2016Q3 3231 2016Q4 3536 2017Q1 3661 2017Q2 4100 2017Q3 4584 2017Q4 5113 2018Q1 5442 2018Q2 6105 2018Q3 6679 2018Q4 7430 2019Q1 7696 2019Q2 8381 2019Q3 8995 2019Q4 9954 2020Q1 10219 2020Q2 10808 2020Q3 11601 2020Q4 12742 2021Q1 13503 2021Q2 14809 2021Q3 16110 2021Q4 17780 In R language, Create a time series plot of the Amazon Web Services revenue data.1) Use linear regression first to model the trend in the time series. After conducting a linear regression to model the trend in the timeseries, what is the slope coefficient for the trend variable?2) Calculate accuracy measures for predicted values based on the regression in (1).What is the MAPE based on the results of the linear regression you just conducted? (Round to two decimal places)3) Based on the pattern in the time series data,…

Q4/ A: How to use MATLAB to verify that the identity is correct for the trigonometric identity given below: Substituting: x= 25°. 1-2cosx - 3cos²x__ 1-3cosx sin²x 1– cosx =

dont post existing answer dont answer without knowledge

The arrival times of geese to a gaggle were recorded (in seconds) and given in the stemplot below. 134599 21778 2345 32 4599 6 22 What is the 12th fastest time a goose took to join the gaggle? Make sure to use labels and avoid the use of abbreviations. Your Answer:

(212)d (EFCDB)h 26 2 (919)d (E1FDC2)h 27 3 (517)d boo o ool0 1)b (AFBD7)h 28 (413)d 4 29 (FFCC2)h 5 (212)d Jo 30 (EFCDB)h 6 (919)d 31 (E1FDC2)h (517)d (AFBD7)h 32 8. (413)d )o 33 (FFCC2)h (212)d 34 (EF2C1D6)h 10 (919)d )h 35 (E1F2D3C2)h Jo 11 (517)d )h 36 (AIF2B4D7)h Jo (413)d (F1F9C8C2)h 12 )h 37 Jo 13 (7777)o )d 38 (E4F6C5D7B)h Jo 14 (34567)o )d 39 (11101)b 15 (27354)o )d 40 (111010)b 16 (765)o )d 41 (1110111)b 17 (730274)o 42 (10101)b 18 (342567)o )b 43 (1110101101011)b 19 (275354)o 44 (10101010101001)b (763615)o )b 45 (11010101010101011)b (731274)o (110000101010101010)b 21 46 (342467)o (11010101010101010)b 22 47 (110000101010101011)b (1110101101011)b )h )h (275254)o (763315)o 23 48 24 )h 49 (321456) 50 (10101010101001)b )h 25 20

question 51/52

7F1= (126)8/(A)16 F2= (86)10/ (0011 0111)BCD(3311) F3= (1111101)Gray/(10011)Ex-3 F4= (56)16/(20)8 Chose the correct answer O F3=F4 O F1=F2 F2=F4 F1=F3 None of them O F2=F3