MAKE EXCEL FILE

In the attached Excel File. There are 3 worksheets.

1. Use Inventory worksheet and create Min, Max, Average, Stdev, TotalAnnualStock, AnnualStockBrekdown(Percentages) columns and calculate the values for each product. Draw Bar and Pie charts for AnnualStockBrekdown(Percentages) as we did in the class(50pts)

2. Use HistData worksheet and create a histogram with the number of bins you want to display. (25pts)

3. Use the BoxPlot worksheet and create a Boxplot to see if there are any outliers. (25pts)

Submit your R Files on Canvas. (You can use your own R Studio or UNH R Studio Server)

This is a lighter version of our class exercise so please see the recorded session before you submit your assignment

TEBLE :

PRODUCT JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Product1 250 394 586 606 994 390 426 531 230 331 883 84 Product2 2325 2347 466 1323 2059 2822 836 1545 904 1796 1064 1695 Product3 1800 2014 1869 2035 2344 1818 1601 1663 1750 944 1397 2055 Product4 1826 2741 1490 1607 1077 357 1254 620 1308 1946 194 318 Product5 600 821 1040 447 1002 1153 1457 157 379 384 703 250

TEBLE :

Data 4.6 11.2 7.5 8.3 5.4 7.6 5.4 8.4 5.1 10.8 7.8 9.3 8.3 12.3 10.5 6.2 6.5 4.8 3.9 5.5 7.3 6.7 15.5 7 9.6 3.2 7.1 14.3 5.8 7.6 7.5 11.9 4.3 10.3 10.2 7.5 6.9 10.4 4.9 7 8 2.3 9.3 6 2.2 9 11.9 6.2 6.4 4.1 9.3 5 4 8.8 3.4 9.2 6.9 15 12.7 6 8.4 3.4 3.6 6.9 6 9.2 6.4 10.4 7.3 10.8 7.2 11.3 5.6 7 5.5 11.9 9.8 8.2 6.7 5.1 9.8 5 7.5 6.1 7.4 9.5 4.8 6.6 3.7 9.1 6.3 6.9 5.6 6.6 6.3 6.6 15.3 5 9.3 5.6 5.9 5.7 10.6 3.8 11.5 9.6 3.7 13.8 5 18.9 3.5 10.4 10.5 15 6.8 4.5 6 5.1 7.5 6.4 6.2 3.3 7.2 8.2 9.7 14.6 9.6 11.3 6.2 8.3