Consider the following table: Weights 25% 25% Risk Solvenc Repayme 10% Profitabilit 10% Liquidit 10% Financial 20% Collater Class y nt y y Efficiency al 1 X 2 X X 3 X 4 X 5 X Based on the above information, find the weighted average score using the single rating system. O 3.5 O 2.8 O 8.2 3.8

Please solve and demonstate how to apply this on excel using pivot table.

The data from 200 machined parts are summarizedas follows:y yesdepth of boreE, noabovebelowedge conditioncoarsetarget15target10moderatesmooth25205080(a) What is the probability that a part selected has a moderateedge condition and a below-target bore depth?(b) What is the probability that a part selected has a moderateedge condition or a below-target bore depth?(c) What is the probability that a part selected does not have amoderate edge condition or does not have a below-targetbore depth?(d) Construct a Venn diagram representation of the events inthis sample space.

Q4: An investor invests $1000 a month, on average, in a stock market security. Because the investor must wait for good "buy" opportunity, the actual time of purchase is random. The investor usu- ally keeps the securities for about 3 years on the average but will sell at random times when a good "sell" opportunity presents itself. Although the investor is generally recognized as a shrewd stock market player, past experience indicates that about 25% of the securities decline at about 20% a year. The remaining 75% appreciate at the rate of about 12% a year. Estimate the inves- tor's (long-run) average equity in the stock market. Hint: use the average number of securities in the market.