BUS105- Computing Assignment Final Report
Added on 2019-11-26
11 Pages1700 Words170 Views
Running Head: BUS105 COMPUTING ASSIGNMENT: FINAL REPORTStudent Name:Student ID:Course: Professor Name:Date Submitted:BUS105 Computing Assignment: Final ReportSemester 2, 2017Allocated Sample Number: 7Page 1 of 11
BUS105 Computing Assignment: Final Report Rana Abdul Sammad, 11502174Semester 2, 2017Section 1(A)Scatter Plot:$50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $5,000 $15,000 $25,000 $35,000 $45,000 $55,000 $65,000 f(x) = 0.17 x − 4018.18Scatter Plot between Income and Annual Contribution to SavingsIncomeannualcontributionAs observed from the scatter plot above, a linear, positive slope relationship exists between the two numerical variables. Therefore, it can be stated that the annual contribution to savings (in $) increases with an increase in annual income (in $) and decreases with a decrease in annual income.(B)The regression equation for the above model is given by:y=0.1668x−4018.2where x=Income($) and y=Annualcontribution¿savings($)Therefore, for an annual income of $200,000:Annual Contribution y=0.1668(200000)−4018.2y=$29,341.8(C)Given that μ=$27,000 and σ=$2,100 Therefore, z-score is computed as:z=x−μσ=29341.8−270002100≈1.12(D)Using an online calculator P(Z<1.12)=0.8676Page 2 of 11
BUS105 Computing Assignment: Final Report Rana Abdul Sammad, 11502174Semester 2, 2017(E)Expected rank = P(Z<1.12)×10000≈0.8676×10000≈86760Section 2(A)The overall combined Pivot table below describes the proportion of high risk (riskier type) investments that made a loss ^p1 and also the proportion of low risk (safer type) investments that made a loss ^p2:Investment Type/Proportion of Profit and LossColumn LabelsRow LabelsLossProfitGrand Totalrisky0.200.801.00safe0.170.831.00Grand Total0.190.811.00As observed, ^p1=0.20 while ^p2=0.17(B)Comparison Bar Chart:(C)As observed from the Pivot table and the bar-chart above, overall, high risk (or risky) investments have a comparatively lesser chance to make a profit than low-risk or safer investments.(D)^p1−^p2 is the point estimate of p1−p2, computed as:⟹^p1−^p2=0.20−0.17=0.03Page 3 of 11
BUS105 Computing Assignment: Final Report Rana Abdul Sammad, 11502174Semester 2, 2017Accordingly, z-score is:z=0.03−0.10.0743≈−0.942Therefore, using online calculator P(Z<−0.942)=0.1731Expected rank = P(Z<−0.942)×4000≈0.1731×4000≈692(E)The hypotheses are stated as:Null H0:p1−p2=0i.e.p1=p2Alternative Ha:p1−p2≠0i.e.p1≠p2Here, p1−p2 is the hypothesized difference of population proportions. The null hypothesis is rejected if the difference is statistically significant at a significance levelof 5%, i.e. for α=0.05.To test the hypothesis, a two-tailed (non-directional) z-test is used.Further, following information is computed in Excel:Investment Type/COUNT of Profit and LossColumn LabelsRow LabelsLossProfitGrand Totalrisky145670safe52530Grand Total1981100Uisng the above table and information from part A above, the respective values are put in the online calculator (http://epitools.ausvet.com.au/content.php?page=z-test-2).Obtained results are summarized below:Page 4 of 11
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
BUS105 Computing Assignment Business Statisticslg...
|16
|1318
|31
bus105 Business Statistics - Computing Assignmentlg...
|15
|2313
|1534
BUS105 Business Statistics Computing Assignmentlg...
|15
|2448
|75
Bus105 Computing | Assignmentlg...
|19
|1427
|56
BUS105 Computing Assignment - (Doc)lg...
|9
|995
|44
Computing Assignment Regression Basicslg...
|18
|530
|78