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)
Section 3
Use the dataset given below you must use your own sample
A) Use the pivot table feature in excel to find appropriate summary statistics for your sample. The following sample statistics must be found
Just considering the low risk investments, what is the sample size nl, the sample average return of low risk investments z2, and the sample standard deviation si
Just considering the high risk investments , what is the sample size n2, the sample average return of high risk investments -x2 , and the sample standard deviation s2
Paste the pivot table into the word document you do not need to submit the excel file
B) Give an appropriate graph that shows the relationship between variables, Note that the information in part A is NOT Suitable for a graph you have to get different information
C) Make a simple comment about the relationship between the variables using the answers to (A) and (B)
D)
i) Using your sample what is the estimate for M'- 1.12? In other words what is the difference between the sample means 7x/--x2
ii) Find the zscore of the estimate in part (i) note that average of the estimates -0.0256 with standard deviation 0.0173
iii) using part (ii) What is P(Z
iv) If there was a list of 2000 estimates ranked from lowest to highest, what rank do you think your would be close to, hint just use the formula expected rank = P(Z
Option 3
Find an existing dataset and make up an extra variable email the lecturer the dataset the lecturer will email you a sample of the data set, use the sample , this will make sure there is no way your sample is the same as other 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 4
Use the dataset given below you must use your own sample
Suppose A business has conducted an opinion poll to find out if their customers support a change to the Business
a) Use the PivotTable feature in excel to find appropriate summary statistics for your sample,. You should paste both into word, you do not need the excel file.
This pivot table must have the number of people that answer yes and the number of people that answer no
b) What is sample size and the sample proportion Ap of people that support the change, Note that II is the estimate for the population proportion p
c) i) Find the zscore of the estimate in part (a) note that average of the estimates 0.6 is with standard deviation 0.0357
ii) using part (i) what is P(Zczscore) you can find out the answer
For example if the zscore is 2 then enter P(Z<2)
iv) If there was a list of 1000 estimates ranked from lowest to highest, what rank do you think your would be close to, hint just use the formula expected rank = P(Z
d) Find a 95% confidence interval for the proportion of people that support the change
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
There are 3 options for getting the dataset Option 1
*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.
Option 2
Find and existing data set and email the lecturer the dataset the lecturer will email you a sample of the data set, use the sample , this will make sure there is no way your sample is the same as other students.
Option 3
*find an existing dataset and make up an extra variable email the lecturer the dataset
the lecturer will email you a sample of the data set, use the sample , this will make sure there is no way your sample is the same as other 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
2) A students assignment from 2015
3) Discussion of how mean and standard deviation is used in finance
Attachment:- Screenshot_2017.rar