business statistics
student567
Section2and3.docxSection 2 Use the dataset given below you must use the sample allocated to you based on your student number
https://app.box.com/s/yvhk3e3oymbs3toy6j5xetid82dsjyz4
A) Use the PivotTable feature in excel to find appropriate summary statistics for your sample, This will probably require two PivotTables. You should paste both into word, you do not need the excel file.
Make sure the pivotable (or pivottables) include the following statistics
*Just considering the high risk (riskier type) investments what is the sample size n1 and the proportion of high risk investments that made a loss
*Just considering the low risk (safer type) investments what is the sample size =n2 and What is the proportion of low risk investments that made a loss
B) Use excel to make an appropriate graph that lets you compare the proportions found in parts A and paste this into your word document
C) Looking at your answers to parts (A) and (B) Make a simple comment about the relationship between the variables investment type (risky or safe ) and Made a profit (made a profit/made a loss)
ii) Find the zscore of the estimate in part (i) note that average of the estimates is 0.1 with standard deviation 0.0743
iii) using part (ii) find P(Z<zscore) using www.wolframalpha.com for example if the zscore is 0.5 type in P(Z<0.5)” into wolframalpha.com
iv) IF there was a list of 4000 estimates ranked from lowest to highest, roughly what rank do you expect your estimate to have? Hint: just use the formula expected rank = P(Z<zscore)*4000 E) test the claim there is a difference in the proportions use a 5% level of significance
i)state an appropriate H0 and H1
ii) find the p-value Only using the answers to part (A) and the webpage http://epitools.ausvet.com.au/content.php?page=z-test-2
Do NOT use any other method to find the p-value Do NOT use any other software package such as SPSS or Analysis tookpak
iii) state whether or not you reject the H0
iv) give a conclusion in plain English
Section 3 Use the dataset given below you must use your own sample
https://app.box.com/s/z0mbtcfsdqxz1rm7rhw3p9sb75aq7174
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 n1 , the sample average return of low risk investments , and the sample standard deviation s1 Just considering the high risk investments , what is the sample size n2 , the sample average return of high risk investments , 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 µ1- µ2? In other words what is the difference between the sample means -
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<zscore), you can find out the answer using www.wolframalpha.com for example if the zscore =-1 type in P(Z<-1) into wolfram alpha
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<zscore)*2000
E) Test the claim that there is a difference between the means using a 5% level of significance
i)state an appropriate H0 and H1
ii) find the p-value using the answers to part (A))and the webpage https://www.medcalc.org/calc/comparison_of_means.php
Do NOT find the p-value using any other method. Do NOT use any other software package such as SPSS or Analysis tookpak
iii) state whether or not you reject H0
iv) give a conclusion in plain English
