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
Completed
Total Proposals: 5
1 Current viewersl
51 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 5.0
    147 Jobs 118 Reviews
    $19 in 12 Hours
  • 4.6
    647 Jobs 468 Reviews
    $20 in 1 Day
  • 4.5
    355 Jobs 236 Reviews
    $20 in 30 Hours
  • 4.4
    84 Jobs 35 Reviews
    $50 in 3 Days
  • 4.9
    1183 Jobs 609 Reviews
    $30 in 1 Day