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

+13062052269

info@desklib.com