Statistics in Social Sciences

2. The following table gives information on the average saturated fat (in grams) consumed per day and the cholesterol level (in milligrams per hundred milliliters) for eight men. Fat 43 W consumption um level a) By using Microsoft Excel or Microsoft Words draw scattered diagram based on the information above. (3 Marks) b) Find the value of r. (3 Marks) c} From the scattered diagram. briey describe the relationship between the fat consumption and cholesterol level. (2 Marks} 2 Statistics in Social Sciences (53333134) CONFIDENTIAL January 2022Fr'naiExam1naon cl) Find the equation of the llne of best t using Least Square Method. (4 Marks) 9) Estimate the yield ofcholesteroi level. with the 63 grams of fat consumption. (3 Marks}