Hello. I want to solve this question on the Excel application with very clear steps because I am beginner in using Excel
1. I The K-Distribution company owns and operates convenience stores in each of the major domestic cities. The K Distribution company wants to estimate Weekly press teven convenience stores in & major cities are as follows (30 scores) Major cities Weekly Gross Revenue TV advertising ($100s) Newspaper advertising ($100) (S1005) Secul 238 5.0 8.4 Gyungsi 220 6.9 5.8 Incheon 138 3.6 4.0 Daejeon 126 43 43 Gwangju 101 3.5 2.3 Busan 101 5.0 1.5 Pohang 75 4.0 1.5 Ulsan 52 3.0 3.0 ind variable. (10 scores) 1.1) Develop an estimated regression equation with both TV advertising and newspaper advertising an 1.2) Test whether each of the regression parameters beta, betal, and beta2 is equal to 0 at a 0.05 level of significance [Hint Explain the hypothesis result using p-value 1.3) Plot the residual for two independent variables and explain why it needs to plot the residual. (10 scores) 1x OBRA .. Type here to search VO 1. The K-Distribution company owns and operates convenience stores in each of the major domestic cities. The K-Distribution compa cuvenience stores in major cities are as follows (30 scores) Major cities Weekly Gross Revente TV advertising (5100s) Newspaper advertising ($1008) (5100s) Seoul 238 5.0 8.4 Gym 220 6.9 5.8 Incheon 138 3.6 4.0 Daejeon 126 43 43 Gwanja 101 3.5 23 Busan 101 5.0 15 Polang 75 40 1.5 Ulsan 32 3.0 3.0 11) Develop an estimated regression equation with both TV advertising and newspaper advertining as the independent variable 1.2) Test whether each of the regression parameters betao, betal, and beta2 is equal to 0 at a 0.05 level of significance (Hint: Explain 13) Plot the residual for two independent variables and explain why it needs to plot the residual (10 scores) 10 Type here to search 20vo x 1. I The K-Distribution company owns and operates convenience stores in each of the major domestic cities. The K Distribution company wants to estimate Weekly press teven convenience stores in & major cities are as follows (30 scores) Major cities Weekly Gross Revenue TV advertising ($100s) Newspaper advertising ($100) (S1005) Secul 238 5.0 8.4 Gyungsi 220 6.9 5.8 Incheon 138 3.6 4.0 Daejeon 126 43 43 Gwangju 101 3.5 2.3 Busan 101 5.0 1.5 Pohang 75 4.0 1.5 Ulsan 52 3.0 3.0 ind variable. (10 scores) 1.1) Develop an estimated regression equation with both TV advertising and newspaper advertising an 1.2) Test whether each of the regression parameters beta, betal, and beta2 is equal to 0 at a 0.05 level of significance [Hint Explain the hypothesis result using p-value 1.3) Plot the residual for two independent variables and explain why it needs to plot the residual. (10 scores) 1x OBRA .. Type here to search VO 1. The K-Distribution company owns and operates convenience stores in each of the major domestic cities. The K-Distribution compa cuvenience stores in major cities are as follows (30 scores) Major cities Weekly Gross Revente TV advertising (5100s) Newspaper advertising ($1008) (5100s) Seoul 238 5.0 8.4 Gym 220 6.9 5.8 Incheon 138 3.6 4.0 Daejeon 126 43 43 Gwanja 101 3.5 23 Busan 101 5.0 15 Polang 75 40 1.5 Ulsan 32 3.0 3.0 11) Develop an estimated regression equation with both TV advertising and newspaper advertining as the independent variable 1.2) Test whether each of the regression parameters betao, betal, and beta2 is equal to 0 at a 0.05 level of significance (Hint: Explain 13) Plot the residual for two independent variables and explain why it needs to plot the residual (10 scores) 10 Type here to search 20vo x
