Hi! Pleae use Excel decision tree add-in, and show the work. Thank you!
Carlie needed a personal computer (PC) for school but her budget was tight, so she decided on a used machine. After some searching, she was down to two possibilities. One she had found in a national franchized computer store, where she could purchase the PC for $800 with a one-year guarantee. But she was intrigued by a second possibility: a local charity store was offering a used machine that had been donated (exactly the same model as in the store) for $500. Carlie talked to a computer repair specialist, who said the principal problem with this model of PC was the hard drive, which was prone to failure: he estimated that half of the PCs of this model and age would require a new drive. He offered to test the computer and check the condition of the drive for $60. If the drive was no good, a new drive could be fitted for $300 and would be guaranteed for one year. He added a qualification that his testing was not perfect: about 25% of drives that passed his testing failed soon afterwards requiring a new drive ($300) plus a service charge of $100 for diagnosing the problem (a cost that has to be paid with the fitting of a new drive). Please only enter an integer if a numerical answer is required.
The expected cost of buying the second hand computer from charity is
Carlie would be better off to buy the computer with a one-year guarantee for $800.
Carlie would expect to save $ with the test before purchase.
If the second hand computer passes the test, then its expected cost is $ .
Carlie should A. buy the second hand computer only if it passes the test. B. buy the second hand computer without taking the test. C. still buy the second hand computer even if it fails the test.