Question: Test the validity of the model. Explicitly specify the null and alternative hypotheses, and the reasons for either accepting or rejecting the null hypothesis. A


Test the validity of the model. Explicitly specify the null and alternative hypotheses, and the reasons for either accepting or rejecting the null hypothesis.








A B C D E F 1 Sales Direct Radio Newspaper Television 15.98 0.28 0.60 1.35 2.30 3 15.98 0.42 0.56 1.01 0.64 4 16.02 0.54 0.55 1.73 1.26 5 16.04 0.50 0.50 1.01 2.00 6 16.34 0.29 0.55 1.44 2.40 7 16.51 0.35 0.57 1. 19 0.98 8 16.58 0.31 0.60 1.71 1.94 9 16.62 0.49 0.59 1.35 1.69 10 16.69 0.32 0.71 2. 19 1.55 11 16.95 0.45 0.79 1.92 0.80 12 16.98 0.49 0.93 1.42 1.02 13 17.03 0.36 0.80 2.02 2.00 14 17.08 0.28 0.71 1.08 2.32 15 17.40 0.30 0.74 1.82 2.07 16 17.49 0.34 0.92 1.62 2.25 17 17.68 0.41 0.83 2.04 1.77 18 17.84 0.29 0.79 2.11 1. 18 19 17.88 0.35 0.92 1. 14 1.50 20 18.32 0.28 0.84 1.75 2.31 21 18.42 0.43 0.94 1.47 1.27 22 18.50 0.34 0.70 1.87 1. 14 23 18.86 0.49 0.72 1.98 1.61 24 18.91 0.49 0.76 1.68 2.04 25 18.96 0.25 0.64 1.17 2.07 26 19.52 0.31 0.57 1.81 2.3727 19.80 1.67 0.74 2.26 2.16 28 19.83 0.88 0.67 1.72 2.12 29 19.97 0.37 0.93 2.25 1.05 30 20.01 3.22 0.78 1.15 2.47 31 20.09 2.97 0.65 1.72 0.75 32 20.10 2.86 0.64 1.61 1.79 33 20.38 3.35 0.50 1.15 1.56 34 20.57 1.50 0.67 2.31 1.15 35 20.77 0.69 0.79 1.98 1.84 36 21.59 1.75 0.92 2.25 1.76 37 21.62 4.01 0.58 1.31 1.88 38 21.71 1.72 0.99 1.02 1.23 39 21.99 1.36 0.58 1.94 1.09 40 22.10 4.34 0.85 1.07 1.79 41 22.12 2.53 0.85 1.64 1.89 42 22.53 1.64 0.92 2.20 0.76 43 22.54 4.89 0.91 1.07 2.21 44 22.67 0.95 0.92 1.26 2.01 45 22.79 1.08 0.95 1.54 2.17 46 23.58 1.54 1.10 1.88 2.04 47 23.87 3.63 1.00 1.54 1.27 48 23.98 4.35 1.03 1.77 0.53 49 24.64 1.27 1.22 1.76 0.51 50 24.91 1.39 1.20 1.25 2.2951 25.47 4.76 1.20 1.79 1.71 52 25.47 0.26 1.25 2.31 0.53 53 22.02 0.88 0.85 1.81 1.91 54 15.41 1.23 0.98 1.95 2.00 55 23.57 1.12 0.90 2.50 0.79 56 23.41 1.30 0.75 1.39 1.15 57 23.36 0.72 0.53 1.07 1.08 58 19.41 1.30 0.51 1.79 1.47 59 20.34 0.88 0.86 1.64 1.02 60 16.52 0.98 0.51 1.89 1.53 61 19.88 0.85 0.55 1.45 1.68 62 18.14 1.02 0.51 1.97 1.64 63 23.65 1.37 0.85 1.63 1.06 64 15.77 1.07 1.00 1.79 2.28 65 16.51 1.27 0.98 2. 12 1.07 66 15.24 1.58 0.78 1.79 1.82 67 17.01 0.94 0.80 1.40 1.75 68 19.88 1.65 0.66 1.10 1.69 69 20.98 1.79 0.54 1.46 0.95 70 16.28 1.15 0.61 1.02 2. 19 71 18.76 1.72 0.65 1. 18 1.75 72 17.30 1.40 0.55 1.20 1.05 73 23.00 1.48 0.69 1.90 0.67 74 20.60 1.09 0.69 2.04 1.9875 22.02 0.57 0.85 1.56 2.40 76 23.56 0.50 1.00 1.84 2.30 77 22.72 1.26 0.76 1.67 1.53 78 17.94 0.40 0.79 1.79 0.99 79 19.64 0.68 0.69 1.57 2.35 80 16.61 1.43 0.50 1.25 2.40 81 23.47 1.40 0.67 1.61 0.90 82 20.27 1.08 1.00 1.55 1.33 83 22.16 0.88 0.89 1.72 1.51 84 18.90 1.24 0.78 1.98 1.71 85 16.06 0.49 0.66 1.95 2.38 86 20.14 1.13 0.86 1.77 1.26 87 17.43 1.91 0.50 1.01 0.96 88 21.75 0.92 0.84 2.24 0.63 89 22.33 0.78 0.77 2.23 1.01 90 23.18 0.26 0.74 2.45 1.81 91 22.84 0.54 0.61 1.24 2. 16 92 18.87 1.24 0.68 1.04 1.96 93 18.23 1.04 0.61 1.88 1.57 94 18.82 1.97 0.73 1.74 2.09 95 16.63 1.56 0.92 1.58 2.40 96 15.38 1.22 0.92 1.26 1.14 97 20.33 1.28 0.75 2.40 1.10 98 19.00 0.40 1.00 1.35 2.0599 16.44 1.70 0.59 1.32 1.63 100 18.33 1.71 0.98 1.49 1.73 101 20.94 0.73 0.59 1.38 1.59 102 19.97 0.37 0.73 2.41 0.60 103 24.23 2.34 1.21 1.42 1.93 104 15.90 2.59 1.06 1.07 2.16 105 15.43 0.82 1.08 2.00 2.10 106 20.06 2.89 1.19 1.09 1.72 107 20.14 2.33 0.87 1.83 1.90 108 21.29 2.32 0.98 1.96 0.92 109 19.10 2.26 0.55 1.68 1.64 110 24.61 1.49 1.19 1.63 1.17 111 22.86 0.53 0.59 1.18 0.84 112 23.07 0.94 0.96 1.97 2.17 113 24.29 2.96 0.66 1.28 0.85 114 24.01 2.57 0.76 1.32 1.96 115 21.35 2.92 0.91 1.34 1.74 116 22.31 1.46 0.91 1.26 0.95 117 18.75 0.32 0.78 1.74 1.37 118 23.87 1.98 1.03 1. 18 0.96 119 24.77 1.77 1.11 1.14 0.70 120 20.47 2.85 0.73 1.99 0.69 121 19.49 2.93 0.84 1.74 1.35 122 16.43 1.30 0.81 1.52 1.62123 18.41 1.25 1.16 1.86 2.24 124 16.41 1.87 0.92 1.02 1.95 125 22.77 2.59 1.09 1.69 1.24 126 21.74 1.84 0.56 1.17 0.75 127 20.65 2.93 1.07 1.25 1.32 128 18.17 0.77 0.88 1.42 2.04 129 24.15 0.81 1. 18 1.32 0.54 130 22. 15 0.50 0.85 1.33 2.13 131 22.42 1.69 0.66 1.61 2.34 132 17.93 0.94 0.97 1.62 2.27 133 18.03 0.98 1.18 1.07 1.43 134 22.34 2.96 0.90 1.55 1.07 135 20.90 0.68 1.23 1.17 2.33 136 18.53 0.31 1.13 1.85 1.73 137 17.32 1.24 1.00 1.12 0.64 138 15.63 0.34 1.03 1.11 1.27 139 22.06 1.36 1.19 1.96 1.64 140 24.66 0.39 0.59 1.46 1.81 141 22.53 1.03 0.90 1.17 0.64 142 20.33 1.51 1.14 1.02 1.18 143 19.64 1.36 1.11 1.97 0.90\fSUMMARY OUTPUT Regression Statistics Multiple R 0.471402 R Square 0.22222 Adjusted R 0.200764 Standard E 2.465224 Observatic 150 ANOVA df SS MS F ignificance F Regression 4 251.7721 62.94303 10.35702 2.09E-07 Residual 145 881.2126 6.077328 Total 149 1132.985 Coefficientsandard Err t Stat P-value Lower 95% Upper 95%Lower 95.0Upper 95.0% Intercept 16.72976 1.402576 11.92788 2.77E-23 13.95762 19.50189 13.95762 19.50189 X Variable 0.857524 0.206724 4.148159 5.68E-05 0.448943 1.266106 0.448943 1.266106 X Variable 2.768272 0.99241 2.789445 0.00599 0.806814 4.729729 0.806814 4.729729 X Variable 0.850572 0.543325 1.565493 0.119647 -0.22329 1.924433 -0.22329 1.924433 X Variable -1.03073 0.366358 -2.81346 0.005582 -1.75483 -0.30664 -1.75483 -0.30664 The regression function is sales= 16.73+0.86direct+2.77radio+0.85newspaper-1.03TV
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
