business statistics

BUS 105, Semester 2 ,2017 Instructions for the computing assignment worth 20% of your final grade due week 10

*There are 6 sections you must put the answers to all sections into a single document and submit to turnitin. Note that your document must be a Microsoft Word document or pdf. If you use an Apple computer DO NOT SUBMIT A “.PAGES” document save it as a pdf before submitting.

*Note that there are 5 preparation quizzes on moodle that are also due in week 10 , these will help prepare you for the assignment so you should finish them before finishing the assignment.

*Unlike your other assignments , you do not need references you should Just use the examples given in lectures to do sections 1 to 4, For section 5 you should make up the example yourself without using a reference and in section 6 just use the references provided.

The exact instructions for each of the sections is given below

Section 0(Cover page)

“title :bus105 computing assignment semester 2, 2017 ” “Name:” “Student number:” “Allocated sample:”

Section 5

a)You have to obtain your own dataset,

Your dataset must have the following properties. It must be have at least 5 rows (observations) it must have at least 2 variables, (note that the name of each thing in the data set is NOT a variable) At least one of the variables must be categorical

*Make up your own dataset, this can be about anything you find interesting, So it could be about businesses, customers, students athletes, cats, monkeys, AYTHING AT ALL. if you make up your own dataset there is no way it will be the same as another students.

b) Pick two of the variables (make sure one of the variables is categorical) and summarize the variables with a suitable pivot table

c) Paste the dataset and your summary into the word file, you do not need to submit the excel file add a very brief comment

Section 6 If you give a brief discussion (total 300 words) of any of the resources below, or pick two of the resources below or pick all 3, just make sure the total number of words in section 6 is 300 words or less. It is strongly suggested you discuss the examples given in the resources given below 1) Guide to summarizing datasets https://app.box.com/s/jxuqhpzjrfj14xiq28x1bnywjv1iayr4 2) A students assignment from 2015 https://app.box.com/s/2a72e7i9lduyy3wp8nyd0uogsyvvnzrz

3) Discussion of how mean and standard deviation is used in finance https://www.youtube.com/watch?v=UwO4JvB9OpE

General tips

The assignment (and all of bus105) is about datasets

If you are not sure what a dataset is you can look at the pivot table example taken from Wikipedia (Note you have to make up your own example)

https://app.box.com/s/ab7sbnjocfdspgs40xtzqsvoj5tvyoz3

The Wikipedia entry is

https://en.wikipedia.org/wiki/Pivot_table

And if you are unfamiliar with datasets you should try section 6 of the assignment first.