1. The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing the store identification number, sales region, item number, item description, unit price, units sold, and month when the sales were made during the fourth quarter of 2011. Please use the attached worksheet to answer the following questions:
a. Use the COUNTIF function to construct a frequency distribution of the item description.
b. Use the Histogram tool to construct the frequency distribution, relative frequency, and the cumulative relative frequency of the units sold .
c. Construct cross-tabulation of Region, item description, and total revenue per item. Note that revenue is unit price times unit sold. The total revenue per item is the sum of all the revenues of that item.
2. Create the line chart for the closing prices in the Excel file S & P 500.
3. Create the pie chart showing the breakdown of occupations in the Science and Engineering Jobs Excel file.
4. Construct an appropriate chart to show the proportion of funds in each investment category in the Excel file Retirement Portfolio.
Please attach your excel worksheet(s).