Please answer (e,f,g) only.Use Excel to calculate different statistical measures. You must include excel codes or steps of solving your assignment. An economist is interested in the relationship between the disposable incomeof a family and the amount of money spent annually on food. For a preliminarystudy. the economist takes a random sample of TEN middle-income families of thesame size father. mother, two children). The results are as follows, where x denotesdisposable income. in thousands of dollars. and y denotes food expenditure. inhundreds of taka.x 30 36 27 20 16 24 19 25 20 34y 55 60 42 20 17 26 39 43 40 51a.. Identify the predictor and response variables.b. Determine the correlation coefficient and coefficient of determination andcomment on them.c. Determine the regression equation for the data.d. Graph the regression equation and the data points.e. Describe the apparent relationship between disposable income and annualfood expenditure.f. What does the slope of the regression line represent in terms of disposableincome and annual food expenditure?g. Use the regression equation to predict the annual food expenditure of afamily with a disposable income of Tk25000.

Name: Please answer (e,f,g) only.Use Excel to calculate different statistica
Uploaded: 2022-11-23T13:49:28.000Z
Channel: Bartleby
Description: Please answer (e,f,g) only.Use Excel to calculate different statistical measures. You must include excel codes or steps of solving your assignment. An economist is interested in the relationship between the disposable incomeof a family and the amount