Dataset, Database Management System

Assignment Help:

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.


Related Discussions:- Dataset

Participation constraints, The participation Constraints shows whether the ...

The participation Constraints shows whether the existence of an entity depends on its being associated to another entity by the relationship type. There are two kinds of participat

Datawarehouse Case studies, I have been given 8 differebt data warehouseing...

I have been given 8 differebt data warehouseing failure case studies. I need to question 4 questions for each

Erd, er diagram on cosmetics.

er diagram on cosmetics.

What is meant by heuristic optimisation, What is meant by heuristic optimis...

What is meant by heuristic optimisation?Discuss the major heuristics that are applied during query optimisation.

Provide examples of different types of time and date formats, Provide Examp...

Provide Examples of different types of Time and Date formats.  It's most common store dates using a dash (-) as a colon (:)and the delimiter as the time delimiter. The given fo

Define a table in sql known as client for store information, Define a table...

Define a table in SQL known as Client that is used to store information about the clients. Define CLIENT_NO as the primary key whose first letter must begin with ‘C'. Also ensure t

Which is a valid sql type, Which is a valid SQL type? A valid SQL Shoul...

Which is a valid SQL type? A valid SQL Should be in CHARACTER it is should be NUMERIC and FLOAT.

Backward recovery (undo), Backward Recovery (UNDO): In this system the unco...

Backward Recovery (UNDO): In this system the uncommitted changes made by a transaction to a database are undone.  Instead the system is reset to the last consistent state of databa

Draw an e_r model in oracle, Draw an E_R Model for the following: An or...

Draw an E_R Model for the following: An organization uses number of items of a equipment to generates goods. Each item is at one LOCATION, of one TYPE and has a DETAILED_DISCRI

What is first normal form, What is first normal form? The domain of att...

What is first normal form? The domain of attribute must contain only atomic (simple, indivisible) values.

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd