Using the heartsubset.jmp dataset that represents a sample of 606 patients who have undergone provider care for cardiovascular disease. A normal total cholesterol level for adults without heart disease is less than 200 mg/dL.

Based on the sample of patients, test the hypothesis that the average cholesterol value of cardiovascular patients is higher than 200 with a 99% level of confidence. State your conclusion clearly in the context of the problem. Show clearly the steps taken in the hypothesis testing process.

It is believed that cholesterol level is not significantly related to heart disease. If this is true, then the proportion of cardiovascular patients with desirable cholesterol levels would be around 50%. Get your marginal frequencies using Excel; then, by hand, conduct a 95% hypothesis test concerning this claim.