Question: You can think this as a term-document matrix, where each number indicate the term frequency (TF) of a term (column) in a document (row). Given

You can think this as a term-document matrix, where each number indicate the term frequency (TF) of a term (column) in a document (row).

Given this collection of 5 documents, your need to use proper Excel formula to calculate document frequency (DF) and TF-IDF.

Hint:

For cells in Row 11, you can use the COUNTIF() function.
For cells in Rows 14-18, make good use of relative and absolute cell references when creating your formula.

Rug LCIS Long SCUISICIVIL B11 fax 0 A B D E F G H 1 K L M N o P Q R s T U V w Y Z 1 1 2 Term Frequency (TF) Victarion Tyrion Lan Theon Gre Sansa Star Samwell 1 Quentyn I Melisandr Jon Snow Jon Conni Jaime Lan Eddard St Davos Sea Daenerys Cersei Lar Catelyn Tu Brienne o Bran Stark Barristan Asha Grey Arys Oakh Arya Stark Arianne M Areo Hota Aeron Greyjoy 3 A Game of Thrones 0 9 0 6 0 0 0 9 0 0 15 0 10 0 11 0 7 0 0 0 5 0 0 0 4 A Clash of Kings 0 15 6 8 0 0 0 8 0 0 0 3 5 0 7 0 7 0 0 0 10 0 0 0 5 A Storm of Swords 0 11 0 7 5 0 0 12 0 9 0 6 6 0 7 0 4 0 0 0 13 0 0 0 6 A Feast for Crows 2 0 0 3 5 0 0 0 0 7 0 0 0 10 0 8 0 0 1 1 3 2 1 2 7 A Dance with Dragons 2 12 7 0 0 4 1 13 2 1 0 4 10 2 0 0 3 4 3 0 2 0 1 8 8 9 # of documents (N) 5 10 11 Document Frequency (DF) 12 13 TF.IDF Victarion Tyrion Lar Theon Gre Sansa Star Samwell 1 Quentyn Melisandr Jon Snow Jon Conni Jaime Lan Eddard St Davos Sea Daenerys Cersei Lar Catelyn Tu Brienne o Bran Stark Barristan: Asha Grey Arys Oakh Arya Stark Arianne M Areo Hota Aeron Greyjoy 14 A Game of Thrones 15 A Clash of Kings 16 A Storm of Swords 17 A Feast for Crows 18 A Dance with Dragons 19 20 21 Rug LCIS Long SCUISICIVIL B11 fax 0 A B D E F G H 1 K L M N o P Q R s T U V w Y Z 1 1 2 Term Frequency (TF) Victarion Tyrion Lan Theon Gre Sansa Star Samwell 1 Quentyn I Melisandr Jon Snow Jon Conni Jaime Lan Eddard St Davos Sea Daenerys Cersei Lar Catelyn Tu Brienne o Bran Stark Barristan Asha Grey Arys Oakh Arya Stark Arianne M Areo Hota Aeron Greyjoy 3 A Game of Thrones 0 9 0 6 0 0 0 9 0 0 15 0 10 0 11 0 7 0 0 0 5 0 0 0 4 A Clash of Kings 0 15 6 8 0 0 0 8 0 0 0 3 5 0 7 0 7 0 0 0 10 0 0 0 5 A Storm of Swords 0 11 0 7 5 0 0 12 0 9 0 6 6 0 7 0 4 0 0 0 13 0 0 0 6 A Feast for Crows 2 0 0 3 5 0 0 0 0 7 0 0 0 10 0 8 0 0 1 1 3 2 1 2 7 A Dance with Dragons 2 12 7 0 0 4 1 13 2 1 0 4 10 2 0 0 3 4 3 0 2 0 1 8 8 9 # of documents (N) 5 10 11 Document Frequency (DF) 12 13 TF.IDF Victarion Tyrion Lar Theon Gre Sansa Star Samwell 1 Quentyn Melisandr Jon Snow Jon Conni Jaime Lan Eddard St Davos Sea Daenerys Cersei Lar Catelyn Tu Brienne o Bran Stark Barristan: Asha Grey Arys Oakh Arya Stark Arianne M Areo Hota Aeron Greyjoy 14 A Game of Thrones 15 A Clash of Kings 16 A Storm of Swords 17 A Feast for Crows 18 A Dance with Dragons 19 20 21

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 General Management Questions!

what would the formulas be for row 9,11 and 14 - 18 row 9 is # of docs n 11 is df 14-18 is tf.idf In the Excel file we have a table showing the occurrences of POV characters across George R. R....

Text mining Weighting scheme for Documents (tf-idf)--------- Please write Program in perl . The similarity of documents with the use various measures (i.e. cosine etc) is an important issue in Text...

How would i do this where each number indicates the term frequency (TF) of a term (column) in a document (row). Given this collection of 5 documents, your need to use proper Excel formula to...

Create a function to process a document in the following steps: 1) Tokenize the words using NLTK 2) Use the Porter stemmer 3) Counts the term frequency tf for each item 4) calculates the weighting...

Python Assignment. Function to analyze Numpy Array: Assume we have an array which contains term frequency of each document. Where each row is a document, each column is a word, and the value denotes...

think about what procedural changes would have the biggest positive impact, without being excessively costly for our lab members at every level (including undergrads!). Reference: the Lab Data Check...

alldocuments = [] iterate the directories for each file open the file and use readlines() to read all lines fetch the lines related to "Subject" and the body started with "Lines: number" put all...

Rev.Confirming Pages C H A P T E R 7 Planning, Composing, and Revising Chapter Outline The Ways Good Writers Write Activities in the Composing Process Using Your Time Effectively Brainstorming,...

Instructions for submission One of the topics covered in Analysis of Algorithms are algorithms for traversing graphs. The structure of the world-wide-web is an example of a directed graph with each...

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

Explain the difference between a dependent and an independent variable.

1) Both A and R are true and R is the correct If f: [-6, 6]R is defined by f(x)=x - 3 explanation of A 2) Both A and R are true but R is not correct 1. explanation of A 3) A is true but R is flase 4)...

Problem 2 - 6 1 ( LO 2 - 2 , LO 2 - 3 ) ( Algo ) Chaz Corporation has taxable income in 2 0 2 4 of $ 1 , 3 1 2 , 3 0 0 for purposes of computing the $ 1 7 9 expense and acquired the following assets...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...