Consider the following Excel regression of perceived sound quality as a function of price for… 1 answer below »

Question 2: (10 marks)
Consider the following Excel regression of perceived sound quality as a function of price for 27 stereo speakers.
a. Is the coefficient of Price significantly different from zero at a = .05?
b. What does the R2 tell you?
c. Given these results, would you conclude that a higher price implies higher sound quality?
Question3: (10 marks)
After researching cysts of a particular type, a doctor learns that out of 10,000 such cysts examined, 1,500 are malignant and 8,500 are benign. A diagnostic test is available which is accurate 80% of the time (whether the cyst is malignant or not). The doctor has discovered the same type of cyst in a patient.
a. In the absence of any test, what is the probability that the cyst is malignant? What is the probability that the cyst is benign?
b. What is the probability that the patient will test positive?
c. What is the probability that the patient will test negative?
d. What is the probability that the patient has a benign tumor if he or she tests positive?
e. What is the probability that the patient has a malignant cyst if he or she tests negative?