Introduction

Introduction

In lecture, you have seen six functions used so far: SUM, SUMIFS, AVERAGE, AVERAGEIFS, COUNT, and COUNTIFS. For this MP, you will use those six functions, along with basic addition (+), subtraction (-), multiplication (*), and/or division (/) to answer fifteen quesitons about a new data set.

The data for this MP comes from reddit.com, which Wikipedia describes as an entertainment, social networking and news website where registered community members can submit content, such as text posts or direct links. The UIUC community on reddit is the largest University-based community on all of reddit (found at /r/uiuc).

reddit is similar to Yik Yak, some newer message boards, and other Internet forums where users can either up vote or down vote a post. Each up vote adds one to the score of a post while each down vote subtracts one from the score of the post. The data set in MP4 contains over 2,800 individual reddit posts with information about the topic of the post, the total score, the number of up votes, the number of down votes, and other related information.

Download The MP

Similar to previous MPs, this MP starts with a base set of files that can be downloaded here.

Important Details

Requirements

You will find fifteen questions about the data set all within the Excel file you just downloaded. When completing this MP, ensure that:

• Your answers must appear in G10:G24. This means you must not add any rows or columns that might move the location of those cells.
• When an input field is specified in Column F, it must be used as part of the formula such that changing the value in Column F will update the answer in Column G. (G10, G12, G13, G15, G17, G20, G23, and G24.)
  • As an example, F10 initially contains "_Ahri_". As a username, "_Ahri" appears only once. Therefore G10's formula should yield 1.
  • If you change F10 to "cs105", which is not contained in the data at all, G10 should automatically update from 1 to 0.
• Your file must be an Excel .xlsx file. If we are unable to open your file using Excel, you file will not be graded and you will not earn any points. If you are not sure, you should double check that your file opens on a CITES ITS computer before submitting.

Submission and Grading

Your Excel file must open with Excel to receive any credit at all. We will award points for your program completing the following:

• 2 x 15pts, 2 points for each question

Submit MP4 here