In your R script: Monday Tuesday Wednesday Thursday Friday Product1 325 229 189 192 313 Product2 199 148 223 312 312 Product3 244 403 441 217 299 Store the daily sales of three product (given above) in a matrix object. Assign the row names and column names as given in the table above. Compute and print the average sales of each product (row) and average sales of each day (column). Insert the sales on the weekend to the matrix using cbind function. Saturday Sunday Product1 332 465 Product2 298 513 Product3 287 336 Print the sales of Product2 and Product3 on Tuesday, Thursday, and Sunday as a submatrix (Please type answer no write by hend)

In your R script: Monday Tuesday Wednesday Thursday Friday Product1 325 229 189 192 313 Product2 199 148 223 312 312 Product3 244 403 441 217 299 Store the daily sales of three product (given above) in a matrix object. Assign the row names and column names as given in the table above. Compute and print the average sales of each product (row) and average sales of each day (column). Insert the sales on the weekend to the matrix using cbind function. Saturday Sunday Product1 332 465 Product2 298 513 Product3 287 336 Print the sales of Product2 and Product3 on Tuesday, Thursday, and Sunday as a submatrix (Please type answer no write by hend)

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter8: Working With Trendlines, Pivottables, Pivotcharts, And Slicers

Section: Chapter Questions

Problem 8EYW

See similar textbooks

	Monday	Tuesday	Wednesday	Thursday	Friday
Product1	325	229	189	192	313
Product2	199	148	223	312	312
Product3	244	403	441	217	299

	Saturday	Sunday
Product1	332	465
Product2	298	513
Product3	287	336

Similar questions

