logo

Exploring a Dataset: Summary, Confidence Interval, and Risk Analysis

   

Added on  2019-11-08

15 Pages2313 Words1534 Views
 | 
 | 
 | 
Title: bus105 computing assignment semester 2, 2017 Name:Student number:Allocated sample: 18
Exploring a Dataset: Summary, Confidence Interval, and Risk Analysis_1

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.1847x−7256.3With an income of $200,000 we have annual contribution s;y=0.1847∗(200000)−7256.3y=$29,683.7Thus the estimated annual contribution is $29,683.72
Exploring a Dataset: Summary, Confidence Interval, and Risk Analysis_2

C)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. SolutionZ= ́x−μσ=29683.7−270002100=1.277952D)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<z−score)=P(Z<1.277952)=0.8994E)If there was a list of 10,000 estimates ranked from lowest to highest, what rank do youthinkyourestimatewouldbecloseto?Hint:justusetheformulaexpected rank = P(Z<zscore)*10000, remember to show your work. SolutionExpectedrank=P(Z<z−score)∗10000=0.8994∗10000=8994Section2Use 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 ^p23
Exploring a Dataset: Summary, Confidence Interval, and Risk Analysis_3

SolutionCount of made a loss (L or P)?Column LabelsRow LabelsLPGrand TotalRiskier Type165672Safer Type42428Grand Total2080100Count of made a loss (L or P)?Column LabelsRow LabelsLPGrand TotalRiskier Type22.22%77.78%100.00%Safer Type14.29%85.71%100.00%Grand Total20.00%80.00%100.00%Riskier Type:n1 = 72^p1 = 0.2222Safer Typen2= 28^p2 = 0.1429B)Use excel to make an appropriate graph that lets you compare the proportions found in parts A and paste this into your word document Solution4
Exploring a Dataset: Summary, Confidence Interval, and Risk Analysis_4

End of preview

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

Related Documents