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
82 Total views
Project posted by:


Proposals Reputation Price offered
  • 5.0
    150 Jobs 120 Reviews
    $19 in 12 Hours
  • 4.6
    648 Jobs 468 Reviews
    $20 in 1 Day
  • 4.6
    485 Jobs 295 Reviews
    $20 in 30 Hours
  • 4.4
    84 Jobs 35 Reviews
    $50 in 3 Days
  • 4.9
    2446 Jobs 1195 Reviews
    $30 in 1 Day