Help!!!!

[rsanders21]

Objective: Assume you need to quickly run the following analyses (Create a separate pivot table for each exercise on a new worksheet):

Exercise 1: Determine…

— The total number of units shipped from San Francisco to each destination city

Exercise 2: Determine…

— The total number of units shipped from San Francisco to each destination city

— Calculate the average cost, distance and number of units between each city

— Sort cities by unit volume (descending order)

— Create a line graph that would be given to a client to illustrate the data set using this Exercise; add the graph to the same sheet

Exercise 3: Determine…

— The total number of units shipped from San Francisco to each destination city

— Calculate the average cost, distance and number of units between each city

— Sort cities by unit volume (descending order)

— Group the top two cities by unit volume

— Group the three remaining cities by unit volume

— Sort each group by city name in ascending order Origin City Destination City Cost ($/TL) Distance (miles) Units (cases) San Francisco High Springs $ 1,435 958 7,925 San Francisco Redding $ 2,871 2,658 9,000 San Francisco High Springs $ 1,435 958 7,925 San Francisco High Springs $ 1,393 958 3,624 San Francisco Altoona $ 161 48 2,880 San Francisco High Springs $ 1,435 958 7,925 San Francisco Altoona $ 189 48 2,750 San Francisco Jacksonville $ 1,402 880 2,111 San Francisco Sauk Village $ 553 554 1,234 San Francisco Jacksonville $ 1,169 880 1,987 San Francisco Sauk Village $ 550 554 245 Los Angeles Redding $ 2,871 2,658 9,000 Montreal High Springs $ 1,393 958 3,624 Montreal High Springs $ 1,435 958 8,500 Montreal Altoona $ 189 48 2,750 Los Angeles Jacksonville $ 1,169 880 1,987 <colgroup><col><col span="4"></colgroup><tbody> </tbody>

<colgroup><col></colgroup><tbody>
</tbody>

 

[Joe4]

This looks very much like homework.
I think you will find that most members are not willing to do your homework for you.
They may give you some hint to point you in the right direction, like was done on another one of the questions you posted today, but we expect you to try to take those hints and work on it yourself.