help me to compute the following questions you help will be highly appreciated if you dont understand or need a any clarification just drop a message in the inbox
\f\fLike the following data for Question 1 and 2: Cardiovascular divine [CVD] is a paneral term that describes a disease of the heart or blood vessel. Cardiovascular disease is a big health problem and the leading cause of death worldwide. Malaysia is one of the many developing countries in the world which reported to have a rising incidence rate of cardiovascular disease. The risk of getting the disease can be greatly reduced by avoiding the risk factors of the dismis such as tobacco exposure, high blood pressure, bich cholamind dueisin clerical madliving, diabeing unhealthy diets, and harmful use of alcohol. The Data The dataget contains information from a survey among 100 residents in Klang Valley, Kuala Lumpur, Malaysia to investigate the characteristics, habitual and 10 loved of the people and the iisociation between several risk factors of cardiovascular disease. "You can download the data in an Excel file named "AssignmentDoto-BF1047520.is" from Assignment folder in the MMLS The list below explains the description of the related variables in the Excel sheets. Forable Apa Age of the person in years Smoking Habit The smoking status of the parson! O- doas not smoke i - smokes loss them one pack per day 2 - smokes one or more than one pack per day Weight Body weight of the person in pounds SerumCha Level of serum cholesterol of the person in milligram Standard IQ test score values of the person Gander Gander of the parson; Me male ;F - female Question 1 120 Market a. For each the folowing variables in Table 1. ponerate the output of Buccipower Storiaies using Excel functions. [& marks] Variable weight 10 score Serum cholesterol b. Briefly describe what the statistics reveal about the characteristics (variables in Table 1) of the residents in Klang Valley, Kuala Lumpur. (12marka] The statistics should include the mean, median, standard deviation and the slowmass for each of the variablest.Question 2 125 Marks] a. Construct the 95 percent confidence intervals of the population mean of IQ scores for both male and female residents of Klang Valley. Is the mean of the population IQ scores falls within the confidence interval? Explain. [15 marks] Consider the following information: " Use data in Spreadsheet (Question 20) to compute the sample mean and its standard deviation. Given that the population means are = 118 and #=116. b. Compare the proportion of men who are smokers with proportion of women who are smokers. Is there enough evidence to conclude that the number of male residents who smoke is higher compared to female residents. [Use data in Spreadsheet (Question 26) [10 marks] Question 3 [25 Marks] The data (in EXCEL spreadsheet - tab: Question ]] come from a sample of employed men aged between 18 and 67, who were asked whether, in the preceding year, they had carried out work on their home which they would previously have employed a craftsman to do the work. The response variable is the answer (yeso) to that question. There are four categorical explanatory variables related to the respondents (sample]: Variable Description Age group Under 30; 31 to 45; over 45 Accomodation type Apartment; House Tenure Rent; Own Type of occupation Skilled; Unskilled; Office Answer the following questions: a. Choose TWO variables and generate a tree diagram using the given data. Define your variables and compute the necessary probabilities for the tree diagram. [12 marks] b. Based on tree diagram in (a) compute the related marginal probabilities and conditional probabilities between both selected variables. Show the working of computing the probabilities. [# marks] c. Find the probabilities of respondents who worked at office, own the house and did employed craftsman on their homes. Find the probabilities of respondents who have unskilled profession, own the house and also did employed craftsman on their homes. Discuss the difference of the probabilities in (i) and [ii]- [5 marks]