excel problems

Project Description:

please do the following problems on pivot tables individually.
(1) for the grocery example (from your in-class activities):

(a) prepare a chart that summarizes the trend over time of the sales at each store.

(b) create a calculate field that computes an average per unit price received for each product.

(c) create a pivotchart that summarizes the sales of each product at each store for years 2005 and 2006

(2) download the “smoking and cancer” data from http://lib.stat.cmu.edu/dasl/datafiles/cigcancerdat.html. the data contains data on number of cigarettes smoked and the type of cancer by states. what can you conclude about the region, number of cigarettes smoked and type of cancer?

(3) download the wages and hours data from http://lib.stat.cmu.edu/dasl/datafiles/wagesdat.html. what can you conclude about the factors affecting the average hourly wage?

(4) in the chip pivottable example used in class, create a pivottable that summarizes monthly sales of chips 1 and 3 in france and the united states.
Skills Required:
Project Stats:

Price Type: Fixed

Project Budget: $0 to $10
Total Proposals: 5
1 Current viewersl
76 Total views
Project posted by:


Proposals Reputation Price offered
  • 5.0
    149 Jobs 119 Reviews
    $19 in 12 Hours
  • 4.6
    648 Jobs 468 Reviews
    $20 in 1 Day
  • 4.6
    472 Jobs 285 Reviews
    $20 in 30 Hours
  • 4.4
    84 Jobs 35 Reviews
    $50 in 3 Days
  • 4.9
    2290 Jobs 1125 Reviews
    $30 in 1 Day