Dataset, Database Management System

The dataset "CFOLYMPICS.XLS" contains the observations used in the above article.  The definitions of the variables are also included in this spreadsheet.  However, for the purposes of this exercise the data will be 'modified' as explained below, so you should not rely on any results that are given in the source text or of other students.

36_Dataset.png

Take a copy of the dataset from Blackboard.  In order that each student works with a slightly different dataset the following procedure should be applied to create data in columns H and I.

(a)   From the main menu select Tools > Data Analysis > Random Number Generation and click OK.  Complete the option window as adjacent, i.e.

(b)   Select 'Bernouilli' from the Distribution drop-down list

(c)    Select a p-value equal to 0.08

(d)   Set the output range in the usual way to the values shown: but....

(e)   In the Random Seed box enter the last 4 digits of your Student Number (omitting any leading zeros i.e. 0123 becomes 123) as it will appear on the cover sheet you will submit (see end of this document).  It is important that these two values match.

(f)     Click on OK to return to the spreadsheet.

(g)   In the spreadsheet cell I2 enter the cell formula:-

=3*E2+2*F2+1*G2+1+H2

and drag it down the I column.  In this exercise we are going to work with the concept of winning 'points' awarding 3 for gold, 2 for silver, 1 for bronze and an extra 1 for having a team present.  The last component awards an extra point randomly to some of the year/country results.

The implications of this procedure are that each student will be working with a slightly different dataset.  In consequence it may prove perfectly legitimate for you to reach a conclusion about any of the following questions which differ from those reached by other students.  This should not preclude you however from discussing the method of the analyses you carry out with other students or me.  Indeed I would encourage such discussions since you will thereby get practice in using the jargon of our subject.  This exercise will use the measure of 'points' for Olympic success in comparison to 'medals' in the cited article.

For each of the following questions make a copy of the initial data as required and place on a new clean sheet.  This should be done by using 'Paste Special' and selecting the 'Values' option so that no cell formulae are compromised by the copy process.

Posted Date: 2/22/2013 6:30:46 AM | Location : United States







Related Discussions:- Dataset, Assignment Help, Ask Question on Dataset, Get Answer, Expert's Help, Dataset Discussions

Write discussion on Dataset
Your posts are moderated
Related Questions
design a generalization specialization hierarchy for a motor vehicle sales company. the company sells motorcycles, passenger cars, vens and buses.

Define the concept of generalization A generalization is relationship between specific kind of thing and general thing. It is also known as "is-a-kind-of" relationship. Inher

Rearrange Classes and Operations Sometimes, the similar operation is defined across different classes and can easily be inherited from a familiar ancestor, but more often oper

I need to Map an E-R diagram to a relational schema

Explain the Difference between DROP and DELETE DELETE deletes one or more than one tuples of a particular relation from the database. DROP is employed to remove a table from th

What are wait-for-graphs?Give the algorithm to construct a wait-for-graph from a given schedule of transactions? How can deadlocks be detected from wait-for-graphs?   Ans:  The

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

What is Candidate Key Super Key or Candidate Key: It is such an attribute of a table that can uniquely recognize a row in a table. Generally they have unique values and can n

Define the basic operations of the relational algebra?     Ans: Basic operators of relational algebra are: 1. Union (∪) - Selects tuples which are in either P or Q or in bot

Database Manager It is the interface among low-level data, queries and application programs. Databases typically need a large amount of storage space. It is kept on disks, as