IMG_2540

Exercise 1 - Ms excel Insert Pivot Table: Your task is to bring up the pivot table. Then remove the grand total and edit the pivot table. Group Data by Year: The second task is to group the sales amount by the year or months. Find Running Total by Date: Your objective is to find the running total by date using the data. Insert a Pie Chart: You will create a pie chart from the data in this problem, you will need to insert slicer to the pivot table. Use the calculated Field to find the sales tax which is 5% of the total sales.

10. Using the INDEX function only, write a formula in cell H10 to find the state name having the minimum "Sum of Percentage". The formula should include the value(row number) that is calculated in G10. Thank you screenshot attached

ED I book title - as1.pdf 771 1 of 4 f Facebook (198) YouTube 8 https://moodle31.upei.ca/pluginfile.php/902631/mod_resource/content/1/as1.pdf *Objectives By completing this assent you are demonstrating your ability to: • Decompose problems to create new solutions • Use variables and expressions to store and manipulate data • Use console input to take in data from a user • Create console output to report data to users • Call functions • Comment your code appropriately Instagram • You can make use of built-in Python functions. • The code must be properly commented, it will carry marks. + 80% nt requirements • You are not allowed to use conditional statements, relational operators, and logical operators. • You must solve this problem using arithmetic expressions. Introduction Am x n LEGO baseplate is a collection of interconnected cells in a grid, where m is the number of rows and n is the number of columns (m, n > 2). A baseplate has raised studs on the top. The classic LEGO bricks have…

red Question 27 Complete the following script so that the variable totarea will contain the total area of all polygons in a polygon shapefile, flcounties.shp. import arcpy infc r"D:\data\flcounties.shp" rows = arcpy.da.SearchCursor(infc, totarea = 0 for row in rows: totarea += print totarea

Please continue the codes of the remaining items (4-6).

First function, red and dotted line y = 1- Vx3 + 2x2 + 2x + 4 Second function, yellow and dashed line y = 2(1 – x)ex – 1 Plot the given equations in a single figure in the range between -1 and 1 having at least 100 steps with the given colors and styles, also add a legend to the figure. You can write "first function" and "second function" in the legend. %3D Please attach the code in a doc or docx file! ONLY working codes will be evaluated!

Please do correct answer otherwise I downvote. Code and screenshot also want

Transcribed Image Text SOL Assignment Salesforce: In this assignment you have to find the all the account or contact where the 'test' key in find either in account name or in contact first name and in last name. otherwise l'll downvote multiple please do no provide uploaded answer on bartleby times

Subject Data Science Write python codes to draw a wordcloud on this notebook. The wordcloud must show the titles of only Movie in the type column from Netflix. For input data, use netfliex_titles.csv. Thank you in advance

Aim: Write a code to plot bar chart for population data of years from 2005 to 2020 and playing animation using D3.js.

True or False .Each of our header and trailer sentinels contain an actual element.

Here_to change it throughout your code. .

Transcribed Image Text the following code is not true because 1Dim jas integer, i as integer, Z as single 2Dim k as integer, Las integer 3 K=5 4 L=2 5 For i=1 to Nt.text 6 F1=1 7 Forj=1 to i 8 F1=F1*j 9 Next j 10 Z=Z+ (X.text)^(L)/F1 11 L=L+k 12 K=K+1 13 Next i 14 Zt.text=Z+1 step 1 step 2 step 3 step 4 step 5 step 6 step 7 step 8 step 9 step 10 step 11 step 12 step 13 step 14 O O O O O O

TRUE OR FALSE   IF FALSE, change the bold highlight into a correct answer.

ython, use Jupiter notebook Create a grid of bar plots with each one representing a single zip code and in that zip code, the price listribution is grouped by the category of the condo, residential and multi-family, please also include ticks, abels, and legend in your plot iacramentorealestatetransactions.csv street city zip state beds baths sq__ft type sale_date price Wed May 3526 HIGH 21 Residential 59222 SACRAMENTO 95838 СА 2 1 836 ST 00:00:00 EDT 2008 Wed May 51 ОМАНА SACRAMENTO 95823 СА 3 1 1167 21 Residential 68212 CT 00:00:00

Using the colon symbol, create a row vector (assign it to a variable named Fives) with five elements that are all five.

From this data frame, remove the age column and make the day in increasing order - Code should have comments Gender Age 1 2 M 3 F F 45 5 M 17 51 62 23 Month Day 3 4 22 12 13 25 8 1

this practice assignment wants me to:  Create a document named ShowGuestBook.php that dis- plays the names of visitors who have signed the guest book. Use the readfile() function to display the contents of the guestbook.txt file. Note that you will need to use the element for Web browsers to recognize the line breaks. here is my two PHP files and my html codes.  I am getting an ( ! ) Parse error: syntax error, unexpected 'POST' (T_STRING) on SignGuestBook.php on line 10! i cant seem to figure out whats the issue , help please!! GuestBook.html <!DOCTYPE> <html><head><title>Guest Book</title></head> <body><h2> Enter your name to sign our guest book </h2><form method="POST" action="SignGuestBook.php"><p>First Name <input type="text" name="first_name"/></p><p>Last Name <input type="text" name="last_name"/></p><p><input type="submit" value="Submit"…

Downvote for incorrect filling  Atrach code with screenshot.

Question 20 (1 point) You have a flexbox with child boxes in a row. You want the child boxes to be displayed in the opposite order in which they appear currently. Which code do you use? 1) flex-flow: column-reverse 2) flex-flow: row-reverse 3) flex-flow: row-order-reverse 4) flex-flow: reverse

Question No: 01 202 123nt505 sa subjective question, hence you have to write your answer in the Text-Field given below. 76610 The e popular amusement ride known as the corkscrew has a helical shape. The parametric equations for a circular helix are LP/05 x = a cos t ya sin t z = bt where a is the radius of the helical path and b is a constant that determines the "tightness" of the path. In addition, if b>0, the helix has the shape of a right-handed screw; if b < 0, the helix is left-handed. Obtain the three-dimensional plot of the helix (write program or only commands) for the following three cases and compare their appearance with one another. Use 0 <= t <=10 pi and a=1 a. b- 0.1 b. b= 0.2 c. b= -0.1

1)Complete the following script so that the variable totarea will contain the total area of all polygons in a polygon shapefile, flcounties.shp. import arcpy infc = r"D:\data\flcounties.shp" rows = arcpy.da.SearchCursor(infc,____________  ) totarea = 0 for row in rows:          totarea += ___________  print totarea   2)Complete the following script so that it will read all the polygons in a simple polygon shapefile, flcounties.shp, and print out the x and y coordinates of all the the vertices of each polygon. import arcpy infc = r"D:\data\flcounties.shp" rows = arcpy.da.SearchCursor(infc,__________  )  for row in ______________ :       ptarray =row[0]  . ____________       for pt in______________  :            print "{0}, {1}".format( _______________ , _____________)     Subject: Python Programming

Imagine that an xhtml document contains the following hyperlink tag I am Seven. When the link text (Seven) is clicked, the servlet with the URL pattern /process is called. Rewrite the code to instead use a form that submits to the same servlet to produce the exact same response using hidden form elements for any form parameters. The form should contain a submit button with the button text Seven. The form method should be get (case sensitive answer).