Create a pivot table, Strategic Management

One rich seam of experimental data comes from meteorological measurements.  Thousands of measurements are recorded each day by the Australian Bureau of Meteorology (BoM). This assignment requires you to download and process some maximum daytime temperature measurements from the BoM and analyse them to form several pivot tables and charts. Ten Western Australian towns (or airports) are under consideration for this assignment:










9: WYNDHAM AERO (1006)

Note that each town has two numbers associated with it, the first is a digit from 0-9 and the second (bracketted following the name) is a station number which uniquely identifies where the measurements are made.  You must choose three town depending on the final three (unique) digits of your student number.  If your number is 30165285 you must choose 2:Broome, 8:Shark Bay and 5:Geraldton.  If your number is 12347733 you must choose 4:Esperance, 7:Paraburdoo and 3:Christmas Island.

Create a single datalist by pasting together the measurements from the three CSVs. Record how many measurements in total you have available.  Process the station numbers to include the actual names of the stations.

(a)  Create a pivot table which shows the average maximum temperature for the three towns month by month through the year.  Put the months in the rows and the towns in the columns.  Adjust the number of decimal places to some sensible value.  Store your pivot table in a separate worksheet so that you can get your marks recorded.

(b)  Create a new pivot table which shows the maximum of the maximum temperature (ie. The hottest day in each of the months).  Which town has the greatest seasonal variation since the start of 2010?  Store your pivot table in a separate worksheet so that you can get your marks recorded.

(c) Create a pivot table that counts the number of temperature measurements, month by month for each of the three towns that have not been quality approved.  Which town has the greatest number of missings or low quality measurements available?  You will find more information about this in the BoM Note files supplied along with the CSV measurements.

(d) Create a pivot chart showing the standard deviation of the maximum temperature for your three towns.  Put the months in the columns and the towns in the rows.  What does the standard deviation tell you about climatic variations in each of the towns over the course of a year?  For full marks in this part of the question you must be able to draw some conclusions that would not be obvious by inspecting the data set alone.

Posted Date: 3/12/2013 1:23:42 AM | Location : United States

Related Discussions:- Create a pivot table, Assignment Help, Ask Question on Create a pivot table, Get Answer, Expert's Help, Create a pivot table Discussions

Write discussion on Create a pivot table
Your posts are moderated
Related Questions
Identify suitable performance measures for an insurance company to detect false claims and measure the speed of how they are processing claims? Identify suitable non-financial p

Mergers and acquisitions (abbreviated M&A) are both an aspect of corporate strategy, corporate finance and management dealing with the buying, selling, dividing and combining of di

Choose a real life company.  This could be an organization from any industry.  No two students should select the similar company.  It could be the organization you are working in o

Relationship Between A Company's Strategy & Its Business Model 1.   Closely associated to the idea of strategy is the model of a company's business model . CORE CONCEPT:

1 Explain the characteristics of successful business teams 2 Explain the importance of team roles in successful business teams 3 Examine the value of using theoretical models whe

Experienced staff of the organisation contributes in the business expansion of the company. Additionally, the company also provides intensive immersion program for its frontline cr

Division Y has annual operating profit of £40 million after charging £6 million for the development cost of a new product which has been launched and is expected to last this year

need to make a memo to company executives explaining why adequate training is important to the company and how the financial costs can be justified

A Strategic Vision is Differ from a Mission Statement: Whereas the chief concern of a strategic vision is with "where we are going & why", a company's mission statement usua

Question: a) How is knowledge management related to information systems? b) What is the difference between tacit and explicit knowledge? From your own experience, describe