Answer using Excel: Show steps

A new machine will bring savings to the company. Calculate the expected value and standard deviation of savings if the probability distribution of the possible scenarios is as follows:

saving. probability

$40,000 .2

$35,000 .5

$30,000 .3

Fill in the blanks:

The expected value is $ ______ Answer . The standard deviation is $_____Answer 2 points.

To receive credit results must match submitted procedures.

b) Send the calculations made to arrive at the answer through the Spreadsheet icon.