This is an individual assignment. Please download the dataset $($Week$-1-$Homework.xlsx$)$ and do the following work:

$1)$ Use $$New Drug$$ data $($Hint: Please copy and paste the data on worksheet $$New Drug$$ and create a text file or CSV file. Then, import$/$read the data from the file into R$.)$

a$.$ Use R to create a histogram for Age.

b$.$ Use R to show the mean, median, mode, standard deviation, min, and max for $$Before$\_$exp$\_$BP$$ and $$After$\_$exp$\_$BP$,$ respectively.

c$.$ Use R to create a Box$-$Plot for $$Before$\_$exp$\_$BP$$ and $$After$\_$exp$\_$BP$,$ respectively.

d$.$ Use R to create a stem$-$and$-$leaf for Age. Which one do you like, histogram or stem$-$and$-$leaf?

$2)$ Use $$MS Stock$$ and $$PNC Stock$$ worksheets.

a$.$ Use Excel or R to create a scatter plot for MS Open Price and PNC Open Price $($Hint: you firstly need to copy both variables to one new worksheet, then start to work on a scatter plot$).$ What kind of relationship between MS Open Price and PNC Open Price can be observed? $($Hint: One diagram has two variables, $$MS Open Price$$ and $$PNC Open Price$.$ One for X axis, and the other one for Y axis.$)$

b$.$ Use Excel or R to create a combination chart for MS Open Price and PNC Open Price. Briefly explain your observation. $($Hint: Use different styles for two variables. For example, one is line, the other is bar. $)$

c$.$ Use Excel to create sparkelines for Open, High, Low, Close, and Volume for MS Stock worksheet. Which one shows more volatile? $($Hint: Create sparkline for each column, NOT row.$)$

$3)$ Use Excel or R to create a heat map for Sales worksheet. Briefly explain the heat map. $($Hint: Excel is recommended.$)$

$4)$ Please replace $$your name$$ with your true full name in Tree Map worksheet. Then, use Excel or R to create a tree map for this worksheet. Are you satisfied with your sales performance? Why, or Why not? $($Hint: Excel is recommended.$)$

Please answer each question, and copy your work from R or$/$and Excel in one word file. After each question, please put your response directly. By the end of word file, please copy and paste your R script. You need to submit the excel file with data visualization as well.

In sum, you need to submit One word file and One excel file.

Please copy and paste your R scripts below.