Write R commands to create a 4 × 4 matrix named m whose elements are complex numbers. The real part of each element is the row number; the imaginary part of each element is the column number. Compute the matrix that results from multiplying each element of m by its conjugate. (Hint: First, find the products of all elements and their conjugates; Second, list all results numbers in a 4 × 4 matrix.)
*In R please How many non-NA and how many NA values are there in the table? Create a new variable ans of class table that gives total number of non-NA as well as NA entries. The first component should be number of non-NA's, the second should be number of NA's. (You should have just one line of a code). New York Air Quality Measurements Description Daily air quality measurements in New York, May to September 1973. Usage airquality Format A data frame with 153 observations on 6 variables. [,1]OzonenumericOzone (ppb)[,2]Solar.RnumericSolar R (lang)[,3]WindnumericWind (mph)[,4]TempnumericTemperature (degrees F)[,5]MonthnumericMonth (1--12)[,6]DaynumericDay of month (1--31) Details Daily readings of the following air quality values for May 1, 1973 (a Tuesday) to September 30, 1973. Ozone: Mean ozone in parts per billion from 1300 to 1500 hours at Roosevelt Island Solar.R: Solar radiation in Langleys in the frequency band 4000–7700 Angstroms from 0800 to 1200 hours at Central Park Wind:…
Please written by computer source const int ROW_SIZE = 10; const int COLUMN_SIZE = 10; int myMatrix[ROW_SIZE][COLUMN_SIZE]; Note that these constants will be in main and not in the scope of any other function. That is, you must design your functions to have parameters to receive the dimensions. Write a function called initialize that receives a 2D array and initializes the array with random values between 0 and 99. Add a message that confirms the successful creation of the matrix. Call this function in main to initialize myMatrix. Write a function called display that receives a 2D array and displays the elements of the array in a tabular format. Arrange the method to display row and column numbers. Row indices displayed on the left and column indices displayed at the top. Call this function in main to print myMatrix. Write a function called sumEven that receives a 2D array and returns the sum of all the even elements. Call this function in main to calculate and display this value for…
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.
If a and b are two non-empty numerical row vectors (of the same length L) present in Matlab Workspace, what command would you use to create a new 2 x L matrix, called d, that is a combination of a and b (a elements are in the first row and elements of b are in the second row)? d = transpose(a, b) d = a _ b d = [a; b] d = a .* (1/b)
Here is my entire code(average is not working yet). The response I got from the professor is that I have to create a DRY solution replacing the five display_functions with a single get_array function you call five times like common_array = get_array(plant_xml, "COMMON") etc. from urllib.request import urlopenfrom xml.etree.ElementTree import parse def read_data(data_file): plant_url = urlopen(data_file) plant_xml = parse(plant_url) return plant_xml def display_common_items(plant_xml): plant_root = plant_xml.getroot() common_array = [] for item in plant_root.findall("PLANT"): common_array.append(item.find("COMMON").text) return common_array def display_botanical_items(plant_xml): plant_root = plant_xml.getroot() botanical_array = [] for item in plant_root.findall("PLANT"): botanical_array.append(item.find("BOTANICAL").text) return botanical_array def display_zone_items(plant_xml): plant_root = plant_xml.getroot() zone_array = []…
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…
please answer all questions You need to generate a (5x12) rain matrix (Rain[5][12]) that contains the average rainfall over 12 months for a 5 year period. You program should do the following steps: 1) Create a 5x12 integer rainfall matrix 2) Create a 5 element array of int pointers(int * Rain[5]) and assign each pointer to the address of the first element of each row 3) Populate the elements of the matrix with pseudo-random numbers having a range from 0-100 inches. Use the rand( ) function to generate your temperatures. The output of rand() should be mod with 100 (rand()%100) in order to get reasonable rainfall values. Init the random number generator with long seed = srand(67) This task should be performed by a function, void RainGen(int* Rain[ ], int R, int C), that populates all the matrix entries. 4) After generating all rainfall matrix entries, print the entire matrix using the function, void Print(int* Rain[ ], int R, int C); 5) Calculate the…
Hello this is in python! Please write this code of merging two images together. Please read the rules. The inputs to your function are: (i) image left: grace\_1.png (size: 350 Rows X 340 Cols), (ii) image right: grace\_2.png (size: 350 Rows X 340 Cols), (iii) image column (c) at which the images should be merged. image_op/operations.py: Edit the function merge Define a new image as follows: the first c columns (default value = 155) should be equal to the first c columns of the left image (grace_1.png). The remaining columns should be equal to the columns greater than c from the right image (grace_2.png). def merge(self, image_left, image_right, column):"""Merge image_left and image_right at column (column)image_left: the input image 1image_right: the input image 2column: column at which the images should be mergedreturns the merged image at column"""# add your code here # Please do not change the structurereturn image_left # Currently the original image is returned, please…
In java program, please find out the total population for United Kingdom with data that store in text file. The program also should able to display how much average new born per day based the dataset for country specify by user.Text file: (actual file have 500 rows and more country)country,date,total_population,new_born, new_deathUnited Kingdom, 2020-02-24, 63475839, 354, 34,Afghanistan, 2020-02-24, 56213485, 524, 29,United Kingdom, 2020-02-24, 63475702, 602, 56,Afghanistan, 2020-02-25, 56213954, 601, 65,
Write a PHP code to: Create the following two dimensional array $students: ID Name Score 100 Ali 76 200 Khaleed 33 300 Fatema 89 400 Sumaya 45 Write the function nbFail($list) that takes a multidimensional array $list as parameter and returns the number of failed students (student fails if the score is less than 50). Write the required PHP code to display the array $students in an HTML table (using foreach statement) and the number of failed students and passed students (use the function defined in question b).
1.)Use the find function and the and & operator to find the indexes of all the values in this vector that are greater than one and less than ten. Put your results in a variable named indexes [3, -4, 0, 1.23, 17, 0, -2, 0] Your solution ought to look something like: indexes = 1 4 2.)Extend the previous question to use the vector of indexes that you found to create a new vector of the values that are greater than one and less than ten. In other words, your answer should be [3, 1.23] but you need to turn in code that identifies these values using the vector of indexes from question 1.