please solve it in excel step-by-step and show me the way how to solve it in excel

Question 2 Research on consumer attitudes and behaviours are usually conducted by consumer research companies. One of such companies is approached by a client who requested to conduct a study and asked for an investigation of consumer characteristics that can be used to predict the amount charged by credit card users. Data were collected on annual income, household size, and annual credit card charges for a sample of 50 consumers as shown in Table 2. Table 2 Income Household Amount (1000s) Charged Size 5 988888888 2 3 2 27 33 65 63 42 21 44 37 62 21 55 NON NON-WANNAN () 4,016 3,159 5.100 4.742 1.864 4,070 2.731 3.348 4.764 4.110 4.208 4.219 2.477 2,514 4.214 4,965 4,412 2.448 2.995 4,171 5678 3.623 5,301 3.020 4,828 5.573 2,583 3,866 3,586 5,037 E 42 2 6 41 54 30 48 34 67 5 3 NON 2 5 6 50 67 55 52 62 64 22 29 39 35 39 54 23 27 26 61 30 22 46 2 3 2 3 4 2 1 4 3 6 2 7 3,605 5,345 5,370 3,890 4,705 4,157 3,579 3,890 2,972 3,121 4,183 3,730 4,127 2,921 4,603 4,273 3,067 3,074 4,820 5,149 2 2 4 5 4 66 Produce your own spreadsheet models and present answers for the following. (1) Develop estimated regression equations, first using annual income as the independent variable and then using household size as the independent variable. Which variable is the better predictor of annual credit card charges? [9] (ii) Develop an estimated regression equation with annual income and household size as the independent variables. [7] (ii) What is the predicted annual credit card charge for a three-person household with an annual income of 40,000? [2]