WPC-300_Assignment1

Create a table of your courses for this semester with fictitious grades for Test 1, Test 2, and Test 3 with appropriate weighting. The next column should determine the grade using the 'if' function, with plus and minus. The grade cell should show a discrete color scheme with below C- in red; above B in green and, yellow for the rest. This should be done using conditional formatting of cells.

Open the Excel file Student_Excel_Intro_Cap1_Year_End_Report.xlsx downloaded with this project. On the Net Sales worksheet, calculate totals in the ranges F4:F8 and B9:F9. Apply the Total cell style to the range B9:F9. Using absolute cell references as necessary, in cell G4, construct a formula to calculate the percent that the Colorado Total is of Total Sales, and then apply Percent Style with zero decimals. Fill the formula down through the range G5:G8. In the range H4:H8, insert Line sparklines to represent the trend of each state across the four quarters. Do not include the totals. Display Markers. Select the range A3:E8, and then use the Recommended Charts command to suggest an appropriate chart. Click the first Clustered Column chart that uses the state names as the category axis. Align the upper left corner of the chart inside the upper left corner of cell A11, and then size the chart so that its lower right corner is slightly inside cell H24. Apply chart Style…

Task 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing the customer satisfaction. They want to learn the travel time for each ride in the system. You need to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF function on the TRAVEL_END_TIME and the TRAVEL_START_TIME.

For the Excel file Closing Stock Prices,   apply both column and line sparklines to visualize the trends in the prices for each of the four stocks in the file.

2. In the attached file, you will find the oil production for all countries that produce more than 1Mbpd, use pie chart and bar chart to show the percentage of production for each of them. country bpd United States 11567000 Russia 10503000 Saudi Arabia 10225000 Canada 4656000 Iraq 4260000 China 3969000 United Arab Emirates 2954000 Brazil 2852000 Kuwait 2610000 Iran 2546000 Kazakhstan 1937000 Norway 1744000 Мexico 1733000 Qatar 1297000 1258000 Nigeria Libya 1220000 Angola 1158000

Task 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing the customer satisfaction. They want to learn the travel time for each ride in the system. You need to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF function on the TRAVEL_END_TIME and the TRAVEL_START_TIME.

Week 4 Lab assessment task Use the function julia, that you have defined, to produce an image of a Julia set. Please try to find a "nice" seed constant that produces an interesting Julia set that is different from the provided example. At your choice, you may also customise the colour map or other aspects of the image. Use the title command, and optionally the subtitle command, to add a title in the same format as the image shown below. Sample code: julia (0.4,0.4,1500,50) ; 2 hold on 3 title (" Julia set c = 0.4 + 0.41") 4 subtitle ("Oliver Heaviside ID 123456789") s hold off

2. In the attached file, you will find the oil production for all countries that produce more than 1Mbpd, use pie chart and bar chart to show the percentage of production for each of them. Canada 4656000 4260000 country bpd Iraq China United States 11567000 3969000 Russia 10503000 United Ara 2954000 2852000 2610000 2546000 Kazakhstan 1937000 1744000 Saudi Arabia 10225000 Brazil Canada 4656000 Kuwait Iraq 4260000 Iran China 3969000 United Arab Norway Mexico Emirates 2954000 1733000 Brazil 2852000 Qatar 1297000 Kuwait 2610000 1258000 1220000 1158000 Nigeria Iran 2546000 Libya Angola Kazakhstan 1937000 Norway 1744000 Мехico 1733000 Qatar 1297000 Nigeria 1258000 Libya Angola 1220000 1158000 USING MAT LABEL PROGRAM Unted States Mexico Nonway 10 Kazakhatan van Kuwat Rusia Bras 3d Arat Emirates China Saud Arabia rag Canada

Create a formula that provides this information as follows: In cell H3, begin to enter a formula using the VLOOKUP Use the Project ID (cell H2) as the lookup value. Use the Lookup table (range A2:E23) as the table_array. Use the Project Name column (column 2) as the col_index_num. Specify an exact match (FALSE) for the range_lookup.

Statistics AUS DFW IAH # of Shipments Total Order Value Average # of Days Houston (IAH) Orders Over $1,000 Number of Orders Shipped Total of Orders Shipped Highest Order Value Airport Order Date Ordered Total Days 4/5/2021 4/5/2021 4/5/2021 Code Total 4 AUS $ 975 $ 1,055 $ 1,075 $ 1,000 $ 2,535 $ 1,890 10 AUS 11 IAH 4/5/2021 7 DFW 4/5/2021 11 IAH 4/5/2021 4/5/2021 7 DFW 11 AUS 950 4/6/2021 9 DFW $ 1,485 4/6/2021 4/6/2021 3 DFW $ 550 $ 1,250 $ 1,600 $ 2,500 $ 1,425 13 AUS 4/6/2021 8 IAH 4/6/2021 13 DFW 4/7/2021 IAH Week Stats Map Loan

Create a new workbook as shown below and save the file with the name "Call Statistics". 1 Panda EST Monthly Sales Report - July 2 3 Sales Amount 1600 1800 Total Salary 4 Emp. No. Name 5 S101 6 S105 7 S112 8 s107 9 S110 Salary Comission 2500 ? 3000 Ahmed Hassan Ali 1500 2200 Waleed Mohammed Samir 4500 3500 2000 1700 10 s103 1600 2500 11 Totals Average Highest Lowest Count 12 13 12 14 15 16 a) Create the worksheet shown above. b) Set the column widths as follows: Column A: 8, Column B: 14, Columns C & D: 15, Columns E & F: 14. c) Enter the formula to find COMMISSION for the first employee. The commission rate is 2% of sales, COMMISSION = SALES * 2% Copy the formula to the remaining employees. d) Enter the formula to find TOTAL SALARY for the first employee where: TOTAL SALARY = SALARY + COMMISSION Copy the formula to the remaining employees. e) Enter formula to find TOTALS, AVERAGE, HIGHEST, LOWEST, and COUNT values. Copy the formula to each column. f) Format numeric data to include…

