Bus105: Preparation Quizzes- Assessment Answer

IAH126

Statistics Assignment Help:

Task: The exact instructions for each of the 6 sections is given below Section 0(Cover page) “title :bus105 computing assignment semester 2, 2017 ” “Name:” “Student number:” “Allocated sample:” Section 1 Use the dataset given below you must use the sample allocated to you based on your student number https://app.box.com/s/56pb6hqu0ypcg0f3lhy6cl5szt1jgdla Note that for section 1 the answers are provided so you can check your work, the answers will not be provided for the other sections. A) paste in the scatterplot for your sample into your word document and give a simple comment about the relationship between the variables, (you do not need to submit the excel file) B) Estimate the annual contribution if the income is $200,000 using the regression line from part (a) C) Find the zscore of the estimate in part (B) note that average of the estimates is $27,000 with standard deviation $2,100, remember to show your work. D) using the zscore from part (C) Find P(Z<zscore) , you can find out the answer using www.wolframalpha.com for example found the zscore was 1.5 if the zscore is 1.5 type in P(Z<1.5) into wolfram alpha.com E) If there was a list of 10,000 estimates ranked from lowest to highest, what rank do you think your estimate would be close to? Hint: just use the formula expected rank = P(Z<zscore)*10000, remember to show your work. Section 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) D) i) Using your sample what is the estimate for p1- p2? In other words what is the difference between the sample proportions ?" -?# 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