GSU is trying to predict how price of books predict the quantity of books sold over the semesters. Perform a liner regression analysis, and and find the best model to predict quantity of books to stock in the book store. Make recommendation at setting the prices and quantity at their optimum values for maximizing quantity of books sold. Be prepared to discuss your analysis. Quantity Price 180 475 590 400 430 450 250 550 275 575 720 375 660 375 490 450 700 400 210 500

1. An analyst from your firm used a linear demand specification to estimate the demand for its product and sent you a hard copy of the results: SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Regression Residual Total Intercept Price of X Income 0.38 0.14 0.13 20.77 150 df 2 147 149 SS 58.87 -1.64 1.11 10398.87 63408.62 73807.49 Coefficients Standard Error 15.33 0.85 0.24 MS 5199.43 431.35 t Stat 3.84 -1.93 4.63 F 12.05 P-value 0.00 0.06 0.00 Significance F 0 Lower 95% 28.59 -3.31 0.63 Upper 95% b. Which regression coefficients are statistically significant at the 5 percent level? a. Based on these estimates, write an equation that summarizes the demand for the firm's product. 89.15 0.04 1.56 C. When price is $10, what is the income elasticity for this product for an income level of 35?

A company sets different prices for a particular DVD system in eight different regions of the country. The accompanying table shows the numbers of units sold and the corresponding prices (in dollars). Sales 420 380 350 400 440 380 450 420 Price 104 195 148 204 96 256 141 109a. Graph these data, and estimate the linear regression of sales on price. b. What effect would you expect a $50 increase in price to have on sales?

Please don't provide hand written solution

6

5.2 42 The following regression shows the impact of the number of rooms (ROOM) on the monthly rent of an apartment (in thousand Rands) (RENT) from a sample of 42 randomly chosen apartments in Parow: Dependent Variable: RENT Variable C ROOM r-square: 0.7180 Parameter -0.7705 2.1331 SE of regression: 2.3397 Std. Error 0.8233 0.2114 sample size = 42 What will be values of the parameters, variance and standard errors of the parameters, estimated variance of error terms, coefficient of determination and correlation coefficient, if RENT is measured in Rands and there is no change to the unit of measurement of the ROOM variable?

An analyst working for your firm provided an estimated log-linear demand function based on the natural logarithm of the quantity sold, price, and the average income of consumers. Results are summarized in the following table: SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Regression Residual Total Intercept LN Price LN Income df 0.968 0.937 0.933 0.003 30 SS MS F 2 0.003637484 0.001818742 202.48598 0.000242516 8.98206E-06 27 29 0.00388 Coefficients Standard Error 0.57 0.00 0.13 0.51 -0.08 0.15 t Stat 0.90 -19.50 1.13 P-value 0.37 0.00 0.27 Significance F 5.55598E-17 Lower 95% -0.65 -0.09 -0.12 How would a 4 percent increase in income impact the demand for your product? Demand would increase by 60 percent. Demand would increase by 0.6 percent. Demand would decrease by 60 percent. Demand would decrease by 0.6 percent. Upper 95% 1.68 -0.07 0.41

QUESTION 17 I am trying to figure out how to measure an athlete's productivity. So, I have run a linear regression of a NBA player's salary (dependent variable) on a player's statistics including average points, assists, rebounds per game, and turnovers per game (the independent variables). The final model is: Salary = 1,000,000 * Points per game + 50,000 * Assists per game + 20,000 * Rebounds per game - 30,000 * Turnovers per game %3! Last year, Lebron James averaged 25 points per game, 8 assists per game, 8 rebounds per game and 4 turnovers per game. What is Lebron's predicted salary?

Suppose the Sherwin-Williams Company is interested in developing a simple regression model with paint sales (Y) as the dependent variable and selling price (P) as the independent variable. Complete the following worksheet and then use it to determine the estimated regression line. Sales Region Selling Price ($/Gallon) Sales (x 1000 Gal) i 2 Zi Yi Zith 1 15 160 2,400 225 25,600 2 13.5 220 2,970 182.25 48,400 3 16.5 140 2,310 272.25 19,600 4 14.5 190 2,755 210.25 36,100 5 17 140 2,380 289 19,600 6 16 160 2,560 256 25,600 7 13 200 2,600 169 40,000 8 18 150 2,700 324 22,500 9 12 220 2,640 144 48,400 10 15.5 190 2,945 240.25 36,100 Total 151 1,770 2,312 Regression Parameters Estimations Slope (B) Intercept (a) In words, for a dollar increase in the selling price, the expected sales will What is the standard error of the estimate (&)? O 14.889 12.180 13.342 gallons in a given sales region. What is the estimate of the standard deviation of the estimated slope (86)? O 2.636 2.157 2.362 Can you…

Expedia wants to use regression analysis to build a model for airfare tickets prices in the states: Ticket prices = 30 + B1*Miles + E where Miles is measured in hundreds Coefficients 169.50 5.90 Intercept Miles (in hundreds) Which of the following is true? Standard Error 1.34 0.09 4 t Stat 126.85 61.28 P-value 0.000 0.002 If Miles increases by 1, then we predict ticket price to go up by $5.9. O If ticket price goes up by $1, then we predict Miles to go up by 590 miles. O If ticket price goes up by $100, then we predict Miles to go up by 590 miles. If Miles increases by 100, then we predict ticket price to go up by $5.9.