Can somebody help me with my homework? I provided screenshots of my code that goes alongside the question.  *Side note comments would be helpful, but not required.

Compulsory Task 1 Answer the following questions: HHyperionDev ● Go to the w3schools website's SQL browser IDE. This is where you can write and test your SQL code using their databases. Once you are happy with it, paste your code in a text file named Student.txt and save it in your task folder. Write the SQL code to create a table called Student. The table structure is summarised in the table below (Note that STU_NUM is the primary key): STU_NUM Attribute Name STU_SNAME STU_FNAME STU_INITIAL STU_STARTDATE COURSE_CODE PROJ_NUM STU_ STU_S STU_F STU_INITIAL NUM NAME NAME 01 02 Snow John After you have created the table in question 1, write the SQL code to enter the first two rows of the table as below: E Stark Arya с CHAR(6) VARCHAR(15) VARCHAR(15) CHAR(1) DATE CHAR(3) INT(2) Data Type STU_STARTDATE | COURSE_ CODE 05-Apr-14 12-Jul-17 201 305 PROJ_ NUM 6 11 • Assuming all the data in the Student table has been entered as shown below, write the SQL code that will list all attributes for a…

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

Split the MR_X and MR_y into training set and test set. You should use the num training variable to extract the data from MR_X and MR_y. Extract the first 'num_training' samples as training data, and extract the rest as test data. Name them as: MR_train_X and MR_train_y for the training set MR_test_X and MR_test_y for the test set

HW7_3 Ball bearings are hardened through a process known as quenching-submersion of the heated ball bearing in oil or water in order to cool it rapidly. The data below represent the temperature of the ball at various points in the cooling process time (sec) 0 30 Temp (C) 800 457 269 79 46 60 150 240 Plot the data (as discrete points). In the same figure window, also plot a) interpolating polynomial, (use polyfit and polyval) b) piecewise cubic interpolation (not-a-knot) and c) piecewise cubic interpolation (shape-preserving) Include a legend for the three methods used: polynomial interpolation, not-a-knot, shape-preserving. Then looking at the plot, choose the method you believe to be the best and smoothest fit of all these to predict the temperature after 3 minutes of cooling. Print the result using fprintf.

Following screen needs to be design in AWT/Swing. When user click “Add New” button, Record should be entered and displayed in the TextArea shown at top. When user click “Delete” Entered record should be cleared from the TextArea. When user click “Close” button, it will exit the program.

V5. min jee wants to combine the sales data from each of the art fairs. switch to the combined sales worksheet and then update the worksheet as follows. in cell A5 enter a formula without using a function that references cell a5 in the Madison worksheet. copy the formula from cell a5 to the range a6:a8 without copying the formatting. in cell b5, enter a formula using the sum function, 3d references, grouped worksheets that totals the values from cell b:5 in the chicago: madison worksheets.

The Department summary table should look up the department abbreviation and return all of the data listed. It needs to be filled out. To begin, next to the cell listed "Department", use a function to search the staff table data (not including the row of headings and the total row) and return the department name based on the abbreviation above. The formula will be copied, so make sure it always references the abbreviation. Copy the formula down to complete the Department summary table, and edit the copied formulas to return the values from the headings listed in the left-hand column. In the appropriate cell below the staff table, use a function to display the current date without displaying the time. The averages will not be needed, so delete column O. The date for the next update isn't certain, so hide row 18. Switch to the Budget worksheet, which contains the department budgets from 2021 to 2025. There's already a pie chart showing 2021 budget information, and Carmelo wants another…

What is another way to set the core_data data frame besides using the functions read.csv() and file.choose()?

Create a mailing list from the CUSTOMERS table. The mailing list should display the name, address, city, state, and zip code for each customer. Each customer’s name should be listed in order of last name followed by first name, separated with a comma, and have the column header “Name.” The city and state should be listed as one column of output, with the values separated by a comma and the column header “Location.”

The accompanying Gradebook spreadsheet contains a partially completed spreadsheet model for computing and summarizing the grades for a class. Complete the spreadsheet model by entering and copying the formulas in the appropriate cells. Cell range H4:H17 should contain the course number grades using the grades from exams and homework assignments and the grade allocation in row 22. Cell range I4:I17 should contain the course letter grades based on the grading criteria in cell range K4:L8. Rows 19, 20, and 21 should contain the average, maximum, and minimum exam, homework, and course number grades. You should only enter each formula once and copy the formulas to other cells. Gradebook                               Student ID Exam 1 Exam 2 Exam 3 Homework 1 Homework 2 Homework 3 Course Number Grade Course Letter Grade   Grading Criteria 000-01-5562 60 50 40 79 92.0 76       0 F 000-01-2667 80 71 70 84 81.0 90       60 D 000-01-7376 65 65 65 60 90.0 94       70 C 000-01-1986…

Import the pets.csv dataset from your data file into Rstudio. Use the unique function on the pet column to find all the unique pets in the data. Which is the second pet in the resulting output?

The HAVING clause applies to columns and expressions for individual rows, while the WHERE clause is applied to the output of a GROUP BY operation.     True or False ?

LINKS : https://youtu.be/rR_mmsfIzzs Input for games - UWP applications | Microsoft Learn