[Solved]Function Name Hahayes Inputs 1 Char Filename Excel File Containing Word Counts Various Wor Q37118259
***USE MATLAB ONLY***
Function Name: hahaYes Inputs 1. (char) The filename of an Excel file containing word counts from various works 2. (cell) A 2xN cell array of words and how many times they occur in the unknown work Outputs: 1. (cell) A 1×3 vector of the closest matches to the unknown work Background You do not understand this reference Function Description The Excel file that you are given contains data on how many times certain words appear in different works (these might be speeches, episodes of TV shows, books, etc.). Each column of the spreadsheet will represent a different word, which are listed in the first row. Each row will represent a different work, which are listed in the first column. You are also given a cell array containing a few words and how many times they appear in an unknown work The goal is to find the works in the Excel sheet that most closely match the data you have in the input cell array. To do this, find the absolute error between the number of times the word appeared in the unknown work and the known works in the Excel sheet. The absolute error is then: abs(«unknown > – <known>). Once you have found the absolute error over every word in the second input, find the 3 works with the lowest absolute error, and output the names of those works in a 3×1 cell array, in order of their error rankings (the closest match should be listed first in the output) Example: hahaYesExample.xlsx Work Island S1ay Redemption Survivor Drag Race World of Dance e out-hahaYes (‘hahaYesExample.xlsx’, ‘Island’, 14; ‘Redemption’, 5) 18 1 23 1 15 >> out = {‘Survivor’s ‘World of Dance’s ‘Drag Race’) Notes: The Excel file will contain at least 3 works, and is guaranteed to have a column for each word in the input cell array . Show transcribed image text Function Name: hahaYes Inputs 1. (char) The filename of an Excel file containing word counts from various works 2. (cell) A 2xN cell array of words and how many times they occur in the unknown work Outputs: 1. (cell) A 1×3 vector of the closest matches to the unknown work Background You do not understand this reference Function Description The Excel file that you are given contains data on how many times certain words appear in different works (these might be speeches, episodes of TV shows, books, etc.). Each column of the spreadsheet will represent a different word, which are listed in the first row. Each row will represent a different work, which are listed in the first column. You are also given a cell array containing a few words and how many times they appear in an unknown work The goal is to find the works in the Excel sheet that most closely match the data you have in the input cell array. To do this, find the absolute error between the number of times the word appeared in the unknown work and the known works in the Excel sheet. The absolute error is then: abs(«unknown > – ). Once you have found the absolute error over every word in the second input, find the 3 works with the lowest absolute error, and output the names of those works in a 3×1 cell array, in order of their error rankings (the closest match should be listed first in the output) Example: hahaYesExample.xlsx Work Island S1ay Redemption Survivor Drag Race World of Dance e out-hahaYes (‘hahaYesExample.xlsx’, ‘Island’, 14; ‘Redemption’, 5) 18 1 23 1 15 >> out = {‘Survivor’s ‘World of Dance’s ‘Drag Race’) Notes: The Excel file will contain at least 3 works, and is guaranteed to have a column for each word in the input cell array .
Expert Answer
Answer to Function Name: hahaYes Inputs 1. (char) The filename of an Excel file containing word counts from various works 2. (cell… . . .
OR
