Use Excel to estimate the linear OLS demand regression for the iTunes focus group data in the Managerial Solution. What is the R²? What are the coefficient estimates, the standard errors and the t-statistics for each coefficient? Using a 95% confidence criterion, would you reject the hypothesis that the price coefficient is zero? (You can compare most of your answers to those in the Managerial Solution). Price, $ per song 1.49 1.29 1.19 1.09 0.99 0.89 0.79 0.69 0.49 Quantity, songs per year 441 493 502 536 615 643 740 757 810 The regression's R² value is 96. (Enter your response rounded to two decimal places.) Using the Excel trendline option to estimate a linear demand function, the linear demand function is Q= 1023.9412.82 p. (Enter your response rounded to two decimal places.) The standard error on the intercept is .12 and the standard error on the price coefficient is 2.42. (Enter your response rounded to two decimal places.)

You have the following two data points for a process undergoing learning: Y3 = 50 and Y7 = 35 What is the best equation to use for prediction? Group of answer choices Yx = 84.2 x-0.2324 Yx = 77.6 x-0.5323 Yx = 79.4 x-0.4210 Yx = 80.7 x-0.3365 insufficient information

You need to use Stata to look up the dataset and its variables. Use Stata Companion Textbook. (Dataset: NES. Variables: spend8, [pw=nesw].) The NES dataset contains spend8, which records the number of government policy areas where respondents think spending should be increased. Scores range from 0 (the respondent does not want to increase spending on any of the policies) to 8 (the respondent wants to increase spending on all eight policies). The NES, of course, polls a random sample of U.S. adults. In this exercise you will analyze spend8 using the mean and lincom commands. You then will draw inferences about the population mean. (Remember to specify nesw as the probability weight.) The spend8 variable has a sample mean of ______. Make sure you use [pw=nesw] so your results are nationally representative. There is a probability of .95 that spend8’s true population mean falls between a score of ______ at the low end and a score of ______ at the high end. A student researcher…

Describe in detail the results achieved on the company’s test. Ignore other variables for now, just describe the test results. If the company is considering training for the lowest 10% of employees what score would they need to achieve to be exempted from training?   Test Result 163 148 142 173 168 155 163 194 119 124 149 171 160 104 165 154 122 160 148 138 158 112 189 163 203 165 176 152 74 129 166 134 124 169 187 163 172 195 149 107 156 183 133 83 148 127 173 95 139 179 136 153 141 155 179 152 129 155 145 113 142 147 171 139 174 143 96 199 143 172 123 146 128 187 138 163 178 154 199 164 123 201 205 135 123 138 195 184 165 196 154 176 82 173 156 149 152 116 174 141 111 74 123 182 157 141 167 162 172 107 149 182 112 135 177 159 138 163 148 198…