Notes:
First, please re-save this document on your computer, RENAMING the file to contain your last names (e.g.students Sachar & Lemberg would name their document as Tempate_1_Sachar_Lemberg.)
Type or paste your responses into the boxes below. The boxes will expand to fit your answers.
In this assignment you will use web.csv file to create visualizations using ggplot2 in RStudio. You will develop five thoughtful business questions by putting yourself in decision makers shoes and then develop appropriate visualization to obtain insights that address questions raised. For answering each business question, you will develop three competing visualizations (total visualizations for the assignment will be 15). Creativity and thoughtfulness is important when choosing appropriate visualization. Note that, when choosing visualization style, emphasis should be more on usefulness. And then provide plus and minus points for each (article by Wickham and video by Cairo may be helpful here). Finally, provide summarized insights obtained from these visualizations.
Data Dictionary
Columns in our Excel Brandeis Web Traffic file (some are common or self-explanatory):
Focus (Academic Interests, Admissions, or Student Affairs web pages)
Country (US only selected for this dataset)
City
State
Country
Previous Pagepath: URL of page visited just before current page, or [entrance] if user typed in current URL directly
Pagepath
Pagetitle
Datehour (format is YYYYMMDDHH. e.g. 2012112615 is Nov 26, 2012 at 15:00, or 3:00 pm)
Entrances – number of times user entered the page
Visitors – number of different visitors visiting the page from that city, state during the hour
Newvisits – number of new visits during the hour from that city, state
Uniquepageviews
Pageviews
Avgtimeonpage (in seconds)
1.Business question-1 (18 points)
Business question:
how much time people are spending on a specific page
2.Business question-2 (18 points)
Business question:
Which country has the highest number of users entering a website.
3.Business question-3 (18 points)
Business question:
compare Average time on page and Number of users
compare Average time on page and Number of users by the help of a histogram. Take Average time on page on X Axis and Number of Users on Y Axis.
4.Business question-4 (18 points)
Business question:
Is there any relationship between page views and unique page views?
show the average time on page (in seconds) people are spending and in which country they are logging in from.
5.Business question-5 (18 points)
Business question:
Is there any relationship between page views and unique page views?