Goal: The goal of this assignment is to revisit our Coffee Chain data for further exploratory analysis using Maps, Histograms and Box Plots The Data: Same as before - the Coffee Chain Data Coffee Chain Data-1.twbx We are going to particularly focus on coffee chain profits by State and by Market. We will create a series of maps, histograms and box plots to study this. I have created some of them as examples. Create one visualization per worksheet. You can use captions to make any comments on each visualization (Worksheet >show caption. Double click to edit) 1) Our first question is - how do profits vary geographically by State? Create a choropleth map showing Profit by State. 2) How do profits vary by Market? Create a choropleth map of Profit by Market. Since Market is coded as a string, you will need to assign a geographic role to Market. Click on the arrow next to Market in the data pane, assign a geographic role to Market, created from state, since states are combined to form markets. 3) Now, we want to see how things would change if we redefine our markets. So, we are going to experiment with our own definitions of Market by creating custom territories. To do this, create a map of profit by state first. Then multiselect the state you want in your own market (custom or command click all the states) and group them by clicking on the paperclip icon. You should have a new variable State(group). Edit this to rename your new markets etc. Here are my Custom Territories, you can create your own territories. I felt that Florida should be grouped with the South for example. 4) Next we are going to examine the distribution of profit by histogram. What is the range of transactions that is most frequent in our transactions? Create a histogram of profit. Change the bin size to 50 (as in video 2). Also create a parameter with minimum bin size 50 and a step size of ten and show the parameter (as in video 2). Then use the slider to see how many bins you prefer! 5) More with histograms: In the histogram, there appears to be an outlying bin on the very left. Right click on that bin and select "View Data". In the window that pops up, select "Full Data" at the bottom. Where are these outliers - which state and market? Insert a caption in that sheet and answer this question. (Worksheet Menu > Show Caption > Double click on caption to edit) 6) Create a box plot showing profit by Market and Product (multiselect the three and go to Show Me). What's going on with Green Tea? Are there any outliers? Which market has the highest median profit? Which market has the biggest spread in profits? 7) The above box plot was aggregated by Product and State. Let's try to create a disaggregated boxplot - one dot for each sale (each row). In your new sheet, go to Analysis and uncheck Aggregate Measures. Then select profit and create a boxplot. What is the problem with this box plot? The Coffee Chain data has about 51,000 rows of sales!! 8) We will solve the problem of overlapping points in a disaggregated plot by adding Jitter to the Box Plot. Jitter does not change the content of the plot, it just uses a random number to jitter the dots so there is not as much overlap. We will use the random jitter method suggested by Jeff Shaffer in this website https://www.dataplusscience.com/TableauJitter.html It has only two steps 1. Create a calculated field called Jitter (Analysis > create Calculated field) 2. Enter random( ) in the calculated field. Then place this Jitter calculated field (now under measures in the data pane) in the columns shelf. You can also use a different method to create jitter - instead of random () you can use index (). If you like, you can examine the differences in the two jitter plots. 8) Create any chart or charts of your choice to examine profit by Market or State using any other variable as well (like a Date or another measure for example). Experiment!! I have provided links and all files for this assignment!! Thank you
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
