# BUS105 Business Statistics Computing Assignment

15 Pages2448 Words75 Views

bus105 Business Statistics - Computing Assignment (bus105)

## BUS105 Business Statistics Computing Assignment

bus105 Business Statistics - Computing Assignment (bus105)

BookmarkShareRelated Documents
Title: bus105 computing assignment semester 2, 2017 Name:Student number:Allocated sample: 116
Section 1Use the dataset given below you must use the sample allocated to you based on your studentnumberhttps://app.box.com/s/56pb6hqu0ypcg0f3lhy6cl5szt1jgdlaNote that for section 1 the answers are provided so you can check your work, the answerswill not be provided for the other sections. A)paste in the scatterplot for your sample into your word document and give a simplecomment about the relationship between the variables, (you do not need to submit theexcel file) SolutionB)Estimate the annual contribution if the income is \$200,000 using the regression linefrom part (a) SolutionRegression equation is;y=0.1379x1668.2With an income of \$200,000 we have annual contribution s;y=0.1379(200000)1668.2y=\$25911.8Thus the estimated annual contribution is \$25911.8C)Find the z-score 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. Solution2
Z= ́xμσ=25911.8270002100=0.51819D)using the z-score from part (C) Find P(Z<z-score) , you can find out the answer usingwww.wolframalpha.comfor example found the z-score was 1.5 if the z-score is 1.5 type in P(Z<1.5) into wolfram alpha.comSolutionP(Z<zscore)=P(Z<0.51819)=0.3022E)If there was a list of 10,000 estimates ranked from lowest to highest, what rank do youthinkyourestimatewouldbecloseto?Hint:justusetheformulaexpected rank = P(Z<z-score)*10000, remember to show your work. SolutionExpectedrank=P(Z<zscore)10000=0.302210000=3022Section2Use the dataset given below you must use the sample allocated to you based on your studentnumberhttps://app.box.com/s/yvhk3e3oymbs3toy6j5xetid82dsjyz4A)Use the PivotTable feature in excel to find appropriate summary statistics for yoursample, 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 n1and the proportion of high risk investments that made a loss ^p1*Just considering the low risk (safer type) investments what is the sample size =n2andWhat is the proportion of low risk investments that made a loss ^p2Solution3
Count of made a loss (L or P)?Column LabelsRow LabelsLPGrand Totalr135972s12728Grand Total1486100Count of made a loss (L or P)?Column LabelsRow LabelsLPGrand Totalr18%82%100%s4%96%100%Grand Total14%86%100%Riskier Type:n1 = 72^p1=1372=0.1806Safer Typen2= 28^p2=128=0.0357Use excel to make an appropriate graph that lets you compare the proportions found in parts A and paste this into your word document Solution4

## End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
|15
|2313
|1534

|10
|2284
|55

|12
|2331
|39

|11
|2103
|110

|18
|1639
|163

|11
|1700
|170

### Support

#### +1 306 205-2269

Chat with our experts. we are online and ready to help.