$($Modified from Stasko$)$ The purpose of this assignment is to provide you with practice and experience designing the appearance of data tables and graphs. Below are two Excel spreadsheets. For the first $($quarterly sales data for sales reps$),$ you should create a table that presents its information as clearly and informatively as possible. You may use excel to produce that table, or some other program. The output $($and your submission$)$ should be a $.$pdf file.

For the second $($performance of different departments in the company$),$ design a graph that presents the information as clearly and informatively as possible. YOU MUST PRODUCE THIS GRAPH USING R $($or R Studio$).$

Think about the data in each spreadsheet and what an analyst looking at that data would care about. You are allowed to derive new variables $($attributes$)$ that are combinatidns of the given ones, but you cannot make up totally new variables and values.

You should simply turn in the pdf for the table and a knitted HTML file $($not your $.$R or $.$Rmd script file$)$ for the graph.

Additionally, ON this assignment page use the text box. Submit some text where you $($in a paragraph or two$)$ reflect upon this assignment. What did you learn? Where did you struggle? What surprised you?

Grading: Make sure to submit $1$ table $($sales info, pdf$)$ and $1$ graph $($in a knitted html file$).$ We will evaluate the effectiveness and design aspects of your creations. Of course this is subjective, but we will look for tables and graphs that apply the design recommendations discussed in class and in our readings. Do not submit an unedited replica of the scaffolding provided for the department graph, this will result in a reduction of grade.

a$2-$DeptYearlyPerf.xls

November $202023,12$:$01$ PM

a$2-$SalesRepPerf.xls

November $202023,12$:$01$ PM