Question: This is full the line Matlab... pls solve it carefully... Name: CTID (903xxxxxx, etc.): 5. Complete the fillin the blank code. (20l points) code that

 This is full the line Matlab... pls solve it carefully... Name:

This is full the line Matlab... pls solve it carefully...

Name: CTID (903xxxxxx, etc.): 5. Complete the fillin the blank code. (20l points) code that reads in a spreadsheet about theatres and updates it. Follow the Fill in the following comments to knoww an Excel file (ending at the code should do. The first input of the function will be the name of in 'xlsx'), which needs to be sorted by the name of the column in the wh n ns tog in ascending order). For the samse column, delete the rows whose entries are less find the Premiere Movie (guarameed to be in column 3) of the top than the third input. Then heatre. Make as through 6. w column called Average Price' that finds the average price of the movies the average price Guaranteed .The first row is headers .Columns4 throagh 6 contain the prices of entrees .Premiere Movie will always be the third column The columm specified by the secord imput will contain all doubles Any columns not mentioned may be in any order Example: 'Premier Theaters' Novie Rating Carmike Regal ???" Juman Inception Bee Novie 8.99 novie -rottenTomatoes 'theaters.xlsx,'Movie Rating,3 movie Bee Movie ove ovie 'Novie Aage Regal' Inception' 4 Name GTID (903xXxXxx, ete-) 1 function dishrottenTomatoesifilenane, category, val) 3 headers rawl 4 % find the position of the colunn stored in the variable category 6 column rawis,mask s sort the colunn of nunbera extracted by the naak 8 [serted, ind) 10 mask2 - sorted val; 11 % delete the row8 that are less than val 12 13 s extract the colunns that have prices 14 prices -cel12mat 15 arg nean prices, 21i 16% ake ? neu column where each row i& the avara 17 header Average Price of the prices wi 29% Jpperd your nou co lunn to tha array 20 raw 21 extract the premiere novie 22 movid 23% write to file ending with-sorte of the top theater rankea by cat egory 25

